Re: Cannot open DB (because corrupt Rman datafile)

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 5 Oct 2001 06:32:35 +1000
Message-ID: <3bbcc6fd@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 Thu Oct 04 2001 - 15:32:35 CDT