將RAC還原成單機

1、將linuxrac還原成單機作者：therainday201510201:根據(jù)原有的rac環(huán)境單間數(shù)據(jù)庫的單機平臺（僅安裝數(shù)據(jù)軟件）原有的LinuxRAC平臺環(huán)境如下操作系統(tǒng)：ORACLELINUX6.5數(shù)據(jù)庫版本：數(shù)據(jù)庫實例：hdpt12:根據(jù)現(xiàn)有的一些信息建立一個空庫（這里以hdpt1為例（客戶端為erpcx1）3:在現(xiàn)有的這臺服務(wù)器上安裝NBU客戶端，并做oracle_linksu-oracle/usr/openv/netbackup/bin/oracle_link并選擇YES即可（注：oracle_link）4:根據(jù)現(xiàn)有的環(huán)境信息列由關(guān)于實例hdptl的備份信息su-o

2、racle/usr/openv/netbackup/bin/bplist-Cerpcxl（已備份主機名）-kerpcx_hdpt1（關(guān)于所需還原實例的備份策略名字）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:恢復(fù)spfile文件并進行修改停庫，并把數(shù)據(jù)庫切換到nomount狀態(tài)su-oracleexportORACLE_SID=hdpt1rmantarget/nolog（注：原有的數(shù)據(jù)庫配置有catalog庫，所以要切換到nolog模式）shutdownimmediate;startupnomount;在rman執(zhí)行下列語句進行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；修改剛才創(chuàng)立的pfile文件，刪除其中所存在關(guān)于rac集群參數(shù)，刪除一些相對新建系統(tǒng)不符合的size參數(shù)，對于這次還原修改后的spfile文件內(nèi)容如下(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,然后將數(shù)據(jù)庫啟動到

16、nomount狀態(tài)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:等待控制文件還原完成后，將數(shù)據(jù)庫切換到mount狀態(tài)準備還原數(shù)據(jù)文件；startupmount;在sql命令行中查看原有的數(shù)據(jù)文件和存儲路徑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根據(jù)這些信息創(chuàng)建恢復(fù)數(shù)據(jù)庫文件命令并執(zhí)行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:等待數(shù)據(jù)文件還原完成后，執(zhí)行recover把數(shù)據(jù)庫還原到制定的時間點VIIpLAl.HI：A-_ifflLjpiIL-L199Z2W4Z5。九珞廣，f5ILTRIVJ4/LP產(chǎn)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:等待數(shù)據(jù)庫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命令行執(zhí)行以下命令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