NBU异机恢复ORACLE（遇到的问题）

宇文氏

RMAN> RUN {　　2> ALLOCATE CHANNEL ch00 TYPE  'SBT_TAPE';
　　3> SEND 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=oracle10grac1';
　　4> set newname for datafile 1 to'/opt/oracle/oradata/orcl/system.256.779374375';
　　5> set newname for datafile 2 to'/opt/oracle/oradata/orcl/undotbs1.258.779374377';
　　6> set newname for datafile 3 to'/opt/oracle/oradata/orcl/sysaux.257.779374377';
　　7> set newname for datafile 4 to'/opt/oracle/oradata/orcl/users.259.779374377';
　　8> set newname for datafile 5 to'/opt/oracle/oradata/orcl/undotbs2.264.779374547';
　　9> set newname for datafile 6 to'/opt/oracle/oradata/orcl/test01.dbf';
　　10> RESTORE    DATABASE;

　　11>>　　12> }
　　released channel: ORA_DISK_1
　　allocated channel: ch00
　　channel ch00: sid=540 devtype=SBT_TAPE

　　channel ch00: Veritas NetBackup for Oracle ->　　sent command to channel: ch00
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　Starting restore at 11-APR-12
　　Starting implicit crosscheck backup at 11-APR-12
　　Crosschecked 16 objects
　　Finished implicit crosscheck backup at 11-APR-12
　　Starting implicit crosscheck copy at 11-APR-12
　　Crosschecked 2 objects
　　Finished implicit crosscheck copy at 11-APR-12
　　searching for all files in the recovery area
　　cataloging files...
　　no files cataloged
　　channel ch00: starting datafile backupset restore
　　channel ch00: specifying datafile(s) to restore from backup set
　　restoring datafile 00002 to /opt/oracle/oradata/orcl/undotbs1.258.779374377
　　restoring datafile 00003 to /opt/oracle/oradata/orcl/sysaux.257.779374377
　　restoring datafile 00006 to /opt/oracle/oradata/orcl/test01.dbf
　　channel ch00: reading from backup piece bk_376_1_780357313
　　channel ch00: restored backup piece 1
　　piece handle=bk_376_1_780357313 tag=HOT_DB_BK_LEVEL0
　　channel ch00: restore complete, elapsed time: 00:00:46
　　channel ch00: starting datafile backupset restore
　　channel ch00: specifying datafile(s) to restore from backup set
　　restoring datafile 00001 to /opt/oracle/oradata/orcl/system.256.779374375
　　restoring datafile 00004 to /opt/oracle/oradata/orcl/users.259.779374377
　　restoring datafile 00005 to /opt/oracle/oradata/orcl/undotbs2.264.779374547
　　channel ch00: reading from backup piece bk_375_1_780357313
　　channel ch00: restored backup piece 1
　　piece handle=bk_375_1_780357313 tag=HOT_DB_BK_LEVEL0
　　channel ch00: restore complete, elapsed time: 00:00:55
　　Finished restore at 11-APR-12
　　released channel: ch00
　　RMAN> RUN {
　　2> ALLOCATE CHANNEL ch00 TYPE  'SBT_TAPE';
　　3> SEND 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=oracle10grac1';
　　4> set newname for datafile 1 to'/opt/oracle/oradata/orcl/system.256.779374375';
　　5> set newname for datafile 2 to'/opt/oracle/oradata/orcl/undotbs1.258.779374377';
　　6> set newname for datafile 3 to'/opt/oracle/oradata/orcl/sysaux.257.779374377';
　　7> set newname for datafile 4 to'/opt/oracle/oradata/orcl/users.259.779374377';
　　8> set newname for datafile 5 to'/opt/oracle/oradata/orcl/undotbs2.264.779374547';
　　9> set newname for datafile 6 to'/opt/oracle/oradata/orcl/test01.dbf';
　　10> RESTORE    DATABASE;
　　11> RESTORE ARCHIVELOG ALL;

　　12>>　　13> }
　　allocated channel: ch00
　　channel ch00: sid=540 devtype=SBT_TAPE

