1.1.1. RMAN-06556

日期：2014-05-21 16:33

环境：测试环境

【情景描述】

使用RMAN进行了全库备份，但是在进行不完全恢复的时候遇到报错，提示某个数据文件必须从比给出的SCN更早的备份中恢复。

【报错信息】

备份数据库：

RMAN> backup database plus archivelog;

Starting backup at 2014-05-21 15:02:13

current log archived

......

Finished backup at 2014-05-21 15:02:15

Starting backup at 2014-05-21 15:02:15

using channel ORA_DISK_1

file 5 is excluded from whole databasebackup

file 8 is excluded from whole databasebackup

file 9 is excluded from whole databasebackup

channel ORA_DISK_1: starting full datafilebackup set

channel ORA_DISK_1: specifying datafile(s)in backup set

input datafile file number=00001name=/U01/app/oracle/oradata/testdb/system01.dbf

input datafile file number=00002name=/U01/app/oracle/oradata/testdb/sysaux01.dbf

input datafile file number=00003name=/U01/app/oracle/oradata/testdb/undotbs01.dbf

input datafile file number=00007name=/U01/app/oracle/oradata/testdb/hesper_hq_data01.dbf

input datafile file number=00010name=/U01/app/oracle/oradata/testdb/rcat_data01.dbf

input datafile file number=00006name=/U01/app/oracle/oradata/testdb/testdb01_index.dbf

input datafile file number=00004name=/U01/app/oracle/oradata/testdb/users01.dbf

channel ORA_DISK_1: starting piece 1 at2014-05-21 15:02:15

......

channel ORA_DISK_1: backup set complete,elapsed time: 00:00:55

Finished backup at 2014-05-21 15:03:10

Starting backup at 2014-05-21 15:03:10

current log archived

......

Finished backup at 2014-05-21 15:03:12

Starting Control File and SPFILE Autobackupat 2014-05-21 15:03:12

piecehandle=/home/oracle/rman/backup_recovery/testdb_c-2607759728-20140521-01comment=NONE

Finished Control File and SPFILE Autobackupat 2014-05-21 15:03:13

RMAN>

还原恢复：

RMAN> run {

2> allocate channel ch1 type disk;

3> allocate channel ch2 type disk;

4> set until scn 1519297;

5> restore database;

6> recover database;

7> release channel ch1;

8> release channel ch2;

9> }

allocated channel: ch1

channel ch1: SID=63 device type=DISK

allocated channel: ch2

channel ch2: SID=129 device type=DISK

executing command: SET until clause

Starting restore at 2014-05-21 15:11:07

file 5 is excluded from whole databasebackup

file 8 is excluded from whole databasebackup

file 9 is excluded from whole databasebackup

channel ch1: starting datafile backup setrestore

channel ch1: specifying datafile(s) torestore from backup set

channel ch1: restoring datafile 00001 to/U01/app/oracle/oradata/testdb/system01.dbf

channel ch1: restoring datafile 00002 to/U01/app/oracle/oradata/testdb/sysaux01.dbf

channel ch1: restoring datafile 00003 to/U01/app/oracle/oradata/testdb/undotbs01.dbf

channel ch1: restoring datafile 00004 to/U01/app/oracle/oradata/testdb/users01.dbf

channel ch1: restoring datafile 00006 to/U01/app/oracle/oradata/testdb/testdb01_index.dbf

channel ch1: restoring datafile 00007 to/U01/app/oracle/oradata/testdb/hesper_hq_data01.dbf

channel ch1: restoring datafile 00010 to/U01/app/oracle/oradata/testdb/rcat_data01.dbf

channel ch1: reading from backup piece/U01/app/test/rman/fra/TESTDB/backupset/2014_05_21/o1_mf_nnndf_TAG20140521T150215_9qrmvr0y_.bkp

channel ch1: piecehandle=/U01/app/test/rman/fra/TESTDB/backupset/2014_05_21/o1_mf_nnndf_TAG20140521T150215_9qrmvr0y_.bkptag=TAG20140521T150215