bf
channel ch00: reading from backup piece bk_10_1_753725520
channel ch00: restored backup piece 1
piece handle=bk_10_1_753725520 tag=HOT_DB_BK_LEVEL0
channel ch00: restore complete, elapsed time: 00:02:15
Finished restore at 18-JUN-11
released channel: ch00
RMAN>
RMAN>
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
recover datafile 4;
release channel ch00;
}3> 4> 5> 6> 7>
allocated channel: ch00
channel ch00: sid=46 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting recover at 18-JUN-11
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 18-JUN-11
released channel: ch00
RMAN> exit
Recovery Manager complete.
oracle@sg2as059:/u07/test/oradata>
oracle@sg2as059:/u07/test/oradata>
oracle@sg2as059:/u07/test/oradata> sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jun 18 22:57:07 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
Database altered.
SQL>
场景四：丢失redo log.
由于redolog不在rman备份范围之内，因此在做恢复的过程不需要nbu的参与，只是常规恢复。
如果丢失的redolog不含active或者current的redo，用recover database until cancel+resetlogs打开；
如果丢失的是active或者current的redo，就需要用_allow_resetlogs_corruption的隐含参数+resetlogs打开。
这里不展开叙述。
场景五：丢失全部文件（控制文件数据文件和日志文件）。
注意会自动restore arch，需要留心arch目录的大小。
oracle@sg2as059:/u01/app/oracle> export ORACLE_SID=test
oracle@sg2as059:/u01/app/oracle>
oracle@sg2as059:/u01/app/oracle>
oracle@sg2as059:/u01/app/oracle> rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 18 23:48:54 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/OraHome1/dbs/inittest.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 2071296 bytes
Variable Size 67110144 bytes
Database Buffers 83886080 bytes
Redo Buffers 6316032 bytes
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore spfile from 'bk_12_1_753725761';
release channel ch00;
}3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: sid=36 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting restore at 18-JUN-11
channel ch00: autobackup found: bk_12_1_753725761
channel ch00: SPFILE restore from autobackup complete
Finished restore at 18-JUN-11
released channel: ch00
RMAN> exit
Recovery Manager complete.
oracle@sg2as059:/u01/app/oracle> export ORACLE_SID=test
oracle@sg2as059:/u01/app/oracle> sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jun 18 23:52:07 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Databas