Oracle数据库管理分析过程

wanghailiang,41,第四章管理重做日志,重做日志简介日志切换和检查点增加和删除重做日志显示重做日志信息分析重做日志,wanghailiang,42,重做日志简介,wanghailiang,43,重做日志工作原理,wanghailiang,44,日志切换和检查点,强制日志切换ALTERSYSTEMSWITCHLOGFILE;检查点参数LOG_CHECKPOINT_INTERVALLOG_CHECKPOINT_TIMEOUT手工检查点ALTERSYSTEMCHECKPOINT,wanghailiang,45,增加重做日志组,log3a.rdo,日志组1,日志组2,日志组3,ALTERDATABASEADDLOGFILE(g:testtest3a.log,g:testtest3b.log)SIZE1M;,log3b.log,Log1a.log,log2a.rlog,wanghailiang,46,增加重做日志成员,wanghailiang,47,改变重做日志名称或位置,复制重做日志到新位置：copy修改重做日志名称ALTERDATABASERENAMEFILEg:testtest3a.logTOg:testtest3c.log;,wanghailiang,48,删除日志组,日志组1,日志组2,日志组3,ALTERDATABASEDROPLOGFILEGROUP3;,log1a.rdo,log2a.rdo,log3b.rdo,log3a.rdo,log1b.rdo,log2b.rdo,wanghailiang,49,删除日志成员,日志组2,日志组1,ALTERDATABASEDROPLOGFILEMEMBERg:testtest2b.log;,log2b.rdo,log1b.rdo,log2a.rdo,wanghailiang,410,清除重做日志,ALTERDATABASECLEARLOGFILEGROUP1;,wanghailiang,411,显示重做日志信息,V$LOGV$LOGFILE,wanghailiang,412,分析重做日志,跟踪数据库、表和用户改变映像数据访问取消数据库变化,wanghailiang,413,使用LogMiner,建立字典文件指定重做日志分析重做日志跟踪改变结束LogMiner,wanghailiang,414,建立字典文件,指定I/O目录：UTL_FILE_DIR=g:test重新启动数据库：STARTUPFORCE建立字典文件：executedbms_logmnr_d.build(dict.ora,g:test);,wanghailiang,415,指定重做日志,关闭数据库：SHUTDOWN安装数据库：STARTUPMOUNT建立重做日志列表executedbms_logmnr.add_logfile(g:testtest1a.log,DBMS_LOGMNR.NEW);增加其它重做日志executedbms_logmnr.add_logfile(g:testtest2a.log,DBMS_LOGMNR.ADDFILE);,wanghailiang,416,分析重做日志,executedbms_logmnr.start_logmnr(dictfilename=g:testdict.ora);,wanghailiang,417,跟踪改变,SELECTtimestamp,username,sql_redo,sql_undofromv$logmnr_contentswhereseg_name=EMP;,wanghailiang,418,结束LogMiner,executedbms_logmnr.end_logmnr;,wanghailiang,419,获得日志分析信息,V$LOGMNR_DICTIONARYV$LOGMNR_PARAMETERSV$LOGMNR_CONT