How to Set Alternative Archivelog Destination
672273Feb 22 2010 — edited Feb 23 2010Hi,
I am using Oracle 10.2.0.4 on AIX 5.3.
My database is in archivelog mode.
I have set the LOG_ARCHIVE_DEST_1 parameter value to /u01/archives/
This is 200GB mount point and my daily archivelogs size is around 300GB. I want to set another location for archives so that once the first archive destination is full, then the alternative location could be used for archive logs.
Otherwise I am getting following error once the mount point is fill.
------------------------------------------------------------------------------------------
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Feb 22 09:27:02 2010
ORACLE Instance malik - Archival Error
Mon Feb 22 09:27:02 2010
ORA-16038: log 4 sequence# 10175 cannot be archived
ORA-00001: unique constraint (.) violated
Mon Feb 22 09:27:02 2010
------------------------------------------------------------------------------------------
What I know is that if we set multiple archive destinations then oracle write to these locations in parallel which means a copy of archive log will be avaialble on both mount points and double space will be utilized. My concern is if we could use one destination for archives and once it is full, then the alternative location be used for next archives.
Waiting for kind response.
Regards
Farooq