rman connection load balancing in RAC

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Sun, 22 Apr 2007 06:34:23 -0400
Message-ID: <1c8f76b90704220334t147197b9p9e9fc5fa4ac4407c@mail.gmail.com>

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_at_rmanbkp

Recovery Manager: Release 10.1.0.3.0 - 64bit Production

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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 22 2007 - 05:34:23 CDT