Re: Production DB Crash Recovery process - Some immediate advice ASAP pls
- From: LiShan Cheng <exriscer@xxxxxxxxx>
- To: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- Date: Sun, 12 Feb 2006 14:35:55 +0100
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 <cjpengel.dbalert@xxxxxxxxx> 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.
>
> Best regards,
>
> Carel-Jan Engel
>
> ===
> 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@xxxxxxxxxxx> wrote:
>
>
> 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).
>
> <SNIP>
>
>
>
>
>
Other related posts:
