3 Replies Latest reply on Feb 15, 2008 1:43 PM by alanm

    Deallocate/Release channel failed (urgent)

    498240
      Hello forum users,

      I encountered a serious issue with RMAN.
      I use an RMAN script, allocate manually 5 channels for backup to an external server with Legato/LTO.

      In RMAN log backup finishes successfully but RMAN process do not release channels and for next backup RMAN returns errors because it considers that there is a running backup.

      Did someone encounterer this issue ? What can I do ?

      Regards,
      Guillaume
        • 1. Re: Deallocate/Release channel failed (urgent)
          alanm
          hi,
          do create a log file with your backupif you do can you post the result back so that we can see any error messages.

          Have you definately checked that all rman processes are finished after your backup.

          regards

          Alan
          • 2. Re: Deallocate/Release channel failed (urgent)
            498240
            Hi Alan,

            Application "EMC Networker" is used to launch rman script :

            NSR.log (EMC Networker)
            -------

            cmd_args = send "'NSR_ENV=(NSR_GROUP=Archive_MYINSTANCE,NSR_SERVER=server.localdomain,NSR_SAVESET_NAME=d:\nsr\rman_scripts\archive_all_myinstance.txt)'"
            rman_script = d:\nsr\rman_scripts\archive_all_myi.txt
            saveset_name = d:\nsr\rman_scripts\archive_all_bip.txt
            Launching backup process
            nwora_run_RMAN: Entering.
            nwora_run_RMAN: Writing out the RMAN script.
            nwora_run_RMAN: The argv[] is:
            D:\oracle\BIP\102\bin\rman.exe
            "msglog 'd:\nsr\applogs\msglog102_myinstance.log' "
            send "'NSR_ENV=(NSR_GROUP=Archive_myinstance,NSR_SERVER=server.localdomain,NSR_SAVESET_NAME=d:\nsr\rman_scripts\archive_all_myinstance.txt)'"
            cmdfile
            'd:\nsr\rman_scripts\archive_all_myinstance.txt'
            nwora_run_RMAN: The envp is:
            nwora_run_RMAN: Spawning the RMAN session.
            nwora_spawn_RMAN: Entering.
            nwora_spawn_RMAN: Creating the communication pipe.
            nwora_spawn_RMAN: Spawning the RMAN process.
            nwora_spawn_RMAN: Spawned the RMAN process 13132.

            ------------------------------------------------------------------------------------> no message EXIT ????


            RMAN log :
            ----------

            Recovery Manager: Release 10.2.0.2.0 - Production on Thu Feb 14 16:19:18 2008

            Copyright (c) 1982, 2005, Oracle. All rights reserved.

            RMAN> connect rcvcat *
            2> connect target *
            3> run{
            4> allocate channel c2 type 'SBT_TAPE'
            5> parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            6> sql "alter system archive log current";
            7> backup format 'ARC_%d_s%s_p%p_t%t' archivelog all delete input ;
            8> release channel c2;
            9> }
            10>
            connected to recovery catalog database

            connected to target database: myinstance (DBID=4288410793)

            allocated channel: c2
            channel c2: sid=106 devtype=SBT_TAPE
            channel c2: NMO v4.5.0.0
            sent command to channel: c2

            sql statement: alter system archive log current

            Starting backup at 14-FEB-08
            current log archived
            channel c2: starting archive log backupset
            channel c2: specifying archive log(s) in backup set
            input archive log thread=1 sequence=11876 recid=11772 stamp=646676364
            input archive log thread=1 sequence=11877 recid=11773 stamp=646676424
            channel c2: starting piece 1 at 14-FEB-08
            channel c2: finished piece 1 at 14-FEB-08
            piece handle=ARC_myinstance_s3432_p1_t646676474 tag=TAG20080214T162114 comment=API Version 2.0,MMS Version 4.5.0.0
            channel c2: backup set complete, elapsed time: 00:00:26
            channel c2: deleting archive log(s)
            archive log filename=R:\ORACLE\myinstance\ORAARCH\myinstanceARCHARC11876_0626437590.001 recid=11772 stamp=646676364
            archive log filename=R:\ORACLE\myinstance\ORAARCH\myinstanceARCHARC11877_0626437590.001 recid=11773 stamp=646676424
            Finished backup at 14-FEB-08

            ---------------------------------------------------------------------------------------------> no channel released

            Script RMAN (archive log all) :
            --------------------------------

            connect rcvcat xxxx/xxxx@xxxx;
            connect target sys/xxxx@yyyy;
            run{
            allocate channel c2 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            sql "alter system archive log current";
            backup format 'ARC_%d_s%s_p%p_t%t' archivelog all delete input ;
            release channel c2;
            }

            Script RMAN (full backup) :

            connect rcvcat xxxx/xxxx@xxxx;
            connect target sys/xxxx@yyyy;
            run{
            set command id to 'Stopme!';
            allocate channel c1 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            allocate channel c4 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            allocate channel c5 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            allocate channel c6 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            sql "alter system archive log current";
            backup filesperset 20 tag 'Backup SCP' format 'DB_%d_s%s_p%p_t%t' database;
            release channel c1;
            release channel c4;
            release channel c5;
            release channel c6;
            allocate channel c2 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            sql "alter system archive log current";
            backup filesperset 10 format 'ARC_%d_s%s_p%p_t%t' archivelog all ;
            release channel c2;
            allocate channel c3 type 'SBT_TAPE'
            parms 'ENV=(NSR_SERVER=SERVER.localdomain, NSR_DATA_VOLUME_POOL=VSL)';
            backup tag 'ControlFiles SCP' format 'CTL_%d_s%s_p%p_t%t' current controlfile;
            release channel c3;
            }
            • 3. Re: Deallocate/Release channel failed (urgent)
              alanm
              hi,
              you need to look at creating a msglog file of you backup so that you can see what rman is doing

              similar to this
              :>rman target sys/password@tsh1 rcvcat rman/rman@dba1 msglog 'C:OracleBackupTSH1TSH1_Daily_Backup.log'
              if you get this running then see if it is RMAN or EMC causing the issue.

              regards

              Alan