Re: Production DB Crash Recovery process - Some immediate advice ASAP pls
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Sun, 12 Feb 2006 13:45:51 +0100
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:
