NBU+ORACLE异机恢复测试（某电力省公司实践文档）

channel d1: restore complete, elapsed time: 00:00:36

output filename=/opt/oracle/product/10.2.0/db_1/dbs/cntrlsczgdb.dbf Finished restore at 18-MAR-11

released channel: d1

控制文件恢复后，数据库就可以mount了 在rman下alter database mount

四、查看源数据库裸设备名，以在目标端创建相应的文件

由于源端是使用的裸设备，现在我们把它恢复到文件系统上，需要新建文件并作相应修改。

1.在源端查看oracle的裸设备名

分为三类，临时文件，数据文件，日志文件

SQL> select name from v$tempfile; #查看临时文件 NAME

-------------------------------------------------------------------------------- /dev/rsczgoradblv04

SQL> select name from v$datafile; #查看数据文件

NAME

-------------------------------------------------------------------------------- /dev/rsczgoradblv01 /dev/rsczgoradblv05 /dev/rsczgoradblv02 /dev/rsczgoradblv03 /dev/rsczgoradblv06 /dev/rsczgoradblv20 /dev/rsczgoradblv21 /dev/rsczgoradblv22 /dev/rsczgoradblv23 /dev/rsczgoradblv24 /dev/rsczgoradblv30 NAME

-------------------------------------------------------------------------------- /dev/rsczgoradblv40 /dev/rsczgoradblv50

/dev/rsczgoradblv60 /dev/rsczgoradblv70 /dev/rsczgoradblv90

16 rows selected.

SQL> select member from V$logfile; #查看日志文件

MEMBER

-------------------------------------------------------------------------------- /dev/rsczgoradblv09 /dev/rsczgoradblv08 /dev/rsczgoradblv07 /dev/rsczgoradblv10 /dev/rsczgoradblv11 /dev/rsczgoradblv12

6 rows selected.

2.在目标端存放数据的目录下创建相应的文件

创建日志文件

touch /oradata/log1.log touch /oradata/log2.log touch /oradata/log3.log touch /oradata/log4.log touch /oradata/log5.log touch /oradata/log6.log 创建数据文件和临时文件 touch /oradata/1.dbf touch /oradata/2.dbf touch /oradata/3.dbf touch /oradata/4.dbf touch /oradata/5.dbf touch /oradata/6.dbf touch /oradata/7.dbf touch /oradata/8.dbf touch /oradata/9.dbf touch /oradata/10.dbf touch /oradata/11.dbf touch /oradata/12.dbf touch /oradata/13.dbf touch /oradata/14.dbf

touch /oradata/15.dbf touch /oradata/16.dbf touch /oradata/17.dbf

3.RENAME裸设备为文件系统

先要mount数据库,然后进sqlplus,执行命令 sqlplus / as sysdba 修改日志文件

alter database rename file '/dev/rsczgoradblv09' to '/oradata/log1.log'; alter database rename file '/dev/rsczgoradblv08' to '/oradata/log2.log'; alter database rename file '/dev/rsczgoradblv07' to '/oradata/log5.log'; alter database rename file '/dev/rsczgoradblv10' to '/oradata/log3.log'; alter database rename file '/dev/rsczgoradblv11' to '/oradata/log4.log'; alter database rename file '/dev/rsczgoradblv12' to '/oradata/log6.log'; 修改数据文件和临时文件

alter database rename file '/dev/rsczgoradblv01' to '/oradata/1.dbf'; alter database rename file '/dev/rsczgoradblv05' to '/oradata/2.dbf'; alter database rename file '/dev/rsczgoradblv02' to '/oradata/3.dbf'; alter database rename file '/dev/rsczgoradblv03' to '/oradata/4.dbf'; alter database rename file '/dev/rsczgoradblv06' to '/oradata/5.dbf'; alter database rename file '/dev/rsczgoradblv20' to '/oradata/6.dbf'; alter database rename file '/dev/rsczgoradblv21' to '/oradata/7.dbf'; alter database rename file '/dev/rsczgoradblv22' to '/oradata/8.dbf'; alter database rename file '/dev/rsczgoradblv23' to '/oradata/9.dbf'; alter database rename file '/dev/rsczgoradblv24' to '/oradata/10.dbf'; alter database rename file '/dev/rsczgoradblv30' to '/oradata/11.dbf'; alter database rename file '/dev/rsczgoradblv40' to '/oradata/12.dbf'; alter database rename file '/dev/rsczgoradblv50' to '/oradata/13.dbf'; alter database rename file '/dev/rsczgoradblv60' to '/oradata/14.dbf'; alter database rename file '/dev/rsczgoradblv70' to '/oradata/15.dbf'; alter database rename file '/dev/rsczgoradblv90' to '/oradata/16.dbf'; alter database rename file '/dev/rsczgoradblv04' to '/oradata/17.dbf';

五、恢复数据文件

数据库恢复在mount状态下进行

1.restore数据库

进rman执行命令 rman target / run {

allocate channel d1 type 'SBT_TAPE'; allocate channel d2 type 'SBT_TAPE';

allocate channel d3 type 'SBT_TAPE';

send 'NB_ORA_SERV=nbuserver2,NB_ORA_CLIENT=sczgdb01'; restore database; release channel d1; release channel d2;

release channel d3; }

同时NBUSERVER上可以看到相应的一些restore任务发起，读每个备份集就会发起一个restore任务，所以可能陆续发起很多任务直到全部恢复完成。也可以同时开启几个通道加快恢复速度。