On Jan 18, 2008 3:38 PM, Prasad <p4cldba@xxxxxxxxx> wrote: > All, > > we had a online backup taken on a 10gr2 production db on solaris with > configure exclude undo tablespace . we are trying to do a disaster recovery > scenario to build a test system. > > However we are getting into this scenario. > > ORA-00704: bootstrap process failure > ORA-00604: error occurred at recursive SQL level 2 > ORA-00376: file 2 cannot be read at this time > ORA-01110: data file 2: '/datastore/sfods03/undotbs01.dbf' > Thu Jan 17 20:14:19 2008 > Error 704 happened during db open, shutting down database > USER: terminating instance due to error 704 > Instance terminated by USER, pid = 21434 > > Is it recoverable? sorry but I don't know if you are in an unrecoverable situation; what I know for sure is that undo data are necessary to oracle to work correctly: so why did you 'configure exclude undo tablespace'? By and large 'configure exclude' option is there for read only tablespaces. Mario Cariggi. Regards. > > TIA > -Prasad > -- //www.freelists.org/webpage/oracle-l