- 03 Sep, 2023
- 0 Comments
- 45 Secs Read
ORA-01624: Log 1 Needed For Crash Recovery Of Instance
ORA-01624: Log 1 Needed For Crash Recovery Of Instance
Solution :
Â
- Get redo log Group Status :
select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) fsize from v$log l, v$logfile f where f.group# = l.group# order by 1,2
To change the status from ACTIVE to INACTIVE, switch logfile multiple times, till the status is INACTIVE.
SQL> alter system switch logfile; SQL> @log_member alter system switch logfile; SQL> @log_member
Once the redo log group status is INACTIVE, drop it.
SQL> alter database drop logfile group 1; Database altered.