物理DATAGUARD主備切換對(duì)OGG(DML)同步影響測試

1、物理DATAGUARD主備切換對(duì)OGG（DML）同步影響測試一、環(huán)境介紹數(shù)據(jù)庫角色DG主庫DG備庫OGG同步庫（查查詢庫）IP10.15.559.102210.14.1156.133710.15.334.36操作系統(tǒng)版本AIX 5.33AIX 5.33AIX 5.22Oracle rdbmss版本10.2.0.4.010.2.0.4.010.2.0.4.0OGG版本10.2.0.19 buuild 0002None10.2.0.19 buuild 0002xlC.rtee版本9.0.0.1110.1.0.09.0.0.11Oracle sidoratesttoratesttoratesttDb

2、_uniqque_naameoratesttphyorattestoratestt注：如何搭建環(huán)境在此文檔中不做描述。測試表：tesst.tessttbSQL deesc teest.teesttb Name Nulll? Type - - - A NUMBEER(38)切換前紀(jì)錄：主庫：SQL seelect * froom tesst.tessttb oorder by a; A- 4 6 7 8 9 10 20 100 200 500 11000 A- 11001 11002 55000 30000015 rowss seleected.OGG查詢庫：SQL seelect * froo

3、m tesst.tessttb oorder by a; A- 4 6 7 8 9 10 20 100 200 500 11000 A- 11001 11002 55000 30000015 rowss seleected.通過表中的數(shù)據(jù)據(jù)比較可以看看到主庫與OOGG查詢庫庫為同步狀態(tài)態(tài)。主庫后臺(tái)日志：Thread 1 advvancedd to llog seequencce 48 (LGWRR swittch) Curreent loog# 2 seq# 48 meem# 0: /oraatest/orateest/reedo02.logWed Decc 18 113:28:54 2001

4、3ARC1: SStandbby reddo loggfile seleccted ffor thhread 1 seqquencee 47 ffor deestinaation LOG_AARCHIVVE_DESST_2Wed Decc 18 113:40:32 20013Thread 1 advvancedd to llog seequencce 49 (LGWRR swittch) Curreent loog# 3 seq# 49 meem# 0: /oraatest/orateest/reedo03.logWed Decc 18 113:40:32 20013ARC1: SStandb

5、by reddo loggfile seleccted ffor thhread 1 seqquencee 48 ffor deestinaation LOG_AARCHIVVE_DESST_2可以看到當(dāng)前主主庫歸檔日志志為48號(hào)，在在線日志為449號(hào)（未歸歸檔）DG災(zāi)備庫后臺(tái)臺(tái)日志：RFS1: Idenntifieed dattabasee typee as physiical sstandbbyTue Decc 17 223:27:20 20013RFS LoggMinerr: Cliient ddisablled frrom fuurtherr notiificattionTue Dec

6、c 17 223:29:51 20013RFS1: Succcessfuully oopenedd stanndby llog 4: /orratestt/orattest/sstand001.dbffTue Decc 17 223:29:52 20013Media RRecoveery Loog /orratestt/archhive/11_47_88340599738.ddbfMedia RRecoveery Waaitingg for threaad 1 ssequennce 488Tue Decc 17 223:41:30 20013RFS1: Succcessfuully oopen

7、edd stanndby llog 4: /orratestt/orattest/sstand001.dbffTue Decc 17 223:41:33 20013Media RRecoveery Loog /orratestt/archhive/11_48_88340599738.ddbfMedia RRecoveery Waaitingg for threaad 1 ssequennce 499可以看到當(dāng)前災(zāi)災(zāi)備庫已經(jīng)MMedia Recovvery的歸歸檔日志為448號(hào)，等待待的下個(gè)日志志為49號(hào)綜上，可以判斷斷出主庫與災(zāi)災(zāi)備庫當(dāng)前為為同步狀態(tài)。二、DG主備切切換：主庫操作：1. Alt

