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: AVAILABLECompressed: NOTag: 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 TimeName
---- -- ---- ---------- --------- ----
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 KeyType LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23      Full    7.36M      DISK      00:00:01   30-OCT-11      
      BP Key: 23   Status: AVAILABLECompressed: NOTag: 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在线正常情况下做的最新全备

请高手指点,万分感谢:D
页: [1]
查看完整版本: DUPLICATE datafile 4 not processed because file is offline