Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot open DB (because corrupt Rman datafile)

Re: Cannot open DB (because corrupt Rman datafile)

From: koert54 <koert54_at_nospam.com>
Date: Thu, 04 Oct 2001 17:48:20 GMT
Message-ID: <Eh1v7.85385$6x5.19002863@afrodite.telenet-ops.be>


do

->alter database datafile 11 offline;
-> alter database open ;
-> alter tablespace rman offline immediate ;
-> drop tablespace rman ; -> TS = GONE

"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 Thu Oct 04 2001 - 12:48:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US