RE: Production DB Crash Recovery process - Some immediate advice ASAP pls
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 12 Feb 2006 11:04:54 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
