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]