channel ch1: restore complete, elapsedtime: 00:00:55
failover to previous backup
Finished restore at 2014-05-21 15:12:02
Starting recover at 2014-05-21 15:12:02
released channel: ch1
released channel: ch2
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of recover command at05/21/2014 15:12:02
RMAN-06556: datafile 5 must be restoredfrom backup older than SCN 1519297
RMAN>
【报错原因】
仔细观察备份过程和还原恢复过程的输出信息，会发现里面包含3条信息记录：
file5 is excluded from whole database backup
file8 is excluded from whole database backup
file9 is excluded from whole database backup
意思是说file 5、8、9没有进行备份，也没有进行还原恢复。
【解决方法】
修改RMAN备份策略中的排除规则
修改前：
CONFIGURE EXCLUDE FOR TABLESPACE'TESTDB_DATA';
修改后：
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE'TESTDB_DATA' clear;
Tablespace TESTDB_DATA will be included infuture whole database backups
old RMAN configuration parameters aresuccessfully deleted
RMAN>?
查看表空间备份策略（INCLUDED_IN_DATABASE_BACKUP）：
SQL> select * from v$tablespace order by3;
TS# NAME INC BIG FLAENC
---------- --------------- --- --- --- ---
3 TEMP NO NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
9 RCAT_DATA YES NO YES
6 TESTDB_DATA YES NO YES
7 TESTDB_INDEX YES NO YES
8 HESPER_HQ YES NO YES
0 SYSTEM YES NO YES
9 rows selected.