Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot open the database, stuck in mount mode

728359Nov 30 2009 — edited Dec 5 2009
Someone please shed some lights on this problem.

I ran into some media failure, and ended up restoring the database from the offline whole backup.
The database is in the nonarchivelog mode (I know, it is not good), so there is no archive log files and
restore database is the only solution.
. startup mount
. restore database <== ran ok
. ALTER DATABASE CLEAR LOGFILE GROUP 1 <== ran ok
. ALTER DATABASE CLEAR LOGFILE GROUP 2 <== alter failed
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)

Alter failed with group 2 and 3 because one was CURRENT,
and one was ACTIVE.

SQL> select group#, sequence#, members, status from v$log;

GROUP# SEQUENCE# MEMBERS STATUS
---------- ---------- ---------- ----------------
1 0 2 UNUSED
3 189 2 CURRENT
2 188 2 ACTIVE

I also tried 'alter database open resetlogs', and got:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
I don't think I can recover the datafile since there is no archive log file here.
Besides, if the restore database ran fine, why did I get SYSTEM01.DBF datafile needs media recovery message?

Right now, the database is in mount mode, and I cannot open it. How do I solve the problem with
ALTER DATABASE CLEAR LOGFILE GROUP for group 2 and 3?

Any suggestion? Thank you for the input.
The database is 11G running on Window.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2010
Added on Nov 30 2009
15 comments
5,766 views