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"
I'm open for any suggestions, and will post my findings
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 ;
# Database can now be opened zeroing the online logs. ALTER DATABASE OPEN RESETLOGS;
# Online the files in read-only tablespaces. ALTER TABLESPACE "READONLY" ONLINE; Andrey Kriushin wrote:
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.
As far as I know, *undo* doesn't corrupt datafiles, but instead participates in recovering them ;-). Of course, in your particular case with cold backup after clean (it that true?) shutdown there are no dead transactions which need to be recovered.
BTW, probably I missed something: what do you mean by "partial clone"? Is that some new procedure in 10g which I'm not aware of? Some automated step in TSPITR? Or is it just good old "take some datafiles, switch the others offline or not mention them when creating controlfile"?
-- "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."