Re: Restore Readonly Tablespace Via Partial Clone

  • From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
  • To: orcl@xxxxxxxxxxx
  • Date: Thu, 04 May 2006 17:12:32 +0400

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



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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006