Re: Db crashed with no backups :confused:

From: <>
Date: Fri, 30 Jan 2009 07:29:54 -0800 (PST)
Message-ID: <>

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

Cause: Either incomplete or backup control file recovery has been performed. After these types of recovery you must specify either the RESETLOGS option or the NORESETLOGS option to open your database.

Action: Specify the appropriate option.

ORA-01194: file string needs more recovery to be consistent

Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.

Action: Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery

No "proper, complete" Full Offline Database backups to work with = you're out of luck. Probably don't have a recent Full Export (Logical backup) to work with as well (you could recreate an "empty" database, and then do a Full Import). Be glad this isn't a Production system. Received on Fri Jan 30 2009 - 09:29:54 CST

Original text of this message