Re: rman online backup with exclude undo tablespace

On Jan 18, 2008 3:38 PM, Prasad <p4cldba_at_gmail.com> 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
>

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