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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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

Report message to a moderator

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....

Report message to a moderator

Previous Topic: Archive Log Errors
Next Topic: restore database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 21 11:37:40 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.