Archived Redologs Destination Doubt.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archived Redologs Destination Doubt.

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    Archived Redologs Destination Doubt.

    The objective is to have arch destination set in two different servers and to have redo archived logs in 2 different servers for security.

    ORACLE 8.1.7 - LINUX

    Arch destination 1 - It will store the archived redo logs in the same server.
    IP address for example - 200.124.123.112 /u01/home/oracle/arch

    Arch destination 2 - i want to set the destination address in a different server box having different IP.
    200.124.123.4 ex / usr/oracle/arch


    First question
    - is this possible ?
    - if yes - then see i will be specifying a destination path
    ex /usr/oracle/arch - how the unix server recognizes the path without specifying the IP address .
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    YES possible by using tnsnames.ora file and defining log_archive_dest_state_2 = enable
    log_archive_dest_2 = 'service=tnsnameEntry reopen=120'

    But you must have a Standby database setup for this configuration.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Set your log_archive_Dest_2 to an NFS mounted filesystem.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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