Oracle 10g R2 RAC+ASM恢复到单实例(一)

2014-11-24 18:41:10 · 作者: · 浏览: 0

rac源服务器:


rac1:192.168.100.201


rac2:192.168.100.202


目标服务器:


192.168.8.201


恢复的主要步骤如下:


恢复初始化参数文件->修改参数文件->恢复控制文件->resotre数据文件->recover数据文件


# oracle 10g


export ORACLE_BASE=/oracle/ora10g


export ORACLE_HOME=$ORACLE_BASE/product/db


export CRS_HOME=$ORACLE_BASE/product/crs


exportPATH=$CRS_HOME/bin:$ORACLE_HOME/bin:$PATH


export ORACLE_OWNER=oracle


export ORACLE_SID=jscn2


exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib


export NLS_LANG='american_america.ZHS16GBK'


#exportNLS_LANG='american_america.AL32UTF8'


umask 022


目标服务器ORACLE_SID不要设置


根据这个环境变量创建目标服务器数据库(包括,数据库的安装,升级包安装,数据库不要创建)


[oracle@IM-8-201 ~]$ rman target /



Recovery Manager: Release 10.2.0.4.0 -Production on Tue Nov 22 21:45:18 2011



Copyright (c) 1982, 2007, Oracle. All rights reserved.



connected to target database (not started)



RMAN> startup nomount;



startup failed: ORA-01078: failure inprocessing system parameters


LRM-00109: could not open parameter file'/oracle/ora10g/product/db/dbs/initjscnora'



starting Oracle instance without parameterfile for retrival of spfile


Oracle instance started



Total System Global Area 159383552 bytes



Fixed Size 2082400 bytes


Variable Size 67111328 bytes


Database Buffers 83886080 bytes


Redo Buffers 6303744 bytes



把最近的0级备份和后面的备份文件拷贝到


我们看到备份集有如下


-rw-r----- 1 oracle oinstall 622592 Dec 2 16:11 arch_JSCN_20111202_286


-rw-r----- 1 oracle oinstall 266752 Dec 2 16:11 arch_JSCN_20111202_287


-rw-r----- 1 oracle oinstall 140288 Dec 2 16:13 arch_JSCN_20111202_296


-rw-r----- 1 oracle oinstall 36352 Dec 2 16:13 arch_JSCN_20111202_297


-rw-r----- 1 oracle oinstall 16908288 Dec 2 16:13 control_c-2437751542-20111202-00


-rw-r----- 1 oracle oinstall 196608 Dec 2 16:11 lev0_JSCN_20111202_288


-rw-r----- 1 oracle oinstall 32784384 Dec 2 16:11 lev0_JSCN_20111202_289


-rw-r----- 1 oracle oinstall 172032 Dec 2 16:11 lev0_JSCN_20111202_290


-rw-r----- 1 oracle oinstall 388726784Dec 2 16:12 lev0_JSCN_20111202_291


-rw-r----- 1 oracle oinstall 256327680Dec 2 16:13 lev0_JSCN_20111202_292


-rw-r----- 1 oracle oinstall 9658368 Dec 2 16:13 lev0_JSCN_20111202_293


-rw-r----- 1 oracle oinstall 15204352 Dec 2 16:13 lev0_JSCN_20111202_294


-rw-r----- 1 oracle oinstall 1818624 Dec 2 16:13 lev0_JSCN_20111202_295


这几个都是最近的备份,control_c-2437751542-20111202-00一个包含初始化参数文件



让我们恢复参数文件


[oracle@IM-8-201 ~]$ rman target /



Recovery Manager: Release 10.2.0.4.0 -Production on Tue Nov 22 22:07:18 2011



Copyright (c) 1982, 2007, Oracle. All rights reserved.



connected to target database: DUMMY (notmounted)



RMAN> restore spfile to pfile'/home/oracle/initjscn.ora' from '/orabak/lev2_JSCN_20111201_182';



Starting restore at 22-NOV-11


using target database control file insteadof recovery catalog


allocated channel: ORA_DISK_1


channel ORA_DISK_1: sid=39 devtype=DISK



channel ORA_DISK_1: autobackup found:/orabak/lev2_JSCN_20111201_182


channel ORA_DISK_1: SPFILE restore fromautobackup complete


Finished restore at 22-NOV-11



--查看/home/oracle/initjscn.ora


接下来要做的是个体力活,修改 pfile.ora中的初始化参数,主要有两方面的修改


a 修改含文件路径的参数,达到符合当前服务器环境的实际情况


b 修改多实例相关的参数


c 内存参数(如果源服务器和目录服务器内存一样大,不用调)


原文件内容如下:



---------------------------------------------------------------------------------------------------


jscn2.__db_cache_size=1207959552


jscn1._