Dual Archive Logs Location
840712Mar 3 2011 — edited Mar 9 2011Hello, im here again!
Last month we have a problem with datafiles space (archive logs + temp files), our disk wasnt enough. We build a new server with ISCSI Target and mount a new disk on Oracle Red Hat (extra 225GB Hard Disk). Everything is working fine now, but, we need a proper configuration, for example:
My SPFile (Archiving):
log_archive_dest_1: LOCATION=/datafiles/oradata/archive
log_archive_dest_2: LOCATION=/archivelogs (NEW DISK)
log_archive_dest_state_1: ALTERNATE
log_archive_dest_state_2: ENABLE (NEW DISK) - Priority
What was the idea? We use the ISCSI Target (log_archive_dest_2_state, ENABLE) to save the archivelogs as long as is avaiable, if not, the log_archive_dest_1_state, ALTERNATE should GO avaliable, but isnt working like that.
When we test the system (shut the network down from ISCSI Target), the Oracle works as usual, but instead save the files in the log_archive_dest_1 (cause log_archive_dest_2 isnt available) , it just keep it i dont know where.
Have i done something wrong? i can provide more information if is needed.
Thanks!