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;
or
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.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/

7 comments:

  1. Thank you for sharing this document with us.
    www.rmanbackup.com

    ReplyDelete
  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 토토

    ReplyDelete
  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. 바카라사이트

    ReplyDelete
  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! 온라인경마

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

    ReplyDelete