1 2 Previous Next 23 Replies Latest reply on Apr 17, 2013 11:59 AM by 1003628

    Backup Error: ORA-19511: Error received from media manager layer

    user8837052
      Hi,

      it is happening that after having changed our backup scheduled time ..the backup full of our database on the tape is failing..

      On the other hand the backup of the archivelogs on the tape is successful!!

      The error returned is:

      RMAN-03009: failure of backup command on t2 channel at 10/29/2012 10:08:44
      ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
      ORA-19511: Error received from media manager layer, error text:
      RPC receive operation failed.  A network connection could not be established with the host.

      The database is Oracle 10.2.0.3 Standard Edition on Microsoft Windows Server 2003 R2.

      The backup software is Legato.


      The script used for the failed backup is the following:

      connect target sys/****@jhoray01;
      run{
      set command id to 'RMAN';
      ### allocate channel
      allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
      allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
      allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
      allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
      ### backup db
      backup incremental level 0 TAG BCK_DATABASE_FULL_DD format '%d_L0_%s_%p' (database) ;
      ### backup controlfile
      backup TAG BCK_CONTROLFILE format '%d_controlfile_%s_%p' (current controlfile);
      ### copia file del controlfile per sicurezza
      sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';

      ### rilascio dei canali precedentemente allocati
      release channel t1;
      release channel t2;
      release channel t3;
      release channel t4;
      }


      The script used for the successful backup (archive logs) is:

      connect target sys/******@jhoray01;
      run{
      set command id to 'RMAN';
      ###
      allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bck-host-ev,NSR_CLIENT=NHPAYROLLDB01,NSR_DATA_VOLUME_POOL=Pool15g)';
      allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bck-host-ev,NSR_CLIENT=NHPAYROLLDB01,NSR_DATA_VOLUME_POOL=Pool15g)';
      backup archivelog all not backed up 2 times;
      delete noprompt archivelog all backed up 2 times to device type 'SBT_TAPE';

      }



      Any help would be very appreciated!! Thanks in advance


      Susy

      Edited by: user8837052 on 29-ott-2012 2.33
        1 2 Previous Next