Clearing Log Files

Clearing Log Files

Clearing the redo log files is usually the first remedy used in
repairing a damaged instance ; it's the equivalent of dropping and
re-adding each file.



SELECT * FROM v$log ;


ALTER DATABASE CLEAR LOGFILE 'filename' ;


/* if archive log mode is true, may need to force the clear */

ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'filename' ;

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2 ;