Re: Dataguard in data warehousing

Just to add to Frank's brilliant article "recover database nologged block" actually works by copying the blocks from the primary and is only available for active data guard, not for the run of the mill maximum performance data guard in mounted state. As for the network simulation, thank you, I've learned something. However, I am not sure what should it simulate, I would still prefer to measure my network throughput by iperf3 (https://iperf.fr/) That should give me a good idea whether the link can support my rate of change or not.

On 11/24/19 6:29 AM, Franck Pachot wrote:
> Hi Ram,
> For nightly direct-path loads you have the choice of logging (no
> nologging operations and force logging to be sure) or sync after the
> load (12.2 ADG makes it easy:
> https://blog.dbi-services.com/12cr2-recover-nonlogged-blocks-after-nologging-in-data-guard/).
> If you have an idea about the volume, you can simulate on your network
> with oratcptest (see
> https://dbamarco.wordpress.com/2016/11/25/benchmarking-data-guard-throughput/)
>
> Franck.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

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