标题: DUPLICATE datafile 4 not processed because file is offline [打印本页] 作者: yangbosos 时间: 2012-03-13 00:22 标题: DUPLICATE datafile 4 not processed because file is offline 同机镜像,有点小问题,但不知道怎么解决,请高手指点
源DB上做过datafile 4的删除与恢复实验,然后那时候做过全备
以后用这个全备恢复了,然后把datafile也搞好了,但是每次duplicate都报错。
RMAN> run{
2> set newname for datafile 1 to "/db/system01.dbf";
3> set newname for datafile 2 to "/db/undotbs01.dbf";
4> set newname for datafile 3 to "/db/sysaux01.dbf";
5> set newname for datafile 4 to "/db/users01.dbf";
6> set newname for datafile 5 to "/db/ora.dbf";
7> set newname for datafile 6 to "/db/user_data.dbf";
8> DUPLICATE TARGET DATABASE TO myor
9> pfile=/opt/ora10g/product/10.2.0/db_1/dbs/initmyor.ora
10> logfile
11> '/db/redo01.log' size 10m,
12> '/db/redo02.log' size 10m,
13> '/db/redo03.log' size 10m;
14> }
RMAN> list backupset
2> ;
22 Full 524.46M DISK 00:01:03 30-OCT-11
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20111030T055025
Piece Name: /opt/ora10g/flash_recovery_area/ORCA/backupset/2011_10_30/o1_mf_nnndf_TAG20111030T055025_7brx92gg_.bkp
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 591983 30-OCT-11 /opt/ora10g/oradata/orca/system01.dbf
2 Full 591983 30-OCT-11 /opt/ora10g/oradata/orca/undotbs01.dbf
3 Full 591983 30-OCT-11 /opt/ora10g/oradata/orca/sysaux01.dbf
4 Full 591983 30-OCT-11 /opt/ora10g/oradata/orca/users01.dbf
5 Full 591983 30-OCT-11 /opt/ora10g/oradata/tbs/ora.dbf
6 Full 591983 30-OCT-11 /oracle/bb/user_data.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23 Full 7.36M DISK 00:00:01 30-OCT-11
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20111030T055131
Piece Name: /opt/ora10g/flash_recovery_area/ORCA/autobackup/2011_10_30/o1_mf_s_765870691_7brxc42q_.bkp
Control File Included: Ckp SCN: 592019 Ckp time: 30-OCT-11
SPFILE Included: Modification time: 30-OCT-11
确定这个22是在所有datafile在线正常情况下做的最新全备