NBU 6.0 recover oracle 9i

chinakkee

open Backup,Archive,and restore
File--specify Netbackup machines and policy Type
policy type for restores=oracle
Actions--start restore of marked file( make sure the path of the oracle database initialzation parameter file)

INF - Begin progress logging for process: (3912.3900)
INF - Putting the database in mount state.
INF - Using: "e:\oracle\ora92\bin\sqlplus.exe"
INF - Connection info: 'connect
[email=sys/*****@orcl]sys/*****@orcl[/email]
as SYSDBA'.
INF - Start of SQLPLUS output.
INF - SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 25 22:54:55 2007
INF - Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
INF - SQL> Connected.
INF - SQL> Database closed.
INF - Database dismounted.
INF - ORACLE instance shut down.
INF - SQL> ORACLE instance started.
INF - Database mounted.
INF - SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
INF - End of SQLPLUS output.
INF - Starting Oracle Recovery Manager.
INF - Using: "e:\oracle\ora92\bin\rman.exe"
INF - Connection info: target
[email='sys/*****@orcl']'sys/*****@orcl'[/email]
nocatalog
INF - Start of Recovery Manager input.
INF - Begin progress logging for process: (452.3848)
INF - # -----------------------------------------------------------------
INF - # RMAN command section
INF - # -----------------------------------------------------------------
INF - RUN {
INF - ALLOCATE CHANNEL ch00
INF -     TYPE 'SBT_TAPE';
INF - SEND 'NB_ORA_SERV=192.168.32.1';
INF - RESTORE
INF -     DATABASE;
INF - RECOVER
INF -     DATABASE;
INF - RELEASE CHANNEL ch00;
INF - }
INF - End of Recovery Manager input.
INF - Start restore of backup piece: (bk_u01ig3305_s1_p1_t620858373)
INF - Start of Recovery Manager output.
INF - Backup id: oracle9i_1177558924
INF - Policy: orcl
INF - Master server: asus
INF - Restore id: 5.001
INF - Beginning restore from server asus to client oracle9i, file E:\\oracle9i_1177558924_C1_F1.
INF - Server status = 0
INF - End restore of backup piece: (bk_u01ig3305_s1_p1_t620858373)
INF - Recovery Manager: Release 9.2.0.1.0 - Production
INF - connected to target database: ORCL (DBID=1132391046)
INF - using target database controlfile instead of recovery catalog
INF - allocated channel: ch00
INF - Starting restore at 25-APR-07
INF - channel ch00: starting datafile backupset restore
INF - restoring datafile 00001 to E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
INF - restoring datafile 00002 to E:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
INF - restoring datafile 00003 to E:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF
INF - restoring datafile 00004 to E:\ORACLE\ORADATA\ORCL\DRSYS01.DBF
INF - restoring datafile 00005 to E:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF
INF - restoring datafile 00006 to E:\ORACLE\ORADATA\ORCL\INDX01.DBF
INF - restoring datafile 00007 to E:\ORACLE\ORADATA\ORCL\ODM01.DBF
INF - restoring datafile 00009 to E:\ORACLE\ORADATA\ORCL\USERS01.DBF
INF - restoring datafile 00010 to E:\ORACLE\ORADATA\ORCL\XDB01.DBF
INF - channel ch00: restored backup piece 1
INF - Begin progress logging for process: (452.3848)
INF - Start restore of backup piece: (arch-s2-p1-t620858835)
INF - Backup id: oracle9i_1177559296
INF - Policy: orcl
INF - Master server: asus
INF - Restore id: 6.001
INF - Beginning restore from server asus to client oracle9i, file E:\\oracle9i_1177559296_C1_F1.
INF - Server status = 0
INF - End restore of backup piece: (arch-s2-p1-t620858835)
INF - piece handle=bk_u01ig3305_s1_p1_t620858373 tag=TAG20070425T203932 params=NULL
INF - channel ch00: restore complete
INF - Finished restore at 25-APR-07
INF - Starting recover at 25-APR-07
INF - starting media recovery
INF - channel ch00: starting archive log restore to default destination
INF - channel ch00: restoring archive log
INF - archive log thread=1 sequence=2
INF - channel ch00: restoring archive log
INF - archive log thread=1 sequence=3
INF - channel ch00: restored backup piece 1
INF - piece handle=arch-s2-p1-t620858835 tag=TAG20070425T204715 params=NULL
INF - channel ch00: restore complete
INF - archive log filename=E:\ORACLE\ORA92\RDBMS\ARC00002.001 thread=1 sequence=2
INF - media recovery complete
INF - Finished recover at 25-APR-07
INF - released channel: ch00
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/7315/showart_286856.html