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.
- ORA-00257 archiver error Connect internal only until freed fixed in best way.
- How to resolve ORA-19809 limit exceeded for recovery files
- How to resolve Terminating the instance due to error 16038