rman数据库异机恢复

《rman数据库异机恢复》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、数据库异机恢复By:hopsj2013-05-10关键字：RMAN、11G一、恢复目标恢复演练在服务器发生故障或需迁移数据时，对数据库进行快速恢复及迁移。二、数据库及系统环境2.1源和目标系统环境Oracle源主机Oracle目标主机主机平台6100-06-01-10435300-12-01-1016主机名p750aNode1IP地址10.129.0.1510.129.1.99实例名NCDBNCDBOracle版本11.1.0.611.1.0.6Oracle数据文件存储FilesystemFilesystem控制文件路径/or

2、adata/ncdb//u01/app/oracle/oradata/ncdb//oradata/ncdb//oradata/ncdb//u01/app/oracle/oradata/ncdb/在线重做日志路径/oradata/ncdb//u01/app/oracle/oradata/ncdb/2.2源文件信息2.2.1控制文件信息SQL>showparametercontrol_filesNAMETYPEVALUE--------------------------------------------------------

3、---------------------control_filesstring/oradata/ncdb/control01.ctl,/oradata/ncdb/control02.ctl,/oradata/ncdb/control03.ctl2.2.2数据文件信息SQL>selectfile_namefromdba_data_files;FILE_NAME--------------------------------------------------/oradata/ncdb/users01.dbf/oradata/n

4、cdb/undotbs01.dbf/oradata/ncdb/sysaux01.dbf/oradata/ncdb/system01.dbf/oradata/ncdb/nnc_data01.dbf/oradata/ncdb/nnc_data02.dbf/oradata/ncdb/nnc_data03.dbf/oradata/ncdb/nnc_index01.dbf/oradata/ncdb/nnc_index02.dbf/oradata/ncdb/nnc_index03.dbf/oradata/ncdb/nnc_iufo.dbf

5、/oradata/ncdb/iufodc.dbf2.2.3在线日志信息SQL>select*fromv$logfile;GROUP#STATUSTYPEMEMBERIS_-----------------------------------------------------------------------------3ONLINE/oradata/ncdb/redo03.logNO2ONLINE/oradata/ncdb/redo02.logNO1ONLINE/oradata/ncdb/redo01.logNO4ONLI

6、NE/oradata/ncdb/redo04.logNO5ONLINE/oradata/ncdb/redo05.logNO1ONLINE/oradata/ncdb/redo01a.logNO3ONLINE/oradata/ncdb/redo03a.logNO4ONLINE/oradata/ncdb/redo04a.logNO5ONLINE/oradata/ncdb/redo05a.logNO2ONLINE/oradata/ncdb/redo02a.logNO10rowsselected.三、恢复步骤3.1创建目标主机环境变量V

7、i.profileexportORACLE_HOME=/u01/app/oracle/product/11/db_1exportORACLE_BASE=/u01/app/oracleexportPATH=$PATH:$HOME/bin:$ORACLE_HOME/binexportORACLE_SID=ncdb3.2创建密码文件orapwdfile=$ORACLE_HOME/dbs/orapw$ORACLE_SIDpassword=oracle3.3恢复参数文件登陆RMAN环境，启动到NOMOUNT状态，因此时没有参数文件，RM

8、AN会自动创建一个临时参数文件用于启动数据库；RMAN>startupnomount; startupfailed:ORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile