If you think education is expensive, try ignorance. (Derek Bok)
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).