Thursday, May 22, 2014

ORA-10572: Test recovery canceled due to errors

1. Test recovery cancelled due to errors
RMAN> recover tablespace tbs1 test;
Starting recover at 22-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/22/2014 02:14:17
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 tablespace TBS1 test
ORA-10572: Test recovery canceled due to errors
ORA-19904: test recovery not allowed for datafile 6
Cause The specified datafile has been restored from a backup that was taken before the last resetlogs. Recovering this datafile will require a file header update that is incompatible with test recovery.

Action Perform actual recovery.

No comments: