Re: Point-in-time recovery in a standby database ?

In article <8tcfv9$5im$1_at_wanadoo.fr>,
  "Matthieu Krembel" <m.krembel_at_wanadoo.fr> wrote:
> Hi,
>
> Is it possible to do point-in-time recovery in a standby database ?
>
> ---------------
> Matthieu Krembel
> m.krembel_at_wanadoo.fr
>
>

If the standby database is in managed recovery mode then every time the primary writes an archive log that log is applied to the standby database. You may also do manual recovery where the standby database is used for queries and the archive logs are applied when the database is no longer online. Presuming the standby instance is in managed recovery mode then point-in-time recovery is assured (presuming that the archive logs can be successfully transmitted to the standby server). The only transactions lost are those not archived when the primary server "dies" (however if the primary server CAN archive the most recent transactions prior to "kicking the bucket" [usually by executing 'ALTER SYSTEM ARCHIVE LOG CURRENT'] those transactions will be applied to the standby database). I believe this is as close to point-in-time recovery as one can get with a standby configuration.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.