Re: Oracle Backward Recovery

Hi all;

I would presume the scenario the original poster was wondering about would be one where you would read backwards through the last few online/archive redo logs undoing transactions, as opposed to restoring the necessary datafiles and rolling forward through *many* archive log files. We have this capability with our IDMS databases running on our MVS machine, and the few times we needed to roll backward, it was always fun to watch the tapes fast-forward to the EOT marker, and then start reading backwards through the journal (equivilant to oracle logs) entries. And, no, I know of no rollbackward support in Oracle.

Marc Baime wrote:
>
> The question was:
> <<
> Does any current or planned release of Oracle provide a "backward
> recovery" option?>>
>
> Oracle provides the ability to recover to a point in time, so, if what
> you mean by backward recovery is going back to a particular point in
> time you could do the following: Take the last full backup prior to the
> point in time you wish to recover to and apply it to the database. Then
> take the archive logs and use them to roll the database forward to the
> point in time you wish to recover the database to.
>
> Hope this helps.
>
> Regards...Marc Baime
 

-- 

David J. DeWolfe
Systems Programmer 
Statewide Office of Information Services
University of Alaska
907.474.7399
sxdjd_at_orca.alaska.edu

In a vicious struggle for survival intelligence emerges as the weapon of 
 choice. - Nova, In Search of Human Origins