Re: Question about DataGuard

On 25 Jul 2006 12:45:57 -0700, emdproduction_at_hotmail.com wrote:

>Group,
>
>I have a question when reading about Dataguard.
>
>Say, I have a primary database and standby database, and all the
>archived logfile are shipped from primary databaes to standby site on
>confirmed mode.
>
>If my primary database was crashed and not available, all I have in
>standby site is the archvived log files, what happens to the
>transactions in online redo but not archived yet? Is there any way I
>can transfer info in online redos to standby site?
>
>Will I lose some data if my primary site went down suddenly?
>
>Thanks for any people who will clear this up for me.

If the standby database is in automatic recovery mode, the shipped archives are automatically applied to it. In this situation you would loose maximum one log file. Now it is your assignment to size the redo log properly, so you - don't loose too much data
- don't have a checkpoint too frequently.

--
Sybrand Bakker, Senior Oracle DBA