(1) Script for RMAN test recover operation
#Rman script to test the recovery operation of a tablespace example sql"alter tablespace example offline"; restore tablespace example; recover tablespace example test;
RMAN> #Rman script to test the recovery operation of a tablespace example 2> sql"alter tablespace example offline"; sql statement: alter tablespace example offline RMAN> restore tablespace example; Starting restore 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 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00005 to +DATA/cvrman/datafile/example.308.847525493 channel ORA_DISK_1: reading from backup piece +DATA/cvrman/backupset/2014_05_22/nnndf0_tag20140522t051830_0.290.848207929 channel ORA_DISK_1: piece handle=+DATA/cvrman/backupset/2014_05_22/nnndf0_tag20140522t051830_0.290.848207929 tag=TAG20140522T051830 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 Finished restore at 22-MAY-14 RMAN> recover tablespace example 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 RMAN-11006: WARNING: test recovery results: ORA-10574: Test recovery did not corrupt any data block ORA-10573: Test recovery tested redo from change 1484624 to 1484846 ORA-10572: Test recovery canceled due to errors ORA-10585: Test recovery can not apply redo that may modify control file media recovery complete, elapsed time: 00:00:00 Finished recover at 22-MAY-14 RMAN> RMAN> **end-of-file**
