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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restore Readonly Tablespace Via Partial Clone

Re: Restore Readonly Tablespace Via Partial Clone

From: Andrey Kriushin <Andrey.Kriushin_at_rdtex.ru>
Date: Thu, 04 May 2006 17:12:32 +0400
Message-ID: <4459FDC0.1000606@rdtex.ru>


Hi,
> I’ve done a test today on a dev db by creating a tablespace and making
> it readonly, then run backup control file to trace. The output is
> saying (see below) that I can open the database and rename the
> "MISSINGXXX" file then put the tablespace online. Interesting note the
> MISSING000NN NN is the file# of the datafile.
Right, up to this point everything is as expected. Your cf creation script is now much better. Might not be perfect yet...

> alter database open resetlogs
> .... waiting
> "disconnection forced, host def doesnt’t exist"
> Which, from my experience is Oracles way of saying "your database is
> toast"

No, no, no. It is the info from your server process, not from the instance. It just seeks your sympathy because something went wrong in its relations with the instance ;-).

Did Oracle instance say something more specific in its alert.log? Probably someting about undo or just missed file with a name similar to MISSING...? Some datafile number which magically coincides with that of undo tablespace datafile?

BTW, what are parameter settings for UNDO_MANAGEMENT, UNDO_TABLESPACE?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 04 2006 - 08:12:32 CDT

Original text of this message

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