-
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
-
Not sure what the problem is? If you're able to perform switchovers/failovers, you've setup everything fine.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|