Chapter 1 : Common Log Management Order Chapter 1 : Log Management 1.forcing log switches Sql> alter system switch logfile; 2.forcing checkpoints Sql> alter system checkpoint; 3.adding online redo log groups Sql> alter database add logfile [group 4] Sql> ( '/disk3/log4a.rdo,' '/disk4/log4b.rdo') size 1m; 4.adding online redo log members Sql> alter database add logfile member Sql> '/disk3/log1b.rdo' to group 1. Sql> '/disk4/log2b.rdo' to group 2; 5.changes the name of the online redo logfile Sql> alter database rename file 'c:/oracle/oradata/oradb/redo01.log' Sql> to 'c:/oracle/oradata/redo01.log'; 6.drop online redo log groups Sql> alter database drop logfile group 3; 7.drop online redo log members Sql> alter database drop logfile member 'c:/oracle/oradata/redo01.log'; 8.clearing online redo log files Sql> alter database clear [unarchived] logfile 'c:/oracle/log2a.rdo'; 9.using redo logminer analyzing logfiles A. In the init.ora specify utl_file_dir = '' B. Sql> execute dbms_logmnr_d.build ( 'oradb.ora,' 'c:\oracle\oradb\log'); C. Sql> execute dbms_logmnr_add_logfile ( 'c:\oracle\oradata\oradb\redo01.log' Sql> dbms_logmnr.new); D. Sql> execute dbms_logmnr.add_logfile ( 'c:\oracle\oradata\oradb\redo02.log' Sql> dbms_logmnr.addfile); E. Sql> execute dbms_logmnr.start_logmnr (dictfilename=> 'c:\oracle\oradb\log\oradb.ora'); F. Sql> select * from v$logmnr_contents (v$logmnr_dictionary, v$logmnr_parameters Sql> v$logmnr_logs); G. Sql> execute dbms_logmnr.end_logmnr; [ Closed window ]