needs more recovery to be consistent

when i start the db is does not open and asks me to issue 'alter database open resetlog', and i get the following error..

what is the solution?


ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DB\SYSTEM01.DBF'

'D:\ORACLE\ORADATA\DB\SYSTEM01.DBF' is probably older than the rest of the files in your database. It must be brought current with a RECOVER DATABASE command.

could u pls explain me clearly.. my DB is not in archieve log and not having log backup. how do i solve this problem.

when i try to open the database it give me diff DATAFILE name.

how do i open the database.

How did you close the database last time.
On which OS are you?

Corrado

win2k.. i closed using shutdown abort.

If you have closed this using shutdown abort the just mount the database and give recover database command why are you trying to open with resetlogs option.

As Jeff suggest use:

recover database;

Cheers

SVRMGR> connect internal
Password:
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 705525004 bytes
Fixed Size 70924 bytes
Variable Size 186044416 bytes
Database Buffers 519331840 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> alter database open;
alter database open
*
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01248: file 7 was created in the future of incomplete recovery
ORA-01110: data file 7: 'D:\ORACLE\ORADATA\DB\DATA01.DBF'

What is the message when you give recover database command.

I get this error when i give
SVRMGRL>recover database

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Main problem is given by the shutdown abort that has left the database in an inconsistent state that cannot by solved by automatic instance recovery performed by Oracle at startup.
This situation is similar to what sometimes happens with hot backup recovery.
Please note that the following advice makes the database unsupportable by Oracle. So... it's your own risk!! Do not do it in Production databases.

You can :
- set the undocumented parameter "_allow_resetlogs_corruption" to TRUE ,
- startup,
- apply all available redo logs,
- do a resetlogs startup,
- shutdown
- change the parameter back to FALSE
- startup
- take a full export of the database
- rebuild the database


... and next time try to shutdown immediate!

ok

put _allow_resetlogs_corruption=true in your init.ora file and then open the database with resetlogs option.

but i would still recommend you restore all your files from any recent cold backup

HTH

i get the same error message even after i enabled the init.ora file option "_allow_resetlogs_corruption=true"

SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01248: file 7 was created in the future of incomplete recovery
ORA-01110: data file 7: 'D:\ORACLE\ORADATA\DB\DATA01.DBF'

any other option for recovering.

Quote:

---

Originally posted by fordikon
i get the same error message even after i enabled the init.ora file option "_allow_resetlogs_corruption=true"

SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01248: file 7 was created in the future of incomplete recovery
ORA-01110: data file 7: 'D:\ORACLE\ORADATA\DB\DATA01.DBF'

any other option for recovering.

---

Did you do a shutdown ??

Shutdown,make changes in the init.ora file then startup mount, open database resetlogs.

... I raise my hands

yes.. i did shutdown immediate.. make the parameter in init.ora FALSE. and restarted the DB but with no success.

any other way of doing this.

Quote:

---

Originally posted by fordikon
yes.. i did shutdown immediate.. make the parameter in init.ora FALSE. and restarted the DB but with no success.

any other way of doing this.

---

_allow_resetlogs_corruption=true

not false

i made it true. shutdown immediate and restarted the db and got the same error.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Quote:

---

Originally posted by fordikon
i made it true. shutdown immediate and restarted the db and got the same error.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

---

ok do the following

1. recreate the controlfiles with resetlogs option.
2. let the value _allow_resetlogs_corruption be there.
3. open database with resetlogs option.

on how to recreate controlfiles refer to

http://www.dbasupport.com/forums/sho...threadid=34259

I get this error when i tried from sqlplus.

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress



**** Logged in as internal and tried and recd the error:..*****

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01507: database not mounted

i open the database and now it is pointing to
ORA-01113: file 1 needs media recovery
ORA-01110: datafile1 d:\...\system.dbf

i dont know what to say here....

Raise a TAR.

if you have a backup then restore it. if not then you can say goodbye to your database.

I hope this is not your prod db

Thanks for the support. this is not prod DB. i am re-creating the DB.

I guess .This is one of the nice example for the disaster happended due to not enabling archive log, right? or having cold backup.

Quote:

---

Originally posted by fordikon
this is not prod DB. i am re-creating the DB..

---

you've just killed me!

:)

Hi

This thread has really got me curious..can anybody tell me how do i reproduce his situation at my home ...i would like to know the steps in how we can reproduce this problem

regards
Hrishy