rman connection load balancing in RAC

  • From: "dd yakkali" <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 22 Apr 2007 06:34:23 -0400

i am new to RAC world. We are just setting it up in a test environment.

One of the things we are testing is backing up rac database with rman.

How can we have connection load balancing/fail over of rman connections to
rac database.

we tried to mention load_balance=yes in tnsnames.ora with a service name
rmanbkp.

we keep getting this error.

RAC is in 10gR2 running the rman is running from a 10gR1 oracle.

ORACLE-DD(ldwdev):/u01/app/oracle/product/10.1.0/network/admin>rman target
XXXXX/xxxx@rmanbkp

Recovery Manager: Release 10.1.0.3.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03010: fatal error during library cache pre-loading
RMAN-10038: database session for channel default terminated unexpectedly


Created a tar with metalink. Here is what oracle says
------------------------------------------------------------------------------------------------------------------------------
The issue matches Bug 1289870 RMAN-601 RMAN-3010 RMAN-10038 WHEN TRYING
CONNECTIONS USING OPS

Ensure that the used tnsnames-entries by RMAN do not include the
LOAD BALANCE and FAILOVER settings.
The connections need to be DEDICATED aswell, so cannot use MTS / Shared
Servers



Add separate TNS aliases for the target database to the tnsnames.ora file,
which doesn't include TAF and Load Balancing. The aliases should also
connect to a specific instance and use DEDICATED connect

-----------------------------------------------------------------------------------------------------------------------------------

My question is if we create separate tns aliases for both instances, what
alias should I use for rman backup and what happens when that instance is
not available. In automated scripted backups how do we keep changing the tns
entries when an instance is not available.

Can any one give me a rman script and the tns entries used for backup and
recovery of a rac database using rman?

Thanks in advance.
Deen

Other related posts: