2 Replies Latest reply: Dec 27, 2012 6:21 AM by Nadeem M RSS

    ORA-19506,ORA-27028,ORA-19511 - RMAN backup failue.

    SHANOJ
      Dear All,

      I am facing a backup failure error, till yesterday it was working fine. Please advice what to be done


      OS: AIX 6.1

      SQL> select * from v$version;
      BANNER
      ----------------------------------------------------------------
      Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
      PL/SQL Release 10.2.0.5.0 - Production
      CORE 10.2.0.5.0 Production
      TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
      NLSRTL Version 10.2.0.5.0 - Production

      Error:

      *====*
      released channel: t1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on t1 channel at 12/27/2012 16:22:29
      ORA-19506: failed to create sequential file, name="fodmt_arch_t803146946_s2396_p1", parms=""
      ORA-27028: skgfqcre: sbtbackup returned error
      ORA-19511: Error received from media manager layer, error text:
      ANS1355E (RC55) Session rejected: Server disabled



      Database status:
      *============*

      SQL> select name,open_mode from v$database;
      NAME OPEN_MODE
      --------- ----------
      FODMT READ WRITE


      SQL> select * from v$backup;

      FILE# STATUS CHANGE# TIME
      ---------- ------------------ ---------- ---------
      1 NOT ACTIVE 0
      2 NOT ACTIVE 0
      3 NOT ACTIVE 0
      4 NOT ACTIVE 0
      5 NOT ACTIVE 0
      6 NOT ACTIVE 0
      7 NOT ACTIVE 0



      RMAN Configuration:

      *=================*

      RMAN> show all;

      using target database control file instead of recovery catalog
      RMAN configuration parameters are:
      CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
      CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
      CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/fodmt_tdpo.opt)';
      CONFIGURE MAXSETSIZE TO UNLIMITED; # default
      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/uat_u01/app/oracle/product/10.2.0/dbs/snapcf_fodmt.f'; # default


      regards,

      Shanoj
        • 1. Re: ORA-19506,ORA-27028,ORA-19511 - RMAN backup failue.
          ShishirTekadeR
          ORA-19506: failed to create sequential file, name="string", parms="string"

          Cause: call to create the sequential file returned an error

          Action: check additional messages, check access permissions

          The error you get comes from media manager as it's written in Oracle Documentation: :==
          http://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmtroub.htm#1010097


          *****************************************
          Best Regards,
          Shishir Tekade.
          My Blog: http://shishirtekade.blogspot.com
          • 2. Re: ORA-19506,ORA-27028,ORA-19511 - RMAN backup failue.
            Nadeem M
            ORA-19511: Error received from media manager layer, error text:
            ANS1355E (RC55) Session rejected: Server disabled
            The above clearly show that there is some issue with your backup server (May be TSM). New sessions are being rejected by the server. You need to check with your ADMIN who is managing your backup servers.

            Edited by: Nadeem M on Dec 27, 2012 5:51 PM