Setup Multiple Log Archive Destinations for your Oracle Database

Applies to Oracle 10g and above

I would assume your database is already in the ARCHIVELOG mode

SQL> show parameter LOG_ARCHIVE_DEST

This would show all your Archive Log Destinations without any value unless previously set. It would be wise to set multiple Archive Log Destinations on alternate physical disks. It would prevent the database to stop functioning if the first destination disk is full.


The LOCATION keyword is used to define that the destination is local; for remote destinations use the keyword SERVICE

SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=yournetworkservicename'

Posted on January 10, 2014, in Oracle, Oracle 11g - Windows and tagged , . Bookmark the permalink. 2 Comments.

  1. I’m pretty pleased to discover this great site. I wanted to thank you for your time for this
    fantastic read!! I definitely really liked every little bit
    of it and i also have you saved as a favorite to check out new things on your website.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: