Oracle Logbook

September 5, 2011

How to avoid out of disk space at archive area

Filed under: Uncategorized — Helio Dias @ 3:43 pm

You should use another destination area as ALTERNATE , then set the primary area to use this area in case of fail.
alter system set log_archive_dest_state_2=’alternate’   scope=both;

alter system set log_archive_dest_2=’LOCATION=+ASMDATA’ scope=both;

— you probable already have the dest_1 setted, but you need anyway to put the NOREOPEN and the ALTERNATE

alter system set log_archive_dest_1=’location=+ASMONLINE noreopen alternate=log_archive_dest_2′ scope=both;


Blog at