Re: rman connection load balancing in RAC

Hi ,

I may not be able to answer all of your questions. But, in our environment we follow the below script for Database backup to tape.

run {

        set command id to 'ORACLE_FULL_BACKUP_ID';
        allocate channel t1 device type sbt connect
'rman_admin/xxx_at_rac1' debug=6 trace 5;
        allocate channel t2 device type sbt connect
'rman_admin/xxx_at_rac2' debug=6 trace 5;
        ....
        ....//backup process
        ....
        release channel t1;
        release channel t2;
         }

The above script does answer the question of load balancing (may be manually... ;-) ) but, session failover or "requirement to change the script in case of instance un-availability" are not answered.

Here rac1 & ra2 are tns aliases for each instance individually. No load balance, No Failover.... A plain tns entry..

i would like to know the opinion of others,in this regard..

Thanks,
Ravi.

On 4/22/07, dd yakkali <dd.yakkali_at_gmail.com> wrote:
>
>
> 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
>
> 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

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