Re: Redirect archive
Date: Sun, 13 Sep 2009 19:50:54 -0700 (PDT)
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