第四章管理重做日志重做日志簡介日志切換和檢查點增加和刪除重做日志顯示重做日志信息分析重做日志1重做日志簡介Group2Group3Group1Disk1Disk2MemberMemberMemberMemberMemberMember2重做日志工作原理數(shù)據(jù)庫實例SGACKPTLGWRDBWR數(shù)據(jù)高速緩存控制文件

數(shù)據(jù)文件重做日志重做日志緩沖區(qū)ARCH參數(shù)文件口令文件歸檔日志3日志切換和檢查點強制日志切換ALTERSYSTEMSWITCHLOGFILE;檢查點參數(shù)LOG_CHECKPOINT_INTERVALLOG_CHECKPOINT_TIMEOUT手工檢查點ALTERSYSTEMCHECKPOINT4增加重做日志組log3a.rdo日志組1日志組2日志組3ALTERDATABASEADDLOGFILE('g:\test\test3a.log','g:\test\test3b.log')SIZE1M;log3b.loglog1a.rdoLog1a.loglog2a.rlog5增加重做日志成員日志組2日志組1ALTERDATABASEADDLOGFILEMEMBER'g:\test\test1b.log'TOGROUP1,'g:\test\test2b.log'TOGROUP2;log2b.loglog2a.loglog1b.loglog1a.log6改變重做日志名稱或位置復制重做日志到新位置：copy修改重做日志名稱ALTERDATABASERENAMEFILE'g:\test\test3a.log'TO'g:\test\test3c.log';7刪除日志組日志組1日志組2日志組3ALTERDATABASEDROPLOGFILEGROUP3;log1a.rdolog2a.rdolog3b.rdolog3a.rdolog1b.rdolog2b.rdo8刪除日志成員日志組2日志組1ALTERDATABASEDROPLOGFILEMEMBER'g:\test\test2b.log';log1a.rdolog2b.rdolog1b.rdolog2a.rdo9清除重做日志ALTERDATABASECLEARLOGFILEGROUP1;10顯示重做做日志信信息V$LOGV$LOGFILE11分析重做做日志跟蹤數(shù)據(jù)據(jù)庫、表表和用戶戶改變映像數(shù)據(jù)據(jù)訪問取消數(shù)據(jù)據(jù)庫變化化12使用LogMiner建立字典典文件指定重做做日志分析重做做日志跟蹤改變變結束LogMiner13建立字典典文件指定I/O目錄錄：UTL_FILE_DIR=g:\test重新啟動動數(shù)據(jù)庫庫：STARTUPFORCE建立字典典文件：：executedbms_logmnr_d.build('dict.ora',\'g:\test');14指定重做做日志關閉數(shù)據(jù)據(jù)庫：SHUTDOWN安裝數(shù)據(jù)據(jù)庫：STARTUPMOUNT建立重做做日志列列表executedbms_logmnr.add_logfile(\'g:\test\test1a.log',\DBMS_LOGMNR.NEW);增加其它它重做日日志executedbms_logmnr.add_logfile(\'g:\test\test2a.log',\DBMS_LOGMNR.ADDFILE);15分析重做做日志executedbms_logmnr.start_logmnr(\dictfilename=>'g:\test\dict.ora');16跟蹤改變變SELECTtimestamp,username,sql_redo,sql_undofromv$logmnr_contentswhereseg_name='EMP';17結束LogMinerexecutedbms_logmnr.end_logmnr;18獲得日志志分析信信息V$LOGMNR_DICTIONARYV$LOGMNR_PARAMETERSV$LOGMNR_CONTENTS19練習四顯示重做做日志文文件位置置、日志志組及