物理DATAGUARD主备切换对OGG(DML)同步影响测试

1、物理DATAGUARD主备切换对OGG（DML）同步影响测试一、环境介绍数据库角色DG主库DG备库OGG同步库（查查询库）IP10.15.559.102210.14.1156.133710.15.334.36操作系统版本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注：如何搭建环境在此文档中不做描述。测试表：tesst.tessttbSQL deesc teest.teesttb Name Nulll? Type - - - A NUMBEER(38)切换前纪录：主库：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.通过表中的数据据比较可以看看到主库与OOGG查询库库为同步状态态。主库后台日志：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可以看到当前主主库归档日志志为48号，在在线日志为449号（未归归档）DG灾备库后台台日志：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可以看到当前灾灾备库已经MMedia Recovvery的归归档日志为448号，等待待的下个日志志为49号综上，可以判断断出主库与灾灾备库当前为为同步状态。二、DG主备切切换：主库操作：1. Alt

8、eer sysstem sswitchh logffile;主库后台日志：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备库后台日志：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. 在主库关关闭OGG查查询库

10、同步进进程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.查看主库状状态并切换主主-备主库操作：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.主库后台日志：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)备库后台日志：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. 启动主库库到mounnt状态，并并查看主库状状态主库操作：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可以看到已经转转变为备库5.查看备库状状态并切换备备-主备库操作：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.原主库后台日志志：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原备库后台日志志：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. 查看当前前原备库状态态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可以看到已经转转变为主库7. 在原主库库开启D

44、G同同步SQL allter ddatabaase reecoverr manaaged sstandbby dattabasee usinng currrent logfiile diisconnnect ffrom ssessioon;Databasse alttered.原主库后台日志志:- 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. 在原备库库对表tesst.tessttb进行行一系列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.原备库后台日志志：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可以看到当前已已经归档的日日志文件为552号。原主库后台日志志：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可以看到当前原原主库已经MMedia Recovvery到第第52号归档档文件，正在在等待53号号归档文件通过后台日志，可可以确认当前前主备切换后后的DG体系系，同步正常常。三、DG主备再再切换（即还还原为最初的的主备状态）1.查看原备库库（即当前的的

54、主库）状态态并切换备-主原备库操作：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.原备库后台日志志：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