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
aakashbabu83
Messages: 4
Registered: May 2012
Location: Aligarh
Junior Member

How can be identify a particular archivelog file have backup or not from rman catalog ?

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

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"

Thanks,
Vij

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 17:14:00 CDT 2013

Total time taken to generate the page: 0.52606 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.