Thursday, September 4, 2008

Compressing Archive Redo File in Oracle 11g

Hi Friends,
Yesterday working with Oracle 11g, I found something intresting which is really helpful to DBA when we are going to run out of space at archive file mount point.

Now Archived Redo file can be compressed , while transfering to standby database

alter system set log_archive_dest_1='SERVICE=standby1
compression=ENABLE';

To check wheather archive file compression is enabled or not

select dest_name , compression from v$archive_dest;

compression column will show enable if it is enable

No comments:

Post a Comment