diff. log_archive_dest for each RAC instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: diff. log_archive_dest for each RAC instance

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    diff. log_archive_dest for each RAC instance

    I'm pretty sure this can be done, just would like to confirm if someone is already doing this:

    This is what we have now:

    *.log_archive_dest_1='location=/u170/oradata/arch mandatory reopen=5'

    If I want each of the 4 instances to write to their own arch dest; I would do this:

    db1.log_archive_dest_1='location=/u170/oradata/db1/arch mandatory reopen=5'
    db2.log_archive_dest_1='location=/u170/oradata/db2/arch mandatory reopen=5'
    db3.log_archive_dest_1='location=/u170/oradata/db3/arch mandatory reopen=5'
    db4.log_archive_dest_1='location=/u170/oradata/db4/arch mandatory reopen=5'

    Is this the correct way of doing this ?

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Yeah you can do that

    Why not put them all in the same dir if you can manage. The archive format will show you the thread so you'll know where each log came from and RMAN only has to backup the one dir which is sort of kitchy.

    Also, if you writing to a SAN or shared file system try and duplex
    the logs to write their and the local file system as well if possible. Elimates the shared storage device as a single point of failure.

    good luck

    steve
    Last edited by stmontgo; 02-06-2004 at 01:37 PM.
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Thanks Steve,

    Actually we already have a 4 node RAC cluster implemented for over a year now. We are writing the archive logs to 1 device. But what we have noticed recently is that each of the nodes may do a log switch at the same time, and they may all write 500M to the archive file (that is on 1 device) at the same time.

    So, if we can have a dedicated device for each instance, then that should make the archieving faster; without waiting for the device to free up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width