将RAC还原成单机

1、将linuxrac还原成单机作者：therainday201510201:根据原有的rac环境单间数据库的单机平台（仅安装数据软件）原有的LinuxRAC平台环境如下操作系统：ORACLELINUX6.5数据库版本：数据库实例：hdpt12:根据现有的一些信息建立一个空库（这里以hdpt1为例（客户端为erpcx1）3:在现有的这台服务器上安装NBU客户端，并做oracle_linksu-oracle/usr/openv/netbackup/bin/oracle_link并选择YES即可（注：oracle_link）4:根据现有的环境信息列由关于实例hdptl的备份信息su-o

2、racle/usr/openv/netbackup/bin/bplist-Cerpcxl（已备份主机名）-kerpcx_hdpt1（关于所需还原实例的备份策略名字）d4-l-R/oracleffmdelnetfaackupJScdbinioracle®nadei;bplistYrwrworacleasmadmin-rw-rworaclea5madniin-r出耐orac1ea5madniin-r-rw-aclednudniin-r-rw-oracleasinadmir-rw-rworacleasmadmin-rw-rw-rw-rw-r*rw-rw-rw-rw-rw-rw-rw-rw-

3、rw=rw=z-rw-rw*-rinf-rw"-rw-rw-rw-rw-一T'lrtf=W-rw-rw-rw-rw-rw-rw-oracleoracleorac1eoracleQIdeItnrarlcracleorac1eorac1coracleorac】Eoraclenraclporacleaileoracleoracleoracleoracleoraclerasn.adrn-irasnadm'rasmadmir4>niddin'r'rajiadmirasu.admlr器iradrrrasiradminasinadm'rasmadnin

4、.”K三妙rasitiadtmrr,UHiadn-irasmadniirnasirmdirrirasmadm-rn）admLroracle*rw-rworacla-rktf-rworacle-rw-rworacle-rw-rwor4cH-r-rworaclerw-rw'-oracle-rw-rw一JILOiLl口asoiddnilrFT.jdm-rasnf：adnnrasn：aclmrj3nodrrrrasmadninasmadtnirASn：S;lnirerpcxl-kerpcx_ndpn-11992944Sep”QJ：3611527c8KfEC25C3：7fi28544516Sep

5、2503:36262144Sep2503:351W22544Sp2501:35331350016Sep2503:32673T1QOS5叩Z5。于：支192?44424#474木蜡OfiSep2403:331W2864KSep2403:332214424Q3;331W2?944Sep?4<3：33-2!?4"S7624C3:?2Sep24Q$：3£18上24444史口3101:4262144Sep2303:341Q91072K5昨2J03:3350625536Sep有03;箝267144Sfp2门3:3另19922944Sep2Z03:33fi05A700fi5tp21

6、05:32613416968口ZM0:3219922944Sep?203141967815646Sep2205:4061341C66OSep223:40262144Sep2203:3919922944Sep220J：392441546SK5/2203：3Z26fifi4484K£Ap03：32199229445评2103:34109209bKSep2L43：套360788Sep2103:33262144Sep2103:3319922944Sep21。露刀381631664即210稣乂mw-Ntar荣ar）1ni-4-1-ft/aitrl_L085J._89131>35S/alI

7、CaJ169171:362/aOC84_l_891S153C2/hkZ10a2JL_fl91315325.1891515?00/bk_10fi0_11315145/bk_l079_1_09L31514?/cntrOors_l_89122&875/al_lC77_l_89122B639/al_1076JL_891?2fiS39/队075,1_8912ZC613/bk10741的1?"7炉/bk_1073_l_S91Z?6742/收_1C72_1_aylJ/entrSftlU247fi/al_107G_l_891U2460/alJL飙8.891U2434/al_lC69_1_59

8、1U2434/bk1。.8守1；2?4Q。/bk_106_l_891U2392/bk_l005_l_fl9L142337/bk_J0frl_L891U2327/cn：rl_lD63JL_891O55476/31-10七1二391。»缶之。/al_1G62_L_S9LO56420/bk_10«0_l_59105639J/bk_1059_l_891056378/bk_lQ5&_l_a910552/bk_1057l,8MC5SQS2/cntr1_1D5_1_3M96962"1_11）54_L_89U9bP-b；al_1051S9O96962&，bk_l（

9、l5MJL_M096g600/bk_lC52_l_S9O9695B4/W<_1C51_1_89O96952SifsIfidnafica5:恢复spfile文件并进行修改停库，并把数据库切换到nomount状态su-oracleexportORACLE_SID=hdpt1rmantarget/nolog（注：原有的数据库配置有catalog库，所以要切换到nolog模式）shutdownimmediate;startupnomount;在rman执行下列语句进行SPFILE的还原（spfile文件在备份级的最后一个bk文件中）run（allocatechannelch00type'

10、sbt_tape'send'NB_ORA_SERV=nbu5230'send'NB_ORA_CLIENT=erpcx1'restorespfileto'/u01/data/hdpt1.ora'from'/bk_1028_1_891315236'releasechannelch00;将刚才还原的spfile文件取同样的名字，替代原有的spfile文件，并生成pfile文件cp/u01/data/hdpt1.ora/u01/app/oracle//db1/dbs/spfilehdpt1.ora新开一个命令行窗口

11、打开SQL命令行su-oracleexportORACLE_SID=hdpt1sqlplus/nologconn/assysdbacreatepfilefromspfile;shutdownimmediate；修改刚才创立的pfile文件，删除其中所存在关于rac集群参数，删除一些相对新建系统不符合的size参数，对于这次还原修改后的spfile文件内容如下(spfile的文件目录为/u01/app/oracle//product/db1/dbs/inithdpt1.ora)hdpt1._db_cache_size=8254390272hdpt1._java_pool_size

12、=201326592hdpt1._large_pool_size=134217728hdpt1._pga_aggregate_target=3388997632hdpt1._sga_target=10133438464hdpt1._shared_io_pool_size=0hdpt1._shared_pool_size=1476395008hdpt1._streams_pool_size=0_allow_resetlogs_corruption=true_corrupted_rollback_segments=true_offline_rollback_segments=true*audit_

13、file_dest='/u01/app/oracle/admin/hdpt1/adump'*audit_trail='db'*.cluster_database=false*compatible='.0'*.control_files='/u01/data/hdpt1/control01.ctl','/u01/data/hdpt1/control02.ctl'*db_block_size=8192*.db_domain=''*.db_name='hdpt'*.db_r

14、ecovery_file_dest='/u01/app/oracle/fast_recovery_area'*.db_recovery_file_dest_size=4385144832*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=hdptXDB)'hdpt1.instance_number=1*log_archive_format='%t_%s_%r.dbf*.open_cursors=300*.pga_aggregate_target=

15、3368026112*.processes=150#*remote_listener='erpcxscan:1521'*remote_login_passwordfile='exclusive'*.sga_target=10106175488*.sessions=1105hdpt1.thread=1hdpt2.thread=2hdpt1.undo_tablespace='UNDOTBS1'hdpt2.undo_tablespace='UNDOTBS2'修改好pfile后进入到sql命令行，并生成新的spfile,然后将数据库启动到

16、nomount状态su-oraclesqlplus/nologconn/assysdbacreatspfilefrompfile;startupnomount;6:打开一个新的命令行窗口，进入到rman的命令行还原控制文件su-oracleexportORACLE_SID=hdpt1rmantarget/nologrunallocatechannelch00type'sbt_tape'send'NB_ORA_SERV=nbu5230'send'NB_ORA_CLIENT=erpcx1'restorecontrolfilefrom'/cnt

17、rl_1085_1_891315398,;releasechannelch00;)7:等待控制文件还原完成后，将数据库切换到mount状态准备还原数据文件；startupmount;在sql命令行中查看原有的数据文件和存储路径su-oracleexportORACLE_SID=hdpt1sqlplus/nologconn/assysdbaselectnamefromv$datafile;列出一下信息文件编量正)悟式(。)宜春(V)普助(H)systemOl-dbfsysauiOl-dbfundotbsOl.dbfuscrsOl.dbfund.otbs02-dbforahdzbindex.ora

18、+PTDATA/hdpt/systen»01,dbf1-PTDATA/hdpt/sysauxO1-dbfl-PTDATA/lidpt/undutbs01,dbf+PTDATA/hdpt/usersOl.dbf+PTDATA/hdpt/undotbs02.dbftPTDATA/hdpt/lidzbdata.ora4-PTDATA/hdpt/hdzbindek.ora根据这些信息创建恢复数据库文件命令并执行su-oracleexportORACLE_SID=hdpt1rmantarget/nologrunallocatechannelch00type'sbt_tape'a

19、llocatechannelch01type'sbt_tape'send'NB_ORA_SERV=nbu5230'send'NB_ORA_CLIENT=erpcx1'setnewnamefordatafile1to'/u01/data/hdpt1/system01.dbf;setnewnamefordatafile2to'/u01/data/hdpt1/sysaux01.dbf;setnewnamefordatafile3to'/u01/data/hdpt1/undotbs01.dbf;setnewnamefordataf

20、ile4to'/u01/data/hdpt1/users01.dbf'setnewnamefordatafile5to'/u01/data/hdpt1/undotbs02.dbf;setnewnamefordatafile6to'/u01/data/hdpt1/hdzbdata.ora'setnewnamefordatafile7to'/u01/data/hdpt1/hdzbindex.ora'setnewnamefordatafile8to'/u01/data/hdpt1/temp01.dbf;setnewnamefordata

21、file9to'/u01/data/hdpt1/hdzbindex.ora'restoredatabase;switchdatafileall;releasechannelch00;releasechannelch01;)8:等待数据文件还原完成后，执行recover把数据库还原到制定的时间点VIIpLAl.HI：A-_ifflLjpiIL-L199Z2W4Z5。九珞广，f5ILTRIVJ4/LP产IV31.-rw-rw-oracleasmadminIabm-rJrunallocatechannelch00type'sbt_tape'allocatechanne

22、lch01type'sbt_tape'send'NB_ORA_SERV=nbu5230'send'NB_ORA_CLIENT=erpcx1'sql'altersessionsetnls_date_format="yyyy-mm-ddhh24:mi:ss"'setuntiltime'2015-9-253:36:00'recoverdatabase;releasechannelch00;releasechannelch01;)9:等待数据库recover完成后，重做redo日志在sql命令行中查看原

23、有rede文件的路径su-oracleexportORACLE_SID=hdpt1sqlplus/nologconn/assysdbaselectmemberfromv$logfile;列出如下信息4PTDATA/hdpt/redoOl.log+PTDATA/bdpt/redo02,log+PTDATA/hdpt/re<io03.log+PTDATAAdpt/redo04.log+PTDATA/hdpt/redo05-log+PTDATAZh.dpt/redo06,log+PTDATA/hdpt/re<lo07.log+PTDATAAdpt/redo08.log+PTDATA/hd

24、pt/redLaO9,log+PTDATA/Kdpt/redoLO.log+PTDATA/hdpt/re<loll.log+PTDATAAdpt/redol2.log修改redeo文件的路径在sql命令行执行以下命令su-oracleexportORACLE_SID=hdpt1sqlplus/nologconn/assysdbaalterdatabaserenamefile'+PTDATA/hdpt/redo01.log'to'/u01/data/hdpt1/redo01.log'alterdatabaserenamefile'+PTDATA/hd

25、pt/redo02.log'to7u01/data/hdpt1/redo02.log'alterdatabaserenamefile'+PTDATA/hdpt/redo03.log'to'/u01/data/hdpt1/redo03.log'alterdatabaserenamefile'+PTDATA/hdpt/redo04.log'to7u01/data/hdpt1/redo04.log'alterdatabaserenamefile'+PTDATA/hdpt/redo05.log'to7u01/data/hdpt1/redo05.log'alterdatabaserenamefile'+PTDATA/hdpt/redo06.log'to7u01/data/hdpt1/redo06.log'alterdatabaser