Home » RDBMS Server » Backup & Recovery » Rman catalog (oracle 10g or 11g)
Rman catalog [message #556028] Wed, 30 May 2012 12:04 Go to next message
Messages: 4
Registered: May 2012
Location: Aligarh
Junior Member

How can be identify a particular archivelog file have backup or not from rman catalog ?
Re: Rman catalog [message #556034 is a reply to message #556028] Wed, 30 May 2012 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You do not backup from rman catalog, you back up with rman and register the backup into the catalog.
Query the catalog to know which backups are registered in it.

Re: Rman catalog [message #556178 is a reply to message #556028] Thu, 31 May 2012 13:21 Go to previous message
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member

In rman prompt you need to run the following command
RMAN>change archivelog all crosscheck;

If suppose any arhivelog file is missing or not backedup it will shows "unavailable"

Previous Topic: Execute BATCH FILE through PLSQL
Next Topic: backup control file to trace
Goto Forum:

Current Time: Sun Oct 23 15:58:46 CDT 2016

Total time taken to generate the page: 0.08529 seconds