Re: Cannot open DB (because corrupt Rman datafile)

Howard - I followed the link to your website - those are some funky pdf files you have there of the Oracle 9i
new features !!!
Thanks for making them available - I for one will enjoy reading them for my 9i OCP upgrade !

Again - thanks !
koert

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3bbcc6fd_at_news.iprimus.com.au...
> You can only talk tablespace language *when* the database is fully open,
so
> the command you want is alter database datafile x offline. Database
> language (ie, talking to the controlfile) is available in the MOUNT stage,
> which is the one you fell over in.
>
> On another point, is this database actually useful for anything other than
> RMAN? I mean is it your real, live, production database? If so, why on
> Earth is the RMAN tablespace *within* the database it's supposed to be
> backing up? The RMAN catalog is supposed to be in a separate database on
a
> separate machine. Otherwise, it would be a case of too many eggs in one
> vulnerable basket.
>
> Regards
> HJR
> --
> Resources for OracleT: www.geocities.com/howardjr2000
> =========================================
>
>
> "Eric" <h9515895_at_sinatown.com> wrote in message
> news:9pgl5e$dfd$1_at_hfc.pacific.net.hk...
> > Hi,
> >
> > I have a 8i database and the Rman tablespace is within this database.
> > Now, I had faced a fatal error. My datafile of Rman tablespace is
> > corrupted. So, I cannot open my database.
> >
> >
> > When I startup the database, the database cannot open:
> > ORA-01122: database file 11 failed verification check
> > ORA-01110: data file 11: '/oracle/u01/oradata/prod/rman.dbf'
> > ORA-01251: Unknown File Header Version read for file number 11
> >
> > Even, "alter tablespace Rman offline" and "alter database open" still
> > cannot open. What can I do now?
> >
> > I don't know how to drop the Rman database in "mount state"
> >
> > Welcome to any suggestion
> >
> > Thanks
> > Eric
> >
> >
> >
>
>
Received on Fri Oct 05 2001 - 13:07:53 CDT