Re: Using a dedicated NIC card for standby database (archive log transfers)
Date: Mon, 21 Jul 2008 18:08:12 -0700
steven_nospam at Yahoo! Canada wrote:
> Hi all,
> Bear with me, DBAs. I am an AIX specialist with only basic Oracle 9i
> 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
> 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.
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.orgReceived on Mon Jul 21 2008 - 20:08:12 CDT