宇文氏 发表于 2018-9-22 10:50:05

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

页: [1]
查看完整版本: NBU异机恢复ORACLE(遇到的问题)