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.