Re: DR Failover data loss

Hi Visal,

Please see my comments inline.

On Fri, 2005-06-24 at 09:47, vishal shah wrote:

> Hi,
>
> We have a 2 node RAC database with a physical standby at a remote
> location in MAXIMUM PERFORMANCE mode.

Version, OS?

> This ensures that the primary
> database works smoothly in case there are any issues with the DR site.

What is smoothly? If the standby fails, even MAX. AVAILABILITY will let the primary continue after the (configurable timeout) passed.

> Opting this also means that there might be data loss in case of the
> primary site going down. The data loss will be for all the archive
> logs that are not transported and applied at the standby database.

Max. performance is not restricted to redo shipping by ARCH. It can also be implemented with LGWR redo shipping in place, in ASYNC mode. In that case you might have some transactions in the online redo replicated to the other end as well. If you're lucky, all transactions might be there.

> That might be a few minutes in case of peak time and a few hours in
> case there is no load. Is there some way to find out how much will be
> the data loss time? 10 minutes / 20 minutes?

Monitor V$ARCHIVED_LOG (for remote destinations) and V$ARCHIVE_GAP for the actual GAP. Maybe you can predict (by analyzing the historicy of your monitoring) with some accuracy how much data loss you risk at certain times of the day

> Also is there some way to
> ensure that archive logs gets generated every N minutes whether the
> log file is full or not? I've looked at FAST_MTTR_TARGET but it does
> not help. It is set to 300 but there are occurances wherein the log
> file has not been generated for 4-5 hours in our case.

Look at parameter ARCHIVE_LAG_TARGET.

>
> Thanks,
> --
> http://www.freelists.org/webpage/oracle-l

Best regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

DBA!ert, Independent Oracle consultancy Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel. +31 (0) 182 64 04 28
fax +31 (0) 182 64 04 29
e-mail info.dbalert_at_xs4all.nl

--
http://www.freelists.org/webpage/oracle-l