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> >