RE: Production DB Crash Recovery process - Some immediate advice ASAP pls
- From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- To: <exriscer@xxxxxxxxx>
- Date: Sun, 12 Feb 2006 10:54:00 -0800
Lishan,
Vivek had added a datafile since the last recovery.
When Vivek restored the database, he left the CURRENT version of the new
datafile in place, instead of deleting it. That meant that the current
checkpoint SCN of that one file was WAY ahead of all the other files.
When he went to open the database, it checked to make sure all the files
were recovered forward to the highest SCN of all datafiles. It found that
the NEW datafile had the highest SCN, and began checking all the other
datafiles to make sure they were also recovered up to that SCN. The first
datafile it checked was file #1, the SYSTEM datafile #1. Upon finding at
least one file in the database that was not recovered forward to the highest
SCN of all datafiles, it failed with ORA-01194, and specified the datafile
that it had found.
That is why to solve this problem, Vivek had to look at v$recover_file, and
examine the recovery SCNs of each datafile to find out which one was way out
ahead of the others.
Jeremiah Wilton
ORA-600 Consulting
Recoveries - Seminars - Hiring
http://www.ora-600.net
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of LiShan Cheng
well he said he had this error
Using CANCEL based recovery upon attempting to open the Databse
following Error is occurring:-
ORA-01194: file 1 needs more recovery to be consistent
Isn't file 1 system.dbf?
Other related posts:
