日志传输压缩模式oracle,[DataGuard] ORACLE的日志传输进程不能充分利用专线带宽

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

同时对与ARCH传输还可以启用compression压缩

How to confirm if Redo Transport Compression is used In Dataguard? (Doc ID 1927057.1)To BottomTo Bottom

In this Document

Goal

Solution

References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later

Information in this document applies to any platform.

GOAL

o How to check if redo transfer compression is used?

SOLUTION

As per

Note 729551.1: Redo Transport Compression in a Data Guard Environment

is available since 11gR1.

The COMPRESSION attribute is used to specify whether redo data is compressed before transmission to a redo transport destination.

This is one of the attribute set in the log_archive_dest_2 (in the primary database)

If broker is enabled, we should not set the log_archive_dest_2 directly. Has to set through the broker configuration tool (dgmgrl)

The property need to set is RedoCompression.

Details on how to set the above attributes by sqlplus or dgmgrl can refer to the abovementioned note.

The redo transport should use the compression mode, but the neither alert log or tracefile, there is no indication of what is the happening.

If set the log_archive_trace to level 16, should show the following in the tracefile.

SQL> alter system set log_archive_trace=16;

or

DGMGRL> edit database 'db_unique_name' set property LogArchiveTrace'=16;

where the 'db_unique_name' is the primary database name.

Here is the extraction from the tracefile.

Trace file /u01/diag/rdbms/sydpdb1/SYDPDB1/trace/SYDPDB1_tt00_14905.trc

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ORACLE_HOME = /u02/app/product/12.1.0.1/db_1

....

Issuing standby Create archive destination at '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=aulnx14)(PORT=12101))(CONNECT_DATA=(SERVICE_NAME=MELPDB1)(INSTANCE_NAME=MELPDB1)(SERVER=DEDICATED)))' to RFS (PID:24568) instnum [1]

RTC enabled.

...

RTC: Compression ratio for this I/O is 82%

RTC: actual compressed bytes# 88

From the _tt00_.trc, it indicates that RTC is enabled, and the ratio and actual compressed bytes used.