Using a dedicated NIC card for standby database (archive log transfers)

Hi all,

Bear with me, DBAs. I am an AIX specialist with only basic Oracle 9i exposure.

I have two AIX servers:

ServerA has a primary database PRIML01
ServerB has a standby database STBYL01 which is a copy of PRIML01

Currently, my TNSNAMES stanzas for these databases look like the following:

priml01 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host=ServerA)(Port= 1521))
(CONNECT_DATA = (SID = l01)(GLOBAL_NAME=priml01))
  )
stbyl01 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host=ServerB)(Port= 1521))
(CONNECT_DATA = (SID = l01)(GLOBAL_NAME=stbyl01))
  )

We have a lot of traffic on the network card reached by the name "ServerA" and "ServerB" as it is used by users logging on to the OLTP system. What we would like to do is use a secondary NIC card for intraserver  traffic only. So we would have:

ServerA1 <------> ServerB1

ServerA2 <------> ServerB2

The cards A1 and B1 would be on the regular network reachable by all users, ODBC connections, etc.

The cards A2 and B2 would be connnected back-to-back using a crossover cable and only be used by Oracle to transfer its archive logs to the standby database, and perhaps limited other traffic.

So my question is this: Do I only need to make a change to the entry in my TNSNAMES file so the different "host" name is used, which matches my secondary NIC card names?

Thx in advance.

SteveN Received on Fri Jul 18 2008 - 16:13:28 CDT