In fact if you can still access the drives
on the primary machine and pull the online
redo logs, you can switch into manual
recovery and feed these to the standby
(with a little trial and error) using manual
recovery.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison Wesley Longman
Book bound date now 1st Dec 2000
oratune_at_aol.com wrote in message <8tcktj$591$1_at_nnrp1.deja.com>...
>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.
Received on Fri Oct 27 2000 - 14:59:04 CDT
