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

Could ORA1194 be due to some Datafiles having being ADDED AFTER the LAST Cold backup of 10 Feb 2006, BUT Before occurrence of the CRASH around 6 pm on 11 Feb 2006, which continue to exist in the respective Directories during the recovery process?

Qs How can we identify these Datafiles which are NOT in sync with the rest of the Database files after getting ORA1194 when attempting to open the Databse?

Qs Should we consider removing Such Files, if there, before RE-initiating the CANCEL based recovery process again?

Reference is to the following Article:-

http://www.orafaq.com/usenet/comp.databases.oracle.server/2003/08/20/176 0.htm

Thanks indeed

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Sunday, February 12, 2006 10:32 AM To: Oracle-L
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

Qs. Should we Try to RECOVER to a Lesser Point in time BEFORE 6 pm, say 4:45 pm?

NOTE - We can NOT Recover to a point in Time After 6 pm.

Respond ASAP pls,

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l