NBU恢复Oracle控制文件或者数据文件

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;

转载于:https://blog.51cto.com/zhengdzy/2045720