73.0k views
3 votes
What could be an explanation for the failure message "ORA-01624: log 2 needed for crash recovery of instance orcl11g(thread 1)" when issuing the command ALTER DATABASE CLEAR LOGFILE GROUP 2?

User Zdenekca
by
8.3k points

1 Answer

2 votes

Answer:

ORA-01624 means that the redo log group that you want to operate with is needed for recovery once the database startup after a crash

Step-by-step explanation:

User Pretzlstyle
by
7.9k points