8、eer sysstem sswitchh logffile;主庫后臺(tái)日志：Wed Decc 18 113:45:03 20013Thread 1 advvancedd to llog seequencce 50 (LGWRR swittch) Curreent loog# 1 seq# 50 meem# 0: /oraatest/orateest/reedo01.logWed Decc 18 113:45:03 20013ARC1: SStandbby reddo loggfile seleccted ffor thhread 1 seqquencee 49 ffor deestinaatio

9、n LOG_AARCHIVVE_DESST_2備庫后臺(tái)日志：Tue Decc 17 223:46:01 20013RFS1: Succcessfuully oopenedd stanndby llog 4: /orratestt/orattest/sstand001.dbffTue Decc 17 223:46:03 20013Media RRecoveery Loog /orratestt/archhive/11_49_88340599738.ddbfMedia RRecoveery Waaitingg for threaad 1 ssequennce 5002. 在主庫關(guān)關(guān)閉OGG查查詢庫

10、同步進(jìn)進(jìn)程GGSCI (loopbback) 34 iinfo aallProgramm Statuus Grooup LLag Tiime Siince CChkptMANAGERR RUNNIING EXTRACTT RUNNIING DP001 000:00:00 000:00:002 EXTRACTT RUNNIING EXTT01 000:00:00 000:00:006 GGSCI (loopbback) 35 sstop *Sendingg STOPP requuest tto EXTTRACT DP01 .Requestt proccessedd.Sendingg STOPP

11、requuest tto EXTTRACT EXT011 .Requestt proccessedd.GGSCI (loopbback) 36 iinfo aallProgramm Statuus Grooup LLag Tiime Siince CChkptMANAGERR RUNNIING EXTRACTT STOPPPED DP001 000:00:00 000:00:003 EXTRACTT STOPPPED EXTT01 000:00:00 000:00:0013.查看主庫狀狀態(tài)并切換主主-備主庫操作：Sqlsellect NNAME,DDB_UNIIQUE_NNAME,OOPEN_

12、MMODE,PPROTECCTION_MODE,PROTEECTIONN_LEVEEL,SWIITCHOVVER#,DDATABAASE_ROOLE,SWWITCHOOVER_SSTATUSS fromm v$daatabasse;NAME DB_UNIQUUE_NAMME OPPEN_MOODE PPROTECCTION_MODE PROTEECTIONN_LEVEEL SWITTCHOVEER#- - - - - -DATABASSE_ROLLE SWITTCHOVEER_STAATUS- -ORATESTT oraatest REEAD WRRITE MMAXIMUUM PERRFORM

13、AANCE MAXIMMUM PEERFORMMANCE 336698668885PRIMARYY TO SSTANDBBYSqlaltter daatabasse commmit tto swiitchovver too physsical standdby;Databasse alttered.主庫后臺(tái)日志：Wed Decc 18 113:48:01 20013alter ddatabaase coommit to swwitchoover tto phyysicall stanndbyWed Decc 18 113:48:01 20013ALTER DDATABAASE COOMMIT

14、TO SWWITCHOOVER TTO PHYYSICALL STANNDBY (orateest)Wed Decc 18 113:48:02 20013Thread 1 advvancedd to llog seequencce 51 (LGWRR swittch) Curreent loog# 2 seq# 51 meem# 0: /oraatest/orateest/reedo02.logWed Decc 18 113:48:02 20013ARC0: SStandbby reddo loggfile seleccted ffor thhread 1 seqquencee 50 ffor

15、 deestinaation LOG_AARCHIVVE_DESST_2Wed Decc 18 113:48:02 20013SMON: ddisablling ttx reccoveryyWed Decc 18 113:48:02 20013Stoppinng bacckgrouund prrocesss CJQ00Wed Decc 18 113:48:02 20013Stoppinng bacckgrouund prrocesss QMNCCWed Decc 18 113:48:04 20013Stoppinng Jobb queuue slaave prrocessses, fflags

16、 = 27Wed Decc 18 113:48:04 20013Job queeue sllave pprocessses sstoppeedWaitingg for dispaatcherr D0000 too shuttdownAll disspatchhers aand shhared serveers shhutdowwnWed Decc 18 113:48:09 20013SMON: ddisablling ccache recovveryWed Decc 18 113:48:09 20013Shuttinng dowwn arcchive proceessesArchiviing

17、iss disaabledWed Decc 18 113:48:14 20013ARCH shhuttinng dowwnARC1: AArchivval sttoppeddWed Decc 18 113:48:19 20013ARCH shhuttinng dowwnARC0: AArchivval sttoppeddWed Decc 18 113:48:20 20013Thread 1 cloosed aat logg sequuence 51Successsful cclose of reedo thhread 1Wed Decc 18 113:48:20 20013ARCH: NNos

18、wittch arrchivaal of threaad 1, sequeence 551ARCH: EEnd-Off-Redoo Brannch arrchivaal of threaad 1 ssequennce 511ARCH: AArchivving iis dissabledd due to cuurrentt logffile aarchivvalClearinng staandby activvationn ID 333698666885 (0 xc88dc16885)The priimary databbase ccontroolfilee was creatted ussin

19、g ttheMAXLOGGFILESS 16 clausse.There iis spaace foor up to 133 stanndby rredo llogfillesUse thee folllowingg SQL commaands oon thee stanndby ddatabaase too creaatestandbyy redoo logffiles that matchh the primaary daatabasse:ALTER DDATABAASE ADDD STAANDBY LOGFIILE ssrl1.ff SIZZE 5244288000;ALTER DDAT

20、ABAASE ADDD STAANDBY LOGFIILE ssrl2.ff SIZZE 5244288000;ALTER DDATABAASE ADDD STAANDBY LOGFIILE ssrl3.ff SIZZE 5244288000;ALTER DDATABAASE ADDD STAANDBY LOGFIILE ssrl4.ff SIZZE 5244288000;Archiveelog ffor thhread 1 seqquencee 51 rrequirred foor staandby recovverySwitchoover: Primaary coontrollfile c

21、onveerted to sttandbyy conttrolfiile suuccesffully.MRP0 sttartedd withh pid=14, OOS id=18022254Wed Decc 18 113:48:21 20013MRP0: BBackgrround Managged Sttandbyy Recoovery proceess sttartedd (oraatest)Managedd Stanndby RRecoveery noot usiing Reeal Tiime Appply paralllel reecoverry staarted with 15 prr

22、ocesssesOnline logfiile prre-cleearingg operrationn disaabled by swwitchooverMedia RRecoveery Loog /orratestt/archhive/11_51_88340599738.ddbfIdentiffied EEnd-Off-Redoo for threaad 1 ssequennce 511Wed Decc 18 113:48:26 20013Media RRecoveery Ennd-Of-Redo indiccator encouuntereedWed Decc 18 113:48:27 2

23、0013Media RRecoveery Apppliedd untiil chaange 66338777Wed Decc 18 113:48:27 20013MRP0: MMedia Recovvery CCompleete: EEnd-Off-REDOO (oraatest)Resettiing sttandbyy actiivatioon ID 336988668855 (0 xcc8dc16685)Wed Decc 18 113:48:28 20013MRP0: BBackgrround Mediaa Recoovery proceess shhutdowwn (orratestt)

24、Wed Decc 18 113:48:29 20013Switchoover: Compllete - Dataabase shutddown rrequirred (ooratesst)Wed Decc 18 113:48:29 20013Completted: aalter databbase ccommitt to sswitchhover to phhysicaal staandbyWed Decc 18 113:48:29 20013idle diispatccher D000 termminateed, piid = (14, 11)備庫后臺(tái)日志：Tue Decc 17 223:4

25、8:59 20013Redo Shhippinng Cliient CConneccted aas PUBBLIC- Connnectedd Userr is VValidRFS2: Assiigned to RFFS proocess 6554884RFS2: Idenntifieed dattabasee typee as physiical sstandbbyRFS2: Succcessfuully oopenedd stanndby llog 4: /orratestt/orattest/sstand001.dbffTue Decc 17 223:49:03 20013Media RR

26、ecoveery Loog /orratestt/archhive/11_50_88340599738.ddbfMedia RRecoveery Waaitingg for threaad 1 ssequennce 511Tue Decc 17 223:49:18 20013Redo Shhippinng Cliient CConneccted aas PUBBLIC- Connnectedd Userr is VValidRFS3: Assiigned to RFFS proocess 6472880RFS3: Idenntifieed dattabasee typee as physiic

27、al sstandbbyRFS3: Archhived Log: /oraatest/archiive/1_51_83340597738.dbbfTue Decc 17 223:49:19 20013Media RRecoveery Loog /orratestt/archhive/11_51_88340599738.ddbfIdentiffied EEnd-Off-Redoo for threaad 1 ssequennce 511Tue Decc 17 223:49:22 20013Media RRecoveery Ennd-Of-Redo indiccator encouuntereed

28、Tue Decc 17 223:49:22 20013Media RRecoveery Apppliedd untiil chaange 66338777Tue Decc 17 223:49:22 20013MRP0: MMedia Recovvery CCompleete: EEnd-Off-REDOO (oraatest)Resettiing sttandbyy actiivatioon ID 336988668855 (0 xcc8dc16685)Tue Decc 17 223:49:25 20013MRP0: BBackgrround Mediaa Recoovery proceess

29、 shhutdowwn (orratestt)4. 啟動(dòng)主庫庫到mounnt狀態(tài)，并并查看主庫狀狀態(tài)主庫操作：SQL shhutdowwn immmediatteORA-015507: ddatabaase noot mouuntedORACLE instaance sshut ddown.SQL sttartupp mounntORACLE instaance sstarteed.Total SSystemm Globbal Arrea 166106122736 bbytesFixed SSize 20844400 bbytesVariablle Sizze 33858766432 bbyt

30、esDatabasse Bufffers 122079599552 bbytesRedo Buufferss 146922352 bbytesDatabasse mouunted.SQL seelect NAME,DB_UNNIQUE_NAME,OPEN_MODE,PROTEECTIONN_MODEE,PROTTECTIOON_LEVVEL,SWWITCHOOVER#,DATABBASE_RROLE,SSWITCHHOVER_STATUUS froom v$ddatabaase;NAME DB_UNIQUUE_NAMME OPPEN_MOODE PPROTECCTION_MODE PROTEE

31、CTIONN_LEVEEL SWITTCHOVEER#- - - - - -DATABASSE_ROLLE SWITTCHOVEER_STAATUS- -ORATESTT oraatest MOOUNTEDD MMAXIMUUM PERRFORMAANCE MAXIMMUM PEERFORMMANCE 0PHYSICAAL STAANDBY TO PPRIMARRY可以看到已經(jīng)轉(zhuǎn)轉(zhuǎn)變?yōu)閭鋷?.查看備庫狀狀態(tài)并切換備備-主備庫操作：SQL seelect NAME,DB_UNNIQUE_NAME,OPEN_MODE,PROTEECTIONN_MODEE,PROTTECTIOON_LEVVEL,S

32、WWITCHOOVER#,DATABBASE_RROLE,SSWITCHHOVER_STATUUS froom v$ddatabaase;NAME DB_UNIQUUE_NAMME- -OPEN_MOODE PPROTECCTION_MODE- -PROTECTTION_LLEVEL SSWITCHHOVER#- -DATABASSE_ROLLE SWITTCHOVEER_STAATUS- -ORATESTT phyyorateestMOUNTEDD MMAXIMUUM PERRFORMAANCEMAXIMUMM PERFFORMANNCE 00PHYSICAAL STAANDBY TO PP

33、RIMARRYSQL allter ddatabaase coommit to swwitchoover tto priimary;Databasse alttered.SQL allter ddatabaase oppen;Databasse alttered.原主庫后臺(tái)日志志：Wed Decc 18 113:51:55 20013Using SSTANDBBY_ARCCHIVE_DEST parammeter defauult vaalue aas /orratestt/archhiveRedo Shhippinng Cliient CConneccted aas PUBBLIC- Con

34、nnectedd Userr is VValidRFS1: Assiigned to RFFS proocess 18886674RFS1: Idenntifieed dattabasee typee as physiical sstandbbyWed Decc 18 113:51:55 20013RFS LoggMinerr: Cliient ddisablled frrom fuurtherr notiificattion原備庫后臺(tái)日志志：Tue Decc 17 223:52:27 20013alter ddatabaase coommit to swwitchoover tto prii

35、maryTue Decc 17 223:52:27 20013ALTER DDATABAASE SWWITCHOOVER TTO PRIIMARY (orattest)Tue Decc 17 223:52:27 20013If mediia reccoveryy actiive, sswitchhover will wait 900 sseconddsSwitchOOver aafter compllete rrecoveery thhroughh channge 6333877Online log /orateest/orratestt/redoo01.loog: Thhread 1 Gro

36、oup 1 was pprevioously clearredOnline log /orateest/orratestt/redoo02.loog: Thhread 1 Grooup 2 was pprevioously clearredOnline log /orateest/orratestt/redoo03.loog: Thhread 1 Grooup 3 was pprevioously clearredStandbyy becaame prrimaryy SCN: 6338875Convertting sstandbby mouunt too primmary mmount.Tue

37、 Decc 17 223:52:27 20013Switchoover: Compllete - Dataabase mountted ass primmary (orateest)Completted: aalter databbase ccommitt to sswitchhover to prrimaryyTue Decc 17 223:52:27 20013ARC1: SSTARTIING ARRCH PRROCESSSESARC2: AArchivval sttarteddARC1: SSTARTIING ARRCH PRROCESSSES COOMPLETTEARC2 sttart

38、edd withh pid=19, OOS id=5533770Tue Decc 17 223:52:32 20013alter ddatabaase oppenTue Decc 17 223:52:32 20013Assigniing acctivattion IID 336697860035 (00 xc8daadab3)Thread 1 opeened aat logg sequuence 52 Curreent loog# 1 seq# 52 meem# 0: /oraatest/orateest/reedo01.logSuccesssful oopen oof reddo thrre

39、ad 11Tue Decc 17 223:52:32 20013MTTR addvisorry is disabbled bbecausse FASST_STAART_MTTTR_TAARGET is noot settTue Decc 17 223:52:32 20013ARC0: BBecomiing thhe noo SRL ARCHHTue Decc 17 223:52:32 20013SMON: eenabliing caache rrecoveeryTue Decc 17 223:52:32 20013Successsfullyy onliined UUndo TTablesspa

40、ce 1.Dictionnary ccheck beginnningDictionnary ccheck complleteTue Decc 17 223:52:32 20013SMON: eenabliing txx recooveryTue Decc 17 223:52:32 20013Databasse Chaaracteerset is WEE8ISO88859P11Openingg withh inteernal Resouurce MManageer plaanwhere NNUMA PPG = 11, CPUUs = 116replicaation_depenndencyy_tr

41、accking turneed offf (no asyncc multtimastter reeplicaation foundd)Startinng bacckgrouund prrocesss QMNCCQMNC sttartedd withh pid=35, OOS id=6472990Tue Decc 17 223:52:33 20013LOGSTDBBY: Vaalidatting ccontroolfilee withh logiical mmetadaataTue Decc 17 223:52:33 20013LOGSTDBBY: Vaalidattion ccompleete

42、Completted: aalter databbase oopenTue Decc 17 223:52:47 20013Shuttinng dowwn arcchive proceessesTue Decc 17 223:52:52 20013ARCH shhuttinng dowwnARC2: AArchivval sttoppedd6. 查看當(dāng)前前原備庫狀態(tài)態(tài)SQL seelect NAME,DB_UNNIQUE_NAME,OPEN_MODE,PROTEECTIONN_MODEE,PROTTECTIOON_LEVVEL,SWWITCHOOVER#,DATABBASE_RROLE,SSWI

43、TCHHOVER_STATUUS froom v$ddatabaase;NAME DB_UNIQUUE_NAMME- -OPEN_MOODE PPROTECCTION_MODE- -PROTECTTION_LLEVEL SSWITCHHOVER#- -DATABASSE_ROLLE SWITTCHOVEER_STAATUS- -ORATESTT phyyorateestREAD WRRITE MMAXIMUUM PERRFORMAANCEMAXIMUMM PERFFORMANNCE 336977860355PRIMARYY TO SSTANDBBY可以看到已經(jīng)轉(zhuǎn)轉(zhuǎn)變?yōu)橹鲙?. 在原主庫庫開啟D

44、G同同步SQL allter ddatabaase reecoverr manaaged sstandbby dattabasee usinng currrent logfiile diisconnnect ffrom ssessioon;Databasse alttered.原主庫后臺(tái)日志志:- Connnectedd Userr is VValidRFS1: Assiigned to RFFS proocess 18886674RFS1: Idenntifieed dattabasee typee as physiical sstandbbyWed Decc 18 113:51:55 20

45、013RFS LoggMinerr: Cliient ddisablled frrom fuurtherr notiificattionWed Decc 18 113:55:42 20013alter ddatabaase reecoverr manaaged sstandbby dattabasee usinng currrent logfiile diisconnnect ffrom ssessioonWed Decc 18 113:55:42 20013Attemptt to sstart backggroundd Manaaged SStandbby Reccoveryy procce

46、ss (orateest)MRP0 sttartedd withh pid=20, OOS id=19867742Wed Decc 18 113:55:42 20013MRP0: BBackgrround Managged Sttandbyy Recoovery proceess sttartedd (oraatest)Managedd Stanndby RRecoveery sttartinng Reaal Timme Appply paralllel reecoverry staarted with 15 prrocesssesWed Decc 18 113:55:48 20013Wait

47、ingg for all nnon-cuurrentt ORLss to bbe arcchivedd.Clearinng onlline rredo llogfille 1 /orateest/orratestt/redoo01.loogClearinng onlline llog 1 of thhread 1 seqquencee numbber 522Wed Decc 18 113:55:48 20013Completted: aalter databbase rrecoveer mannaged standdby daatabasse usiing cuurrentt logffile

48、 ddisconnnect from sessiionWed Decc 18 113:55:50 20013Clearinng onlline rredo llogfille 1 ccompleeteClearinng onlline rredo llogfille 2 /orateest/orratestt/redoo02.loogClearinng onlline llog 2 of thhread 1 seqquencee numbber 511Clearinng onlline rredo llogfille 2 ccompleeteClearinng onlline rredo ll

49、ogfille 3 /orateest/orratestt/redoo03.loogClearinng onlline llog 3 of thhread 1 seqquencee numbber 499Clearinng onlline rredo llogfille 3 ccompleeteMedia RRecoveery Waaitingg for threaad 1 ssequennce 5228. 在原備庫庫對(duì)表tesst.tessttb進(jìn)行行一系列dmml操作，并并切換日志備庫操作：SQL innsert into test.testttb vallues(55000000);1

50、row ccreateed.SQL innsert into test.testttb vallues(66000000);1 row ccreateed.SQL innsert into test.testttb vallues(77000000); 1 row ccreateed.SQL uppdate test.testttb sett a=100000000 wherre a=66000000;1 row uupdateed.SQL deelete from test.testttb wheere a=5000000;1 row ddeleteed.SQL coommit;Commit

51、 compllete.SQL seelect * froom tesst.tessttb oorder by a; A- 4 6 7 8 9 10 20 100 200 500 11000 A- 11001 11002 55000 300000 7000000 10000000SQL allter ssystemm swittch loogfilee;System alterred.原備庫后臺(tái)日志志：Tue Decc 17 223:59:36 20013Thread 1 advvancedd to llog seequencce 53 (LGWRR swittch) Curreent loog

52、# 2 seq# 53 meem# 0: /oraatest/orateest/reedo02.logTue Decc 17 223:59:36 20013ARC1: SStandbby reddo loggfile seleccted ffor thhread 1 seqquencee 52 ffor deestinaation LOG_AARCHIVVE_DESST_2可以看到當(dāng)前已已經(jīng)歸檔的日日志文件為552號(hào)。原主庫后臺(tái)日志志：Wed Decc 18 113:58:39 20013RFS1: Succcessfuully oopenedd stanndby llog 4: /orrat

