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 11.2.0.1 (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 11.2.0.1 (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 11.1.0.6 and 11.1.0.7 (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!
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,
Martin
Hi Martin,
unfortunately it is not a case, it was set to TRUE. I installed Enterprise Edition and did not turn off any options.
Thanks,
Andrey
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 ?
I was not able to make it work, might be it worth to check 11.2.0.2 if there are any changes there