Redo Transport Compression

Posted in: Technical Track

I was co-presenting recently at Sydney Oracle Meetup about Data Guard Compression and in preparation I did some tests to see how it works for (Linux x86-64) …and I am still not able to see it working.

There is a note “Redo Transport Compression in a Data Guard Environment [ID 729551.1]”
on MOS how to set compression for redo transport destination
and for log archive gaps but none of those settings helped to see compression
reported neither in trace files nor in v$archived_log view (compressed column).

Possibly at first compression for archive logs was mentioned in the
“Archivelog compression?” post but even “alter database archivelog compress enable”
works in (still not documented)
it does not affect compression of archive logs although archivelog_compression in
v$database changed to ENABLED.

Later on I checked ability of alter database… to influence compression of archive logs
in and (Linux x86-64) and got positive results:

in both versions archive logs of 50M were decreased in size to ~10M
and trace file for ARCH process was updated with information about ratio
of compression:

Archivelog compression complete.
  Input: 50969088 bytes Output: 10307875 bytes
  Compression Performance: 79.78 percent or 1.62 bits per byte

But for 11g Rel.2 database created from predefined templates compression did not work.
Does it require some special additional options or specific hidden parameters configuration
in addition to mentioned in the note COMPRESSION=ENABLE and “_redo_transport_compress_all”
(which by default set to TRUE)?

Definitely truth is out there…

Have a good day!

Want to talk with an expert? Schedule a call with our team to get the conversation started.

4 Comments. Leave new

Hi Andrey,

could it be that the advanced compression option is disabled?

The COMPRESSION attribute is ignored if the Advanced Compression option has not been enabled.

select * from v$option where parameter = ‘Advanced Compression’;

Best Regards,

Andrey Goryunov
October 27, 2010 6:35 am

Hi Martin,

unfortunately it is not a case, it was set to TRUE. I installed Enterprise Edition and did not turn off any options.



Got the same issue here …

>>But for 11g Rel.2 database created from predefined templates compression did not work.

How do you manage to make it work ?

Andrey Goryunov
April 4, 2011 4:57 pm

I was not able to make it work, might be it worth to check if there are any changes there


Leave a Reply

Your email address will not be published. Required fields are marked *