Lesson 6 | Recreating Redo Log Files |
Objective | Describe the Steps to recreate Inactive Redo Logs |
ALTER DATABASE CLEAR LOGFILE
command drops and recreates the corrupt online redo file, but you can also perform this process manually.
It's a helpful procedure to know if the ALTER DATABASE CLEAR LOGFILE
command fails and reusing the currently configured log file name to recreate the log file becomes impossible.SVRMGR> STARTUP OPEN PFILE='C:\ORANT\DATABASE\INITORCL.ORA' ORACLE instance started. Total System Global Area 11710464 bytes Fixed Size 49152 bytes Variable Size 11177984 bytes Database Buffers 409600 bytes Redo Buffers 73728 bytes Database mounted. ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\ORANT\DATABASE\LOG2ORCL.ORA' SVRMGR> SELECT * FROM V$LOGFILE; GROUP# STATUS MEMBER ------ ------- ---------------------------------------------- 1 C:\ORANT\DATABASE\LOG4ORCL.ORA 2 STALE C:\ORANT\DATABASE\LOG3ORCL.ORA 3 STALE C:\ORANT\DATABASE\LOG2ORCL.ORA 4 C:\ORANT\DATABASE\LOG1ORCL.ORA 4 rows selected. SVRMGR> ALTER DATABASE DROP LOGFILE GROUP 3; Statement processed. SVRMGR> ALTER DATABASE ADD LOGFILE GROUP 3 'C:\ORANT\DATABASE\LOG2ORCL.ORA' SIZE 150k; Statement processed. SVRMGR> ALTER DATABASE OPEN; Statement processed. SVRMGR>