3 Replies Latest reply: Jan 14, 2013 8:29 PM by Levi Pereira RSS

    How to configure two separate channels

      Hi all,

      I'm working with a two nodes RAC using Enterprise edition.

      I want to configure the archivelog backup:

      CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' CONNECT 'rman_intranet/oracleto@DBCIAT01' PARMS 'ENV=(TDPO_OPTFILE=/home/adsmadm/rman_DBCIAT01/opt/tdpo.opt)';
      CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT 'rman_intranet/oracleto@DBCIAT03' PARMS 'ENV=(TDPO_OPTFILE=/home/adsmadm/rman_DBCIAT03/opt/tdpo.opt)';
      RMAN> run {
      2> sql 'alter system switch logfile';
      3> sql 'alter system archive log current';
      4> sql 'alter system archive log current';
      5> backup format 'brman_arch_%s' archivelog all;
      6> }

      But fails with this error

      channel ORA_DISK_1: sid=27 devtype=DISK
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup command at 01/14/2013 12:49:55
      RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
      ORA-19625: error identifying file /logs/bbdd/oracle/DBCIAT03/archiver/T0001S0000004618.ARC
      ORA-27037: unable to obtain file status
      IBM AIX RISC System/6000 Error: 2: No such file or directory

      The error is because can't found the archivelog of second node on the first node.

      backup format 'brman_arch_%s'
      (archivelog like '/logs/bbdd/oracle/DBCIAT01/archiver/%' channel 1 delete all input )
      (archivelog like '/logs/bbdd/oracle/DBCIAT03/archiver/%' channel 2 delete all input )

      but fails too with this other error:

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00558: error encountered while parsing input commands
      RMAN-01005: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, identifier, single-quoted-string"
      RMAN-01007: at line 3 column 66 file: standard input

      Please, any idea?
      best regards
        • 1. Re: How to configure two separate channels

          Please follow the document for configuring the channels on RMAN.

          Especially, the document contains RAC configuration under "Configuring a Specific Channel for a Device Type"
          The keyword here is "Parallelism".

          Hope this helps you,

          • 2. Re: How to configure two separate channels
            THis is just an example..

            RMAN can allocate channels to instances it is connected to. For a RAC database, you can connect to the grid TNS alias, which points to all instances. You can then set up parallelism for the device type, and the load will be spread across the RAC instances.

            You need to make sure that the password file exists for each instance, and that the user you're connecting as from RMAN has sysdba privileges.

            tnsnames.ora entry:
            RACDATABASE =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (LOAD_BALANCE = yes)
            (FAILOVER = on)
            (ADDRESS = (PROTOCOL = TCP)(HOST = racnode1)(PORT = 1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = racnode2)(PORT = 1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = racnode3)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = ORCL)

            RMAN connect:
            rman target username/password@RACDATABASE
            (username/password is for a user with SYSDBA privileges).

            RMAN channel configuration:
            This sets up the channels to be spread across the instances based on instance load.
            • 3. Re: How to configure two separate channels
              Levi Pereira

              Try it:

               run {
              allocate channel t1 device type 'SBT_TAPE' connect 'sys/xxx@service_name'  
                PARMS  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' ;
              allocate channel t2 device type 'SBT_TAPE' connect 'sys/xxx@service_name'  
                PARMS  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' ;
              backup  format 'my_backup_%s'
               (archivelog like '/location1/%' channel t1)
               (archivelog like '/location2/%' channel t2);
              This should work.

              Levi Pereira