| Check RMAN Catalog [message #346431] |
Mon, 08 September 2008 09:55  |
deepmachine
Messages: 80
Registered: August 2008
Location: United States
|
Member |
|
|
How to check whether a recovery catalog exists or not? And if it does exist, who is the owner?
Thanks
|
|
|
|
| Re: Check RMAN Catalog [message #346432 is a reply to message #346431] |
Mon, 08 September 2008 10:04  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Catalog is not created by default.
Catalog usually is a just another Oracle database used to store information on RMAN backups.
If you acquired a database / RMAN infrastructure, check the backup scripts.
If it is explicitly connecting to an separate RMAN database using
keywords like "connect catalog" or "connect rcvcat", it might be using a catalog.
There are no tandard rules to identify.
Because, even if there is a catalog database, the target database can be backed up without using it (i mean, using controlfile).
Edit:
To add, inside a catalog, there might be many users/accounts to hold
information on different target database.
querying views like rc_database in each catalog will identify the target database it is registered with.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcviews027.htm
[Updated on: Mon, 08 September 2008 10:14] Report message to a moderator |
|
|
|
| Re: Check RMAN Catalog [message #346447 is a reply to message #346432] |
Mon, 08 September 2008 10:36 |
deepmachine
Messages: 80
Registered: August 2008
Location: United States
|
Member |
|
|
Thanks for your insight.
My goal is that I want to know whether the RMAN has any recovery catalog or not. Right now, the script only uses:
Does this tell that I don't have any catalog? Is there any other way to check whether it has a catalog?
Thanks again.
|
|
|
|
|
|
|
|
| Re: Check RMAN Catalog [message #346463 is a reply to message #346456] |
Mon, 08 September 2008 11:22 |
deepmachine
Messages: 80
Registered: August 2008
Location: United States
|
Member |
|
|
Bundle of thanks to both of you guys.
However, what if I fire the following command?
1- Would it still not tell if it has a catalog or not?
2- If I see my archived log files piling up in one of the ASM storage disks, does this mean that RMAN is not taking backup?
P.S. The command from script in my previous post, is not running as the script is not setup in cron job.
|
|
|
|
|
|
| Re: Check RMAN Catalog [message #346497 is a reply to message #346467] |
Mon, 08 September 2008 13:52 |
deepmachine
Messages: 80
Registered: August 2008
Location: United States
|
Member |
|
|
| Quote: | if it is configured and if RMAN was asked to delete the archives after it backs it up
|
Ok, so that raises two more questions.
1- If RMAN was configured to delete the archived redo files after backup, can point-in-time receovery still be done by specifying the SCN? If your answer to this is YES, then I would like to configure the RMAN to delete the Archived_redo_log files after backup.
2- What CONFIGURE command to type on RMAN> in order to setup auto deletion?
Thanks again.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