　　channel ch00: Veritas NetBackup for Oracle ->　　sent command to channel: ch00
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　Starting restore at 11-APR-12
　　skipping datafile 2; already restored to file /opt/oracle/oradata/orcl/undotbs1.258.779374377
　　skipping datafile 3; already restored to file /opt/oracle/oradata/orcl/sysaux.257.779374377
　　skipping datafile 6; already restored to file /opt/oracle/oradata/orcl/test01.dbf
　　skipping datafile 1; already restored to file /opt/oracle/oradata/orcl/system.256.779374375
　　skipping datafile 4; already restored to file /opt/oracle/oradata/orcl/users.259.779374377
　　skipping datafile 5; already restored to file /opt/oracle/oradata/orcl/undotbs2.264.779374547
　　Finished restore at 11-APR-12
　　Starting restore at 11-APR-12
　　released channel: ch00
　　RMAN-00571: ===========================================================
　　RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
　　RMAN-00571: ===========================================================
　　RMAN-03002: failure of restore command at 04/11/2012 22:19:29
　　RMAN-06026: some targets not found - aborting restore
　　RMAN-06025: no backup of log thread 2 seq 130 lowscn 929777 found to restore
　　RMAN-06025: no backup of log thread 2 seq 24 lowscn 440269 found to restore
　　RMAN-06025: no backup of log thread 2 seq 23 lowscn 439595 found to restore
　　RMAN-06025: no backup of log thread 2 seq 22 lowscn 438461 found to restore
　　RMAN-06025: no backup of log thread 2 seq 21 lowscn 438396 found to restore
　　RMAN-06025: no backup of log thread 2 seq 20 lowscn 438172 found to restore
　　RMAN-06025: no backup of log thread 2 seq 19 lowscn 438148 found to restore
　　RMAN-06025: no backup of log thread 2 seq 18 lowscn 437934 found to restore
　　RMAN-06025: no backup of log thread 2 seq 17 lowscn 437909 found to restore
　　RMAN-06025: no backup of log thread 2 seq 16 lowscn 437791 found to restore
　　RMAN-06025: no backup of log thread 2 seq 15 lowscn 437770 found to restore
　　RMAN-06025: no backup of log thread 2 seq 14 lowscn 437655 found to restore
　　RMAN-06025: no backup of log thread 2 seq 13 lowscn 437629 found to restore
　　RMAN-06025: no backup of log thread 2 seq 12 lowscn 436883 found to restore
　　RMAN-06025: no backup of log thread 2 seq 11 lowscn 435254 found to restore
　　RMAN-06025: no backup of log thread 2 seq 10 lowscn 434190 found to restore
　　RMAN-06025: no backup of log thread 2 seq 9 lowscn 434186 found to restore
　　RMAN-06025: no backup of log thread 2 seq 8 lowscn 434176 found to restore
　　RMAN-06025: no backup of log thread 2 seq 7 lowscn 433779 found to restore
　　RMAN-06025: no backup of log thread 2 seq 6 lowscn 433317 found to restore
　　RMAN-06025: no backup of log thread 2 seq 5 lowscn 431666 found to restore
　　RMAN-06025: no backup of log thread 2 seq 4 lowscn 431648 found to restore
　　RMAN-06025: no backup of log thread 2 seq 3 lowscn 403797 found to restore
　　RMAN-06025: no backup of log thread 2 seq 2 lowscn 401973 found to restore
　　RMAN-06025: no backup of log thread 2 seq 1 lowscn 398422 found to restore
　　RMAN-06025: no backup of log thread 1 seq 131 lowscn 929783 found to restore
　　RMAN-06025: no backup of log thread 1 seq 15 lowscn 437906 found to restore
　　RMAN-06025: no backup of log thread 1 seq 14 lowscn 437793 found to restore
　　RMAN-06025: no backup of log thread 1 seq 13 lowscn 437768 found to restore
　　RMAN-06025: no backup of log thread 1 seq 12 lowscn 437658 found to restore
　　RMAN-06025: no backup of log thread 1 seq 11 lowscn 437627 found to restore
　　RMAN-06025: no backup of log thread 1 seq 10 lowscn 436879 found to restore
　　RMAN-06025: no backup of log thread 1 seq 9 lowscn 435257 found to restore
　　RMAN-06025: no backup of log thread 1 seq 8 lowscn 434179 found to restore
　　RMAN-06025: no backup of log thread 1 seq 7 lowscn 431669 found to restore
　　RMAN-06025: no backup of log thread 1 seq 6 lowscn 431645 found to restore
　　RMAN-06025: no backup of log thread 1 seq 5 lowscn 429741 found to restore
　　RMAN-06025: no backup of log thread 1 seq 4 lowscn 403799 found to restore
　　RMAN-06025: no backup of log thread 1 seq 3 lowscn 402118 found to restore
　　RMAN-06025: no backup of log thread 1 seq 2 lowscn 393397 found to restore
　　RMAN> RECOVER DATABASE ;
　　Starting recover at 11-APR-12
　　allocated channel: ORA_DISK_1
　　channel ORA_DISK_1: sid=540 devtype=DISK
　　RMAN-00571: ===========================================================
　　RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
　　RMAN-00571: ===========================================================
　　RMAN-03002: failure of recover command at 04/11/2012 22:19:46
　　RMAN-06094: datafile 1 must be restored