oracle 10gR2 RAC+ASM恢复到单实例

1、oracle 10gr2 rac+asm恢复到单实例复原的主要步骤如下： 复原初始化参数文件- 修改参数文件- 复原控制文件- resoe数据文件- recover数据文件 1、正确安装单实例数据库 1）查看rac文件环境变量 oracle $ an target / recovery manager: release .0 -proction on tue nov 22 21:45:18 2011 copyright (c) 1982, 2007, oracle. all rights reserv. connected to target database (not sta

2、rted) rman startup nomount; startup failed: ora-01078: failure inprocessing system parameters lrm-00109: could not open parameter /oracle/ora10g/product/db/dbs/initjscnora starting oracle instae without parameterfile for retrival of spfile oracle instance started total system global area 159383552 b

3、ytes fixed size 2082400 bytes variable size 67111328 bytes database buffers 83886080 bytes redo buffers 6303744 bytes 2）从备份集中复原spfile，并保存成pfile，操作如下 把最近的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

4、_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-

5、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

6、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 $ rman target / recovery manager: release .0 -pr

7、oduction on tue nov 22 22:07:18 2011 copyright (c) 1982, 2007, oracle. all rights reserved. connected to target database: dummy (notmounted) rman 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 r

8、ecovery alog ald channel: ora_disk_1 channel ora_disk_1: s=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中的初始化参数，主要有两方面的

9、修改 a 修改含文件路径的参数，达到符合当前服务器环境的实际状况 b 修改多实例相关的参数 c 内存参数(假如源服务器和名目服务器内存一样大，不用调) 原文件内容如下： - jscn2._db_cache_size=1207959552 jscn1._db_cache_size=1207959552 jscn2._java_pool_size=16777216 jscn1._java_pool_size=16777216 jscn2._large_pool_size=16777216 jscn1._large_pool_size=16777216 jscn2._shared_pool_size

10、=352321536 jscn1._shared_pool_size=352321536 jscn2._streams_pool_size=0 jscn1._streams_pool_size=0 *.audit_file_dest=/oracle/ora10g/admin/jscn/a *.background_dump_dest=/oracle/ora10g/admin/jscn/bdump *.cluster_database_instances=2 *.cluster_database=true *.compatible=.0 *.control_files= data

11、/jscn/controlfile/current.263.768517111 *.core_dump_dest=/oracle/ora10g/admin/jscn/ump *.db_block_size=8192 *.db_create_file_dest= data *.db_domain= *.db_file_multiblock_read_count=8 *.db_name=jscn *.disers=(protocol=tcp)(service=jscnxdb) jscn1.instance_number=1 jscn2.instance_number=2 *.job_queue_p

12、rocesses=10 jscn1.log_archive_dest_1=location=/oraarch1/ jscn2.log_archive_dest_1=location=/oraarch2/ jscn1.log_archive_dest_2=service=jscn2 jscn2.log_archive_dest_2=service=jscn1 *.open_cursors=300 *.pga_aggregate_target=2512388096 *.processes=1500 *.remote_listener=listeners_jscn *.remote_login_pa

13、ssworile=clusive *.sessions=1655 *.sga_target=1610612736 jscn1.standby_archive_dest=/oraarch2/ jscn2.standby_archive_dest=/oraarch1 jscn2.thread=2 jscn1.thread=1 *.undo_management=auto jscn1.undo_tablespace=undotbs1 jscn2.undo_tablespace=undotbs2 *.user_dump_dest=/oracle/ora10g/admin/jscn/udump - 终于

14、修改完之后，这里的初始化参数如下，比如本来的文件精简不少： - *.audit_file_dest=/oracle/ora10/admin/jscn/adump *.background_dump_dest=/oracle/ora10/admin/jscn/bdump *.compatible=.0 *.control_files=/oracle/ora10/oradata/jscn/control01.ctl,/oracle/ora10/oradata/jscn/control02.ctl,/oracle/ora10/oradata/jscn/control03.ctl *.

15、core_dump_dest=/oracle/ora10/admin/jscn/cdump *.db_block_size=8192 *.db_domain= *.db_file_multiblock_read_count=8 *.db_name=jscn *.job_queue_processes=10 *.log_archive_dest_1=location=/oraarch *.open_cursors=300 *.pga_aggregate_target=251238809 *.processes=150 *.remote_login_passwordfile=exclusive *

16、.sessions=165 *.sga_target=261061273 *.undo_management=auto undo_tablespace=undotbs1 *.user_dump_dest=/oracle/ora10/admin/jscn/udump - 创建相应的名目 oracle $ -p/oracle/ora10/admin/jscn/adump oracle $ mkdir -p/oracle/ora10/admin/jscn/bdump oracle $ mkdir -p/oracle/ora10/admin/jscn/cdump oracle $ mkdir -p/o

17、racle/ora10/admin/jscn/udump oracle $ mkdir -p /oracle/ora10/oradata/jscn/ 现在我们开头复原了 sql create spfile from pfile=/home/oracle/initjscn.ora; file created. sql shutdown immediate sql startup nomount oracle instance shut down. sql startup nomount ora-07446: sdnfy: bad value/oracle/ora10g/admin/jscn/ud

18、ump for parameter user_dump_dest. sql startup nomount oracle instance started. ora-04030: out of process memory whentrying to allocate 32 bytes (sqlarea,tmp) 假如遇到以上错误 -1、创建相应的名目 -2、修改pga_aggregate_target为合适的 sql startup nomount oracle instance started. total system global area 264241152 bytes fixed

19、size 2083200 bytes variable size 83887744 bytes database buffers 171966464 bytes redo buffers 6303744 bytes 3）复原控制文件 控制文件我们默认是自动备份的，所以我们要选取最新的控制文件来复原数据 -rw-r- 1 oracle oinstall 16908288 dec 2 16:13 control_c-2437751542-20111202-00 1 设置dbid oracle $ rman target / recovery manager: release .0

20、-production on tue nov 22 23:55:44 2011 copyright (c) 1982, 2007, oracle. all rights reserved. connected to target database: jscn (notmounted) rman dbid= 2437751542 exeing command: set dbid rman restore controlfile from/orabak/201112/01_l0/cro_c-2437751542-20111201-00; starting restore at 23-nov-11 using target database control file insteadof recovery catalog allocated channel: ora_disk_1 channel ora_disk_1: sid=157 devtype=disk channel ora_disk_1: restoring control fil