Home » RDBMS Server » Backup & Recovery » Recovery Catalog (Windows XP SP3)
Recovery Catalog [message #502828] Sun, 10 April 2011 12:26 Go to next message
rajsoft88
Messages: 10
Registered: April 2011
Location: delhi
Junior Member
Why can SYSDBA not be the owner of Recovery Catalog himself?


Regards:
Rajkumar
Re: Recovery Catalog [message #502829 is a reply to message #502828] Sun, 10 April 2011 12:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Separation based on usage.
catalog owner / recovery_catalog_owner role is way less significant than SYSDBA and you want to keep the catalog in a separate tablespace other than SYS/SYSAUX.
SYSDBA should not be used for any regular day-to-day activities in database and meant only for very special operation.

Re: Recovery Catalog [message #502830 is a reply to message #502828] Sun, 10 April 2011 12:39 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
-assigning the role recovery_catalog_owner restricts privileges
-you may need sometimes to export recovery catalog
Re: Recovery Catalog [message #502831 is a reply to message #502830] Sun, 10 April 2011 12:51 Go to previous message
rajsoft88
Messages: 10
Registered: April 2011
Location: delhi
Junior Member
thanks....
Previous Topic: Archive Log Errors
Next Topic: restore database
Goto Forum:
  


Current Time: Thu Mar 28 14:01:42 CDT 2024