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

From: DA Morgan <>
Date: Mon, 21 Jul 2008 18:08:12 -0700
Message-ID: <>

steven_nospam at Yahoo! Canada wrote:
> 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 =
> (ADDRESS = (PROTOCOL= TCP)(Host=ServerA)(Port= 1521))
> (CONNECT_DATA = (SID = l01)(GLOBAL_NAME=priml01))
> )
> stbyl01 =
> (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 intra-
> server 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

Best practice for Data Guard as defined by the internal wiki of a very large and very well respected internet retailer is to use a separate private network.

That means a separate listener and separate tnsnames.ora entry. You can find some of the setup code from my Data Guard class here: based on their "best practice" guidelines.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Jul 21 2008 - 20:08:12 CDT

Original text of this message