oracle恢复失败,rman增量恢复失败RMAN-06094？？？？

本帖最后由 刚在路 于 2015-5-14 23:24 编辑

Oracle   11.2.0.4  在做增量恢复时失败，

实验 先restore 全备 再recover 增量备份：

RMAN> shutdown immediate;

database dismounted

Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)

Oracle instance started

Total System Global Area     759943168 bytes

Fixed Size                     2257112 bytes

Variable Size                515903272 bytes

Database Buffers             239075328 bytes

Redo Buffers                   2707456 bytes

RMAN> restore controlfile from '/backup/rman_bak/ctl0_20150514_17_1_TEST';----0级全备时控制文件

Starting restore at 14-MAY-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=31 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=+DATA2/test/controlfile/current.273.879676291

output file name=+DATA2/test/controlfile/current.274.879676291

Finished restore at 14-MAY-15

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> list backupset of database;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Incr 0  639.49M    DISK        00:00:54     14-MAY-15

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150514T092532

Piece Name: /backup/rman_bak/dbf0_20150514_7_1_TEST

List of Datafiles in backup set 1

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1    0  Incr 931293     14-MAY-15 +DATA2/test/datafile/system.256.879671711

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2       Incr 0  355.54M    DISK        00:00:56     14-MAY-15

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150514T092532

Piece Name: /backup/rman_bak/dbf0_20150514_8_1_TEST

List of Datafiles in backup set 2

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

2    0  Incr 931294     14-MAY-15 +DATA2/test/datafile/sysaux.257.879671711

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4       Incr 0  27.65M     DISK        00:00:56     14-MAY-15

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20150514T092532

Piece Name: /backup/rman_bak/dbf0_20150514_9_1_TEST

List of Datafiles in backup set 4

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

3    0  Incr 931298     14-MAY-15 +DATA2/test/datafile/undotbs1.258.879671711

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

6       Incr 0  1.30M      DISK        00:00:56     14-MAY-15

BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150514T092532

Piece Name: /backup/rman_bak/dbf0_20150514_11_1_TEST

List of Datafiles in backup set 6

File LV Type Ckp SCN