[ORACLE] RMAN异机恢复记录

工作记录。
另：备份脚本参见我的下载。

bash-3.00$ rman target / catalog rman/rman@inst1002

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database (not started)
connected to recovery catalog database

RMAN> set dbid=3157572766

executing command: SET DBID

RMAN> startup nomount;

Oracle instance started

Total System Global Area    1880589944 bytes

Fixed Size                      743032 bytes
Variable Size               1828716544 bytes
Database Buffers              50331648 bytes
Redo Buffers                    798720 bytes

RMAN> run{
allocate channel t1 type 'sbt_tape';
send 'nb_ora_serv=szcnbu1,nb_ora_client=ssuzmesvs01';
set until time 'SYSDATE-1/12';
restore controlfile;
alter database mount;
restore database;
recover database;}2> 3> 4> 5> 6> 7> 8>

allocated channel: t1
channel t1: sid=13 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

sent command to channel: t1

executing command: SET until clause

Starting restore at 02-SEP-08

channel t1: starting datafile backupset restore
channel t1: restoring controlfile
output filename=/oracle/304/oradata/inst933/control01.ctl
channel t1: restored backup piece 1
piece handle=c-3157572766-20080902-04 tag=null params=NULL
channel t1: restore complete
replicating controlfile
input filename=/oracle/304/oradata/inst933/control01.ctl
output filename=/oracle/304/oradata/inst933/control02.ctl
Finished restore at 02-SEP-08

database mounted

Starting restore at 02-SEP-08

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/304/oradata/inst933/system01.dbf
restoring datafile 00002 to /oracle/304/oradata/inst933/undotbs01.dbf
restoring datafile 00003 to /oracle/304/oradata/inst933/users01.dbf
restoring datafile 00004 to /oracle/304/oradata/inst933/perfstat01.dbf
restoring datafile 00005 to /oracle/304/oradata/inst933/insite_suz.dbf
restoring datafile 00006 to /oracle/304/oradata/inst933/insiteint01.dbf
restoring datafile 00007 to /oracle/304/oradata/inst933/insiteque.dbf
restoring datafile 00008 to /oracle/304/oradata/inst933/undotbs02.dbf
restoring datafile 00009 to /oracle/304/oradata/inst933/aud_data01.dbf
restoring datafile 00010 to /oracle/304/oradata/inst933/perfstat02.dbf
restoring datafile 00011 to /oracle/304/oradata/inst933/insite_suz01.dbf
restoring datafile 00012 to /oracle/304/oradata/inst933/undotbs03.dbf
restoring datafile 00013 to /oracle/304/oradata/inst933/undotbs04.dbf
channel t1: restored backup piece 1
piece handle=bk_6231_1_664203616 tag=FULL_ORACLE_BACKUP params=NULL
channel t1: restore complete
Finished restore at 02-SEP-08

Starting recover at 02-SEP-08
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oracle/304/oradata/inst933/system01.dbf
destination for restore of datafile 00002: /oracle/304/oradata/inst933/undotbs01.dbf
destination for restore of datafile 00003: /oracle/304/oradata/inst933/users01.dbf
destination for restore of datafile 00004: /oracle/304/oradata/inst933/perfstat01.dbf
destination for restore of datafile 00005: /oracle/304/oradata/inst933/insite_suz.dbf
destination for restore of datafile 00006: /oracle/304/oradata/inst933/insiteint01.dbf
destination for restore of datafile 00007: /oracle/304/oradata/inst933/insiteque.dbf
destination for restore of datafile 00008: /oracle/304/oradata/inst933/undotbs02.dbf
destination for restore of datafile 00009: /oracle/304/oradata/inst933/aud_data01.dbf
destination for restore of datafile 00010: /oracle/304/oradata/inst933/perfstat02.dbf
destination for restore of datafile 00011: /oracle/304/oradata/inst933/insite_suz01.dbf
destination for restore of datafile 00012: /oracle/304/oradata/inst933/undotbs03.dbf
destination for restore of datafile 00013: /oracle/304/oradata/inst933/undotbs04.dbf
channel t1: restored backup piece 1
piece handle=bk_6256_1_664286419 tag=INCREMENTAL_ORACLE_BACKUP params=NULL
channel t1: restore complete

starting media recovery

channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=7951
channel t1: restoring archive log
archive log thread=1 sequence=7952
channel t1: restored backup piece 1
piece handle=arch_664293621_6259.arc tag=TAG20080901T140021 params=NULL
channel t1: restore complete
...
archive log filename=/oracle/304/arch/inst933/arch_1_7973.arc thread=1 sequence=7973
archive log filename=/oracle/304/arch/inst933/arch_1_7974.arc thread=1 sequence=7974
unable to find archive log
archive log thread=1 sequence=7975
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/02/2008 13:18:30
RMAN-06054: media recovery requesting unknown log: thread 1 scn 1850630169899

RMAN>

RMAN> RUN{
  SET UNTIL SEQUENCE 7974 THREAD 1;
  RECOVER DATABASE;
}
2> 3> 4>
executing command: SET until clause

Starting recover at 02-SEP-08
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1

starting media recovery
media recovery complete

Finished recover at 02-SEP-08

RMAN>
RMAN> exit


Recovery Manager complete.

bash-3.00$ sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.8.0 - Production on Tue Sep 2 13:35:04 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> alter database open resetlogs;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
bash-3.00$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/58054/viewspace-626001/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/58054/viewspace-626001/