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

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 =
> (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 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: www.psoug.org/reference/data_guard.html based on their "best practice" guidelines.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org