rom server sg2ts001 to client sg2as059.
21:53:40 /bk_12_1_753725761
21:53:40 /bk_12_1_753725761
21:53:43 (342183.001) Status of restore from image created 06/13/11 16:38:23 = the requested operation was successfully completed
--注意上面这条log结束后，rman端才会返回本次restore成功或者失败的结果。
21:53:45 INF - Server status = 0
21:53:45 (342183.xxx) INF - Status = the requested operation was successfully completed.
还原spfile后，关闭原来的dummy数据库，正常启动数据库。
场景二：丢失控制文件。
丢失控制文件的场景和丢失spfile类似，而且步骤根据简单一些，不需要启动dummy数据库，根据log选择控制文件。
数据库需要启动到nomount状态：
oracle@sg2as059:/u01/app/oracle/OraHome1/dbs> rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 18 22:23:27 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: test (not mounted)
RMAN>
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore controlfile from 'cntrl_15_1_753725973' ;
release channel ch00;
}3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
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 restore at 18-JUN-11
channel ch00: restoring control file
channel ch00: restore complete, elapsed time: 00:02:38
output filename=/u01/test/control01.ctl
Finished restore at 18-JUN-11
released channel: ch00
RMAN>
还原控制文件之后，resetlogs启动数据库。
SQL> alter database mount;
Database altered.
SQL>
SQL> recover database using BACKUP CONTROLFILE until cancel;
ORA-00279: change 346227 generated at 06/13/2011 16:17:36 needed for thread 1
ORA-00289: suggestion : /u07/test/arch/1_13_753371123.dbf
ORA-00280: change 346227 for thread 1 is in sequence #13
Specify log: {=suggested | filename | AUTO | CANCEL}
/u07/test/oradata/redo01.log
Log applied.
Media recovery complete.
SQL>
SQL> alter database open resetlogs;
Database altered.
SQL>
场景三：丢失数据文件
SQL> startup mount;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 2072552 bytes
Variable Size 150994968 bytes
Database Buffers 155189248 bytes
Redo Buffers 6316032 bytes
Database mounted.
SQL>
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u07/test/oradata/tbs_1.dbf'
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
oracle@sg2as059:/u07/test/oradata>
oracle@sg2as059:/u07/test/oradata> rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 18 22:51:43 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TEST (DBID=2051517555, not open)
RMAN>
RMAN>
RMAN>
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore 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 restore at 18-JUN-11
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u07/test/oradata/tbs_1.d