oracle nbu异机恢复,VERITAS NBU异机恢复演练-Oracle Database(Sun SPARC)

RMAN> run {

2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

3> send 'NB_ORA_SERV=IXSNBU,

NB_ORA_CLIENT=DBha01';

4> set until time "to_date('2012-04-17

08:30:00','YYYY-MM-DD hh24:mi:ss')";

5> restore database;

6> recover database;

7> release channel ch00;

8> }

allocated channel: ch00

channel ch00: sid=644 devtype=SBT_TAPE

channel ch00: Veritas NetBackup for Oracle - Release 7.0

(2010010418)

sent command to channel: ch00

executing command: SET until clause

Starting restore at 18-APR-12

Starting implicit crosscheck backup at 18-APR-12

Finished implicit crosscheck backup at 18-APR-12

Starting implicit crosscheck copy at 18-APR-12

Crosschecked 2 objects

Finished implicit crosscheck copy at 18-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

/u03/oradata/newpay/undotbs01.dbf

restoring datafile 00007 to /u05/oradata/newpay/corpub01.dbf

restoring datafile 00014 to /u04/oradata/newpay/corio02.dbf

channel ch00: reading from backup piece bk_1937_1_780710413

channel ch00: restored backup piece 1

piece handle=bk_1937_1_780710413 tag=HOT_DB_BK_LEVEL0

channel ch00: restore complete, elapsed time: 00:09:16

channel ch00: starting datafile backupset restore

channel ch00: specifying datafile(s) to restore from backup

set

restoring datafile 00001 to /u03/oradata/newpay/system01.dbf

restoring datafile 00003 to /u03/oradata/newpay/sysaux01.dbf

restoring datafile 00009 to /u05/oradata/newpay/corio01.dbf

restoring datafile 00015 to /u04/oradata/newpay/ggs.dbf

channel ch00: reading from backup piece bk_1938_1_780710668

channel ch00: restored backup piece 1

piece handle=bk_1938_1_780710668 tag=HOT_DB_BK_LEVEL0

channel ch00: restore complete, elapsed time: 00:06:26

channel ch00: starting datafile backupset restore

channel ch00: specifying datafile(s) to restore from backup

set

restoring datafile 00004 to /u03/oradata/newpay/users01.dbf

restoring datafile 00005 to /u05/oradata/newpay/dblink01.dbf

restoring datafile 00010 to

/u05/oradata/newpay/appbank01.dbf

restoring datafile 00012 to /u05/oradata/newpay/appafs01.dbf

restoring datafile 00013 to /u03/oradata/newpay/appafs02.dbf

channel ch00: reading from backup piece bk_1939_1_780710783

channel ch00: restored backup piece 1

piece handle=bk_1939_1_780710783 tag=HOT_DB_BK_LEVEL0

channel ch00: restore complete, elapsed time: 00:02:26

channel ch00: starting datafile backupset restore

channel ch00: specifying datafile(s) to restore from backup

set

restoring datafile 00006 to

/u05/oradata/newpay/sysbase01.dbf

restoring datafile 00008 to

/u05/oradata/newpay/corrisk01.dbf

restoring datafile 00011 to /u05/oradata/newpay/appoper.dbf

restoring datafile 00016 to /u04/oradata/newpay/corio03.dbf

channel ch00: reading from backup piece bk_1940_1_780710868

channel ch00: restored backup piece 1

piece handle=bk_1940_1_780710868 tag=HOT_DB_BK_LEVEL0

channel ch00: restore complete, elapsed time: 00:02:16

Finished restore at 18-APR-12

Starting recover at 18-APR-12

starting media recovery

channel ch00: starting archive log restore to default

destination

channel ch00: restoring archive log

archive log thread=1 sequence=1320

channel ch00: restoring archive log

archive log thread=1 sequence=1321

channel ch00: reading from backup piece al_1943_1_780711108

channel ch00: restored backup piece 1

piece handle=al_1943_1_780711108 tag=TAG20120416T001022

channel ch00: restore complete, elapsed time: 00:02:16

archive log filename=/arch/newpay/1_1320_745172102.arc thread=1

sequence=1320

archive log filename=/arch/newpay/1_1321_745172102.arc thread=1

sequence=1321

unable to find archive log

archive log thread=1 sequence=1322

released channel: ch00

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

RMAN-03002: failure of recover command at 04/18/2012

14:49:02

RMAN-06054: media recovery requesting unknown log: thread 1 seq

1322 lowscn 88530792

RMAN> run {

2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

3> send 'NB_ORA_SERV=IXSNBU,

NB_ORA_CLIENT=DBha01';

4> RESTORE ARCHIVELOG FROM SEQUENCE 1322;

5> release channel ch00;

6> }

allocated channel: ch00

channel ch00: sid=644 devtype=SBT_TAPE

channel ch00: Veritas NetBackup for Oracle - Release 7.0

(2010010418)

sent command to channel: ch00

Starting restore at 18-APR-12

released channel: ch00

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

RMAN-03002: failure of restore command at 04/18/2012

14:52:15

RMAN-20242: specification does not match any archive log in the

recovery catalog

RMAN> shutdown immediate

database dismounted

Oracle instance shut down