Re: Restore Readonly Tablespace Via Partial Clone

You need the UNDO tablespace datafile as well.

(experience with 8.1.7, when the RBS file was missing [inadvertently] and Oracle could not
complete the rollback of the instance recovery).

Check the alert.log file for messages.

Hemant
At 08:08 AM Thursday, Bob wrote:
>Hi - my partial clone is to recover 1 table from a multi terabyte database
>when all I have is a cold backup:
>
><snip>
>This method always works- but I need a different technique forš the
>readonly tablespace
>
>But doing controlfile technique below corrupts the system and sysaux, like
>so....
>create control file from below syntax, then
>
>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"
>š
>
>
>šSTARTUP NOMOUNT
>CREATE CONTROLFILE SET DATABASE "newt" RESETLOGSš NOARCHIVELOG
>MAXLOGFILES 32
>MAXLOGMEMBERS 3
>MAXDATAFILES 254
>MAXINSTANCES 1
>MAXLOGHISTORY 909
>LOGFILE
>š GROUP 1 ('/sourcedb001/oradata/sourcedb/redo101.log') SIZE 100M,
>š GROUP 2 ('/sourcedb001/oradata/sourcedb/redo201.log') SIZE 100M
>DATAFILE
>š '/sourcedb001/oradata/sourcedb/system01.dbf',
>š '/sourcedb001/oradata/sourcedb/sysaux01.dbf'
>*readonly files do not appear in this list*
>CHARACTER SET US7ASCII
>;

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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