Home » RDBMS Server » Backup & Recovery » how to cross check /test weather the backup is fine
how to cross check /test weather the backup is fine [message #217424] Fri, 02 February 2007 02:37 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
Hi to every one,

i want to knwo how to crosscheck/test the backup is fine or not?
i want to check
cold backup
hot backup
rman backup

thanks
Re: how to cross check /test weather the backup is fine [message #217434 is a reply to message #217424] Fri, 02 February 2007 03:17 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Check your "Recovery Manager Reference" Guide. For example, for 10g:

RESTORE ... VALIDATE

"Lets RMAN decide which backup sets, datafile copies, and archived logs need to be restored, and then scans them to verify their contents. No files are restored. Use VALIDATE to verify that the backups required to restore the specified files are intact and usable."
Re: how to cross check /test weather the backup is fine [message #217596 is a reply to message #217424] Fri, 02 February 2007 23:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

cold backup
Create dummy database with help of cold backup and check.

hot backup
rman backup
1.CROSSCHECK command >>>> all backup are exists on disk if not the mark expired. and you are use "DELETE EXPIRED BACKUP" to delete logical entry in database.

The term obsolete does not mean the same as expired.
RMAN>crosscheck backup;
RMAN> crosscheck archivelog all;
In short, obsolete means "not needed," whereas expired means "not found."
RMAN> delete expired backup;
RMAN> delete expired archivelog all;
The CROSSCHECK command does not delete operating system files or remove repository records. You must use the DELETE command for these operations


Tests and Integrity Checks for Backups
You can use the BACKUP VALIDATE and RESTORE VALIDATE commands to test backup and restore operations
RMAN> backup validate database;
RMAN> backup validate database archivelog all;

RMAN> restore validate database;
RMAN> restore validate database archivelog all;


Regards
Taj
Previous Topic: Problem with duplicate database using rman
Next Topic: Oracle 9i RMAN/Redo log files Problem
Goto Forum:
  


Current Time: Fri Dec 02 14:18:00 CST 2016

Total time taken to generate the page: 0.09682 seconds