Re: Data Guard Archived Log Transport Question

  • From: Carel-Jan Engel <careljan@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Mar 2008 23:47:18 +0100

If you're on 8i (Solaris, HP/UX, AIX) Oracle Data Guard 3.x for
will compress by default. Then we talk archived redo log.

If you're on any other version < 11g, you're stuck: no (oracle)
compression. ssh can help there, but if you use SYNC redo transport
(CPU)cost is high, compression rate low.
BTW, from 9.0 onwards I think you mean redo transport, not archived
redo. Most Data Guard implemementations like to have their redo at the
standby earlier than at log switch time.

If you're on 11g: Only compression for gap resolution is available (at a
penalty of 25% more license fee on top of EE). ARCH transport is
obsolete in 11g. All Data Guard redo transport is configured using LGWR
and its slaves. ARCH only kicks in when gaps have to be resolved.

For compression you're better off with HW compression (talk to your
network guys, to extend the switches).

Best regards,

Carel-Jan Engel

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

On Mon, 2008-03-24 at 22:30 +0000, Binh Pham wrote:

> Do you know if archived logs which are transported to the Data Guard
> sites can be compressed for slow network bandwidth?  How if it is
> possible?
> Also, I understand that I can use Oracle Advanced Security option to
> encrypt the archived log data, is that correct?
> Thanks.
> ______________________________________________________________________
> In a rush? Get real-time answers with Windows Live Messenger. 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner, and is 
> believed to be clean.

Other related posts: