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
;
