Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Feb 3, 2012 2:06 PM by mseberg
Feb 3, 2012 6:17 AM
I am on 184.108.40.206, and want to know if I can compress the archives which we store locally.
ie., for Log_archive_dest_1
We have Log_archive_dest_2(for standby) for which we have already specified Compression=Enable
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Archives compression
Feb 3, 2012 2:06 PM
in response to
The only information I can find on this is :
: ALTER DATABASE ARCHIVELOG COMPRESS ENABLE/DISABLE IS MISSING IN 10G DOCS
I can't find any official reference to the syntax in 11g. I would say don't use it.
Syntax I'm referring to :
ALTER DATABASE ARCHIVELOG COMPRESS ENABLE/DISABLE
Also I would not compress an an archive since if you need it for recovery, you have to decompress.
Please consider closing some of your old questions.
1 person found this helpful