Re: Cannot open DB (because corrupt Rman datafile)

Naaah - the last course I followed was Oracle 8i Parallel Server in Bethesda and I didn't like the food there :-) - I first booked the course in hong kong but I was the only subscriber so they cancelled it :-) I'd rather buy a couple of good books and learn it myself .... a collegue of mine went to the 9i new features this week tho :-)

Cheers

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3bbe4233_at_news.iprimus.com.au...
> 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Sat Oct 06 2001 - 06:31:56 CDT