Re: ALTER DATABASE ARCHIVELOG COMPRESS ENABLE

Niall, thanks for your input.

I was just researching about it just after I have sent my previous email.

http://afatkulin.blogspot.com/2017/07/122-acfs-compression-part-i.html

Yes, this can be a reasonable solution. And supported too!

I just can't figure out why compression is just an ACFS option. Why not also a Disk Group attribute?

*--*
*Att*

*Luis Santos*

Em sex, 21 de dez de 2018 às 10:04, <niall.litchfield_at_gmail.com> escreveu:

> In the case of ASM you could always provision an ACFS filesystem which
> also supports compression since 12.2,:). I'd be wary of using a feature
> that's been around since 10 and never made it to documented status when
> there are supported alternative options.
>
> On Fri, Dec 21, 2018 at 10:26 AM Luis Santos <lsantos_at_pobox.com> wrote:
>
>> I'm aware of on-the-fly compression filesystems since old Windows Stacker.
>>
>> This is not an option for Oracle DBs in ASM.
>>
>> But thanks anyway!
>>
>>
>> *--*
>> *Att*
>>
>>
>> *Luis Santos*
>>
>>
>>
>> Em qui, 20 de dez de 2018 às 17:01, Mladen Gogala <
>> gogala.mladen_at_gmail.com> escreveu:
>>
>>> Ah that!
>>>
>>> That too is supported:
>>>
>>> https://www.redhat.com/en/blog/look-vdo-new-linux-compression-layer
>>>
>>> You can have a compressed file system and put your archive logs there.
>>> NTFS too has such capability. There is no reason for Oracle to do
>>> compression of the archive logs. I prefer rman to maintain cleanliness of
>>> my LOG_ARCHIVE_DEST_1. And cleanliness is next to godliness.
>>>
>>> Regards
>>>
>>>
>>> On 12/20/18 1:16 PM, Luis Santos wrote:
>>>
>>> This relates to on-the-fly compression on redo log transport between
>>> Data Guard DB nodes.
>>>
>>> --
>>> Mladen Gogala
>>> Database Consultant
>>> Tel: (347) 321-1217
>>>
>>>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

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