Re: Anymore possibilities - disaster recovery

Perhaps loss of (all) the archived log files, when database in archive log mode...
Then need to perform an incomplete recovery, with UNTIL CANCEL clause...

Regards.

"godmann" <allanwtham_at_yahoo.com> a écrit dans le message news: 95cd51c.0202172334.79e466e_at_posting.google.com...
> Hi there,
>
> I am helping to compile a *all-possible* crash scenarios. Do you think
> there is anything more than the following? Once compiled, I think it will
> help a lot people out there to recover their database with more
confidence!
>
> The faq is located at Jonathan's site by the way!
>
>
>
> How do I recover from ...
>
> loss of a datafile that belongs to the SYSTEM tablespace
> loss of a datafile that belongs to Rollback Segment tablespace
> loss of a datafile that belongs to an Index-only tablespace
> loss of a datafile that belongs to a TEMP tablespace
> loss of a datafile that belongs to READ-ONLY tablespace
> loss of a datafile that belongs to a typical data tablespace
> How do I recover in a situation where there is no datafile backup
> loss of one member of online redo log group
> loss of an inactive redo log group
> loss of an active redo log group
> loss of an unarchived online log file
> loss of a multiplexed control file member
> complete loss of a control file
>
>
>
> Allan W. Tham
> DBA
Received on Mon Feb 18 2002 - 10:18:38 CST