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