Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dual Archive Logs Location

840712Mar 3 2011 — edited Mar 9 2011
Hello, 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2011
Added on Mar 3 2011
10 comments
661 views