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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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: Thu Feb 13 06:47:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.