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;


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: