Tuesday, August 11, 2009

Restore validate using RMAN

Use RESTORE VALIDATE commands to validate RMAN backups to be sure they can be used for a restore.

Use below command to test most recent RMAN backup:
RMAN> restore validate database;

Use below command to test the most recent RMAN spfile backup:
RMAN> restore validate spfile to '/backup/testdb/spfile.ora';

Use below command to test the most recent RMAN controlfile backup:
RMAN> restore validate controlfile to '/backup/testdb/control01.ctl';

Use below command to test the most recent RMAN archivelog file(s) backup:
Find which archivelog sequences are in the last backup:
RMAN> list backup of archivelog all;
RMAN> list backup of archivelog all completed after 'sysdate -1';

RMAN> restore validate archivelog from sequence xxxxx until sequence XXXXX;
Where xxxxx is the sequence number.

Click here to lean How to validate RMAN backup.

Click here for Block recovery using RMAN.

Satishbabu Gunukula


  1. Thank you for sharing this document with us.

  2. Recently, I have started to read a lot of unique articles on different sites, and I am enjoying that a lot. Although, I must tell you that I still like the articles here a lot. They are also unique in their own way 토토

  3. I am a fan who has watched your writing from before. I have learned a lot from you. Please come to my site and help me. 바카라사이트

  4. Wonderful post! We will be linking to this great article on our site. I’m definitely delighted I found it and I’ll be bookmarking and checking back often! 온라인경마

  5. Well I definitely liked reading it. This information offered by you is very constructive for proper planning 메이저사이트