Oracle 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> ALTABASE 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 CLOGFILE 'C: /Oracle/log2a.rdo';

9.using logminer analyzing redo 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;