needs more recovery to be consistent

[fordikon]

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'

[marist89]

'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.

[fordikon]

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

[fordikon]

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

how do i open the database.

[comascio]

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

Corrado

[fordikon]

win2k.. i closed using shutdown abort.

[adewri]

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.

[aarroyob]

As Jeff suggest use:

recover database;

Cheers

[fordikon]

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'

[adewri]

What is the message when you give recover database command.