Re: Cannot open DB (because corrupt Rman datafile)

Thanks, Koert...

You *will* be attending the Oracle 9i New Features training course, as well won't you??!

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"koert54" <koert54_at_nospam.com> wrote in message
news:ZFmv7.86707$6x5.19402900_at_afrodite.telenet-ops.be...


> 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

> > >

> > >

> > >

> >

> >

>

>