standby database testing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: standby database testing

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    standby database testing

    Hi,

    I just created a test standby database per the oracle
    documentation on 2 separate Unix servers running
    oracle 8i. The setup went fine.

    I tested the failover option by failing over from
    the primary database to the standby and it went fine.

    The name of the primary database is PRDNDB
    which is on the server prdnser77

    The name of the standby database is STANDBY
    which is on server standserv66

    Using enterprise manager, I modified the local tns file
    on my NT worstation to include the following entry

    PRDNDB.DYNAMIC.CA.IDENT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = prdnser77)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PRDNDB)
    )
    )


    PRDNDB.DYNAMIC.CA.IDENT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = standserv66)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = standby)
    )
    )

    When the primary database was up, I connected to
    the database using OEM and it connected.

    When the primary database was down, I connected
    to the database using OEM and it connected.

    Does any one have any comments to offer on this setup
    and the testing that I did?

    Since this is my first time of setting up and testing
    a standby, I'm not sure if the client tns configuration
    is an acceptable way of doing it.
    And also if the testing that I did is sufficient and acceptable.

    cheers!!!
    Randy

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Not sure what the problem is? If you're able to perform switchovers/failovers, you've setup everything fine.

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: standby database testing

    Originally posted by randy
    Hi,

    I just created a test standby database per the oracle
    documentation on 2 separate Unix servers running
    oracle 8i. The setup went fine.

    I tested the failover option by failing over from
    the primary database to the standby and it went fine.

    The name of the primary database is PRDNDB
    which is on the server prdnser77

    The name of the standby database is STANDBY
    which is on server standserv66

    Using enterprise manager, I modified the local tns file
    on my NT worstation to include the following entry

    PRDNDB.DYNAMIC.CA.IDENT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = prdnser77)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = PRDNDB)
    )
    )


    PRDNDB.DYNAMIC.CA.IDENT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = standserv66)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = standby)
    )
    )

    When the primary database was up, I connected to
    the database using OEM and it connected.

    When the primary database was down, I connected
    to the database using OEM and it connected.

    Does any one have any comments to offer on this setup
    and the testing that I did?

    Since this is my first time of setting up and testing
    a standby, I'm not sure if the client tns configuration
    is an acceptable way of doing it.
    And also if the testing that I did is sufficient and acceptable.

    cheers!!!
    Randy
    Congrats on your success, have you tried a switchback operation? That's quite useful as well.
    I'm stmontgo and I approve of this message

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