Re: Restore Readonly Tablespace Via Partial Clone

Hi, Im running behind, but my experience is , including undo and opening
the db via partial clone, will corrupt the datafiles . Just system and
sysaux.
bob

Andrey Kriushin wrote:

> Hi,> the easiest way to learn what to do about READ ONLY tablespaces and > their files is to ask RBDMS itself.>> Mount the database using binary controlfile from April 7 backup. Issue> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;> ORADEBUG SETMYPID> ORADEBUG TRACEFILE_NAME>> Check the trace file named in the last command. Carefully check where > the names of READ ONLY tablespace datafiles are placed. Do they appear > in CREATE CONTROLFILE statement? So by now you'll have a working example.>> BTW, I've not noticed any UNDO tablespace. Did you just forget about > it? You'll need SYSTEM, SYSAUX and **UNDO** when recreating controfile.>> HTH> - Andrey

--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."
--
http://www.freelists.org/webpage/oracle-l