Verify my Backup files after Backup?
923887May 16 2012 — edited May 17 2012Hi All,
How can I make sure the backup I just made was all good? which command is better (VALIDATE or BACKUP VALIDATE or RESTORE VALIDATE).
I am guessing RESTORE VALIDATE. Then what would the command looks like:
run {
backup database INCLUDE CURRENT CONTROLFILE plus archivelog;
transport tablespace MYDB
tablespace destination '/opt/oracle/trandest'
auxiliary destination '/opt/oracle/auxdest';
RESTORE DATABASE VALIDATE;
RESTORE ARCHIVELOG ALL VALIDATE;
}
Thanks.