Home » RDBMS Server » Backup & Recovery » Check RMAN Catalog
Check RMAN Catalog [message #346431] Mon, 08 September 2008 09:55 Go to next message
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

Report message to a moderator

Re: Check RMAN Catalog [message #346432 is a reply to message #346431] Mon, 08 September 2008 10:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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:

rman target /


Does this tell that I don't have any catalog? Is there any other way to check whether it has a catalog?

Thanks again.

Report message to a moderator

Re: Check RMAN Catalog [message #346451 is a reply to message #346447] Mon, 08 September 2008 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
rman target /

Already answered it.
It indicates that RMAN is asked to look into the local database (identified by ORACLE_SID) as target database (database to be backed up).
Thats it.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup003.htm#sthref221

Report message to a moderator

Re: Check RMAN Catalog [message #346456 is a reply to message #346447] Mon, 08 September 2008 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to know if there is a catalog.

Regards
Michel

Report message to a moderator

Re: Check RMAN Catalog [message #346463 is a reply to message #346456] Mon, 08 September 2008 11:22 Go to previous messageGo to next message
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?

DROP CATALOG;


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.

Report message to a moderator

Re: Check RMAN Catalog [message #346467 is a reply to message #346463] Mon, 08 September 2008 11:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That command will make any sense if you are connected to catalog.
>> 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?
May be or may not be.
Depends on rman backup frequency, if it is configured and if RMAN was asked to delete the archives after it backs it up (some shops still manually purge archives).

Report message to a moderator

Re: Check RMAN Catalog [message #346497 is a reply to message #346467] Mon, 08 September 2008 13:52 Go to previous messageGo to next message
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.

Report message to a moderator

Re: Check RMAN Catalog [message #346515 is a reply to message #346497] Mon, 08 September 2008 14:48 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> 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

Ofcourse yes.
>>2- What CONFIGURE command to type on RMAN> in order to setup auto deletion?
Nothing.
Read the docs / any decent book on RMAN before attempting to do anything.
use "delete input" option.
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup003.htm

Report message to a moderator

Previous Topic: Restore database from Backup.
Next Topic: types of backups in rman
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 16:14:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.