Re: Production DB Crash Recovery process - Some immediate advice ASAP pls
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?
On 2/12/06, Carel-Jan Engel <firstname.lastname@example.org> wrote:
Vivek wrote 1 Datafile ( as: one datafile, a datafile, only one datafile)
He didn't write Datafile 1 (as: the first datafile)
He also wrote it was added after the last HOT backup. Datafile 1 is usually there since database creation, and not added afterwards.
If you think education is expensive, try ignorance. (Derek Bok)
On Sun, 2006-02-12 at 11:51 +0100, LiShan Cheng wrote:
I am interested how did you put file 1 offline and opened the database. File 1 should be system tablespace, I dont think that can be offlined ever?
On 2/12/06, VIVEK_SHARMA <
VIVEK_SHARMA@infosys.com> wrote: <SNIP>
DATABASE is UP & OPEN Hemant, Jeremiah.
Thanks indeed for all the Support
It was a Case of 1 Datafile NOT being in sync with the rest of Database.
This had been added after the Last HOT backup(being used in recovery).