Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot open DB (because corrupt Rman datafile)
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