|
|
| 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   |
Frank Naude
Messages: 4579
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
