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