Clearing redo logfile in oracle database

by
Clearing redo logfile in oracle database | Sometimes redo log file become corrupted while database open the database may “lock up” and we are unable to do anything because archiving can’t continue this case you may execute ‘ALTER DATABASE CLEAR LOGFILE‘ statement to reinitialize the redo log file and database continue processing.
 
 

Clearing redo logfile in oracle database using below steps.

SQL> select GROUP#, MEMBERS, ARCHIVED, STATUS from v$log;

    GROUP# SEQUENCE#    MEMBERS ARC STATUS
———- ———- ———- — —————-
         3      69151          2 YES UNUSED

         5      69150          2 YES INACTIVE
         4      69152          2 NO  CURRENT



Note:- Specifying UNARCHIVED makes backups unusable if the redo log is needed for recovery. Do not use CLEAR LOGFILE to clear a log needed for media recovery.

If the corrupted redo log file has not been archived, use the unarchived keyword in the alter database clear logfile statement. See here we are Clearing redo logfile in oracle database for unarchived logfile.  Using below command, we will fix redo log file corrupted in oracle. 


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 5;

The unarchived option clears the corrupt online redo log and avoids archiving it.



Related Post:-

Leave a Comment