ORA-01624: log 9 needed for crash recovery of instance PRODDB (thread 1) ora error
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-01624: log 9 needed for crash recovery of... Expand / Collapse
Message
Posted 4/30/2009 9:49:57 AM Post #120
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Hi,

I'm getting the following ora error message:

SQL> alter database drop logfile group 9;
alter database drop logfile group 9
*

ERROR at line 1:
ORA-01624: log 9 needed for crash recovery of instance proddb (thread 1)
ORA-00312: online log 9 thread 1: '+SHARED_DATA_DG03/proddb/onlinelog/group_9.273.685470789'

At first I couldn't figure out why it was giving me this message even thought I switched my logs several times.  My database is open and the current active log was group 2 and when i tried to drop group 9 this is the error that I got.  Then after looking at oerr ora 01624 it immediately occurred to me to do a checkpoint so this is what i did:

SQL> alter system checkpoint;

System altered.

After I issued this statement, it allowed me to drop the group:


SQL> alter database drop logfile group 9;

Database altered.

Hope this helps.

 

Thanks,

 

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:28am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.059. 9 queries. Compression Disabled.