Re: Restore Readonly Tablespace Via Partial Clone

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?

• Andrey

--
http://www.freelists.org/webpage/oracle-l