RE: Production Database Crash Recovery process - Some immediate advice ASAP pls

Vivek,

Was the backup you are recovering from complete as of 11 Feb 2006 18:00?

If so, try this:

SQL> recover database using backup controlfile until cancel

Then when prompted for the file, immediately enter:
> CANCEL
Then try opening again. This hocus-pocus actually often works.

If this does not work, post the output from select * from v$recover_file;

You may also contact me directly if you wish.

Jeremiah Wilton
ORA-600 Consulting
Recoveries - Seminars - Hiring
http://www.ora-600.net

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Subject: Production Database Crash Recovery process - Some immediate advice ASAP pls

With a Production Crash on Hands, some urgent advice would help Folks:-

Aim - To Recover the Database upto 6 pm Point in time of 11 Feb 2006.

Using CANCEL based recovery upon attempting to open the Databse following Error is occurring:-

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

--
http://www.freelists.org/webpage/oracle-l