Re: Production DB Crash Recovery process - Some immediate advice ASAP pls

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_at_infosys.com> 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>

>

--
http://www.freelists.org/webpage/oracle-l