NBU恢复Oracle数据文件或者控制文件步骤： 1．先在NBU master上查询client端的备份信息：
2.启动数据库到nomount状态： SQL> startup nomount; ORACLE instance started.
Total System Global Area 567869440 bytes Fixed Size 2215384 bytes Variable Size 369099304 bytes Database Buffers 192937984 bytes Redo Buffers 3616768 bytes
3．进入rman中恢复控制文件。 RMAN> run { 2> allocate channel ch00 type sbt_tape; 3> SEND 'NB_ORA_SERV=master,NB_ORA_CLIENT=client'; 4> restore controlfile to '/tmp/control.bak' from ' /cntrl_47_1_960598675'; 5> release channel ch00; 6> }
run { replicate controlfile from '/tmp/control.bak'; }
4.mount数据库. SQL> alter database mount; Database altered.
5恢复数据文件 RMAN> run { 2> allocate channel ch00 type sbt_tape; 3> SEND 'NB_ORA_SERV=master,NB_ORA_CLIENT=client'; 4> set until time "to_date('2012-08-09:00:00:00','YYYY-MM-DD:HH24:MI:SS')"; 5> restore database; 6> release channel ch00; 7> }
6.启动oracle数据库。 Alter database open resetlog;
