Re: Redirect archive
From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Sun, 13 Sep 2009 19:50:54 -0700 (PDT)
Message-ID: <5733b41e-f3ab-4054-9149-bfc77b4bca2f_at_z4g2000prh.googlegroups.com>
Date: Sun, 13 Sep 2009 19:50:54 -0700 (PDT)
Message-ID: <5733b41e-f3ab-4054-9149-bfc77b4bca2f_at_z4g2000prh.googlegroups.com>
You can reset your LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_1 to a new location with an ALTER SYSTEM command. To make this "automatic", you'd have to write a script which monitors the usage of the destination directory and then issues an ALTER SYSTEM command (and switches back to the first destination if the second destination is near-full).
RMAN's BACKUP ARCHIVELOG command will read the archivelogs from the correct location as the name of the archivelog file is actually stored with the full path.
Hemant K Chitale
http://hemantoracledba.blogspot.com
Received on Sun Sep 13 2009 - 21:50:54 CDT