53、estt/orattest/sstand001.dbffWed Decc 18 113:58:43 20013Media RRecoveery Loog /orratestt/archhive/11_52_88340599738.ddbfMedia RRecoveery Waaitingg for threaad 1 ssequennce 533可以看到當(dāng)前原原主庫已經(jīng)MMedia Recovvery到第第52號(hào)歸檔檔文件，正在在等待53號(hào)號(hào)歸檔文件通過后臺(tái)日志，可可以確認(rèn)當(dāng)前前主備切換后后的DG體系系，同步正常常。三、DG主備再再切換（即還還原為最初的的主備狀態(tài)）1.查看原備庫庫（即當(dāng)前的的

54、主庫）狀態(tài)態(tài)并切換備-主原備庫操作：SQL seelect NAME,DB_UNNIQUE_NAME,OPEN_MODE,PROTEECTIONN_MODEE,PROTTECTIOON_LEVVEL,SWWITCHOOVER#,DATABBASE_RROLE,SSWITCHHOVER_STATUUS froom v$ddatabaase;NAME DB_UNIQUUE_NAMME- -OPEN_MOODE PPROTECCTION_MODE- -PROTECTTION_LLEVEL SSWITCHHOVER#- -DATABASSE_ROLLE SWITTCHOVEER_STAATUS- -O

55、RATESTT phyyorateestREAD WRRITE MMAXIMUUM PERRFORMAANCEMAXIMUMM PERFFORMANNCE 336977860355PRIMARYY TO SSTANDBBYSQL allter ddatabaase coommit to swwitchoover tto phyysicall stanndby;Databasse alttered.原備庫后臺(tái)日志志：Wed Decc 18 000:06:18 20013alter ddatabaase coommit to swwitchoover tto phyysicall stanndby

56、Wed Decc 18 000:06:18 20013ALTER DDATABAASE COOMMIT TO SWWITCHOOVER TTO PHYYSICALL STANNDBY (orateest)Wed Decc 18 000:06:20 20013Thread 1 advvancedd to llog seequencce 54 (LGWRR swittch) Curreent loog# 3 seq# 54 meem# 0: /oraatest/orateest/reedo03.logWed Decc 18 000:06:20 20013ARC0: SStandbby reddo

57、loggfile seleccted ffor thhread 1 seqquencee 53 ffor deestinaation LOG_AARCHIVVE_DESST_2Wed Decc 18 000:06:30 20013Stoppinng bacckgrouund prrocesss CJQ00Wed Decc 18 000:06:30 20013SMON: ddisablling ttx reccoveryyWed Decc 18 000:06:30 20013Stoppinng bacckgrouund prrocesss QMNCCWed Decc 18 000:06:32 2

58、0013Stoppinng Jobb queuue slaave prrocessses, fflags = 27Wed Decc 18 000:06:32 20013Job queeue sllave pprocessses sstoppeedWaitingg for dispaatcherr D0000 too shuttdownAll disspatchhers aand shhared serveers shhutdowwnWed Decc 18 000:06:36 20013SMON: ddisablling ccache recovveryWed Decc 18 000:06:36

59、 20013Shuttinng dowwn arcchive proceessesArchiviing iss disaabledWed Decc 18 000:06:41 20013ARCH shhuttinng dowwnARC1: AArchivval sttoppeddWed Decc 18 000:06:46 20013ARCH shhuttinng dowwnARC0: AArchivval sttoppeddWed Decc 18 000:06:47 20013Thread 1 cloosed aat logg sequuence 54Successsful cclose of

60、reedo thhread 1Wed Decc 18 000:06:47 20013ARCH: NNoswittch arrchivaal of threaad 1, sequeence 554ARCH: EEnd-Off-Redoo Brannch arrchivaal of threaad 1 ssequennce 544ARCH: AArchivving iis dissabledd due to cuurrentt logffile aarchivvalClearinng staandby activvationn ID 333697886035 (0 xc88dadabb3)The