Re: "Unapplying" previously applied logs on (standby) database

Hi Markus,

if you don't have a full and consistent backup of your standby database and already have applied the logs there is no way to rollbacl already applied archive logs.

If you have a backup and all the archive logs in between. You can restore the backup and then apply the necessary archive logs

Regards
Stefan

Markus Holmberg wrote:

> Background:
>
> A standby database (i.e. mirror of primary database for backup
> purposes) receives archived redo logs which are applied upon arrival.
>
> Question:
>
> Is it possible to "rollback" the previously applied redo logs to
> perform a "Point In Time Recovery" using the standby database as a
> starting point?
>
> (There is no previous offline full backup on which to start applying
> redo logs, which is the reason I must start with the standby database
> and "unapply" redo logs - if possible.)
>
> /Markus
>
  Received on Thu Jan 17 2002 - 07:55:50 CET