2 Replies Latest reply: Nov 11, 2012 9:42 PM by Hemant K Chitale RSS

    Rman backup with Netbackup failed on controlfile

    973704
      Hi All,

      I have a case of Netbackup having problem backing up oracle database on Solaris 10 client.
      Majority of the child jobs passed, the problems seems to be on 1 or 2 of child job doing the auto control file portion.

      From the RMAN output logs, we are also seeing some errors as below
      The DB itself seem to have completed backup, but is having error on backing up the controlfile portion

      Pls let me know if you have any insight into what is happening


      ========================
      RMAN OUTPUT
      ========================
      Script /softwares/nbu/rman_bkup/hot_database_backup.sh
      ==== started on Fri Nov 2 12:36:56 SGT 2012 ====
      ....
      .....
      ....
      ....
      .....
      ....
      channel ch01: starting piece 1 at 02-NOV-12
      channel ch00: finished piece 1 at 02-NOV-12
      piece handle=bk_4332_1_798295019 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch00: backup set complete, elapsed time: 00:03:49
      channel ch01: finished piece 1 at 02-NOV-12
      piece handle=bk_4334_1_798295245 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch01: backup set complete, elapsed time: 00:01:35
      Finished backup at 02-NOV-12

      Starting Control File and SPFILE Autobackup at 02-NOV-12
      piece handle=c-3995589581-20121102-09 comment=API Version 2.0,MMS Version 5.0.0.0
      Finished Control File and SPFILE Autobackup at 02-NOV-12

      sql statement: alter system archive log current

      released channel: ch00

      released channel: ch01

      allocated channel: ch00
      channel ch00: SID=23 device type=SBT_TAPE
      channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010070723)

      allocated channel: ch01
      channel ch01: SID=767 device type=SBT_TAPE
      channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010070723)

      Starting backup at 02-NOV-12
      current log archived
      channel ch00: starting archived log backup set
      channel ch00: specifying archived log(s) in backup set
      input archived log thread=1 sequence=2029 RECID=1867 STAMP=798295408
      channel ch00: starting piece 1 at 02-NOV-12
      channel ch01: starting archived log backup set
      channel ch01: specifying archived log(s) in backup set
      input archived log thread=1 sequence=2030 RECID=1868 STAMP=798295408
      channel ch01: starting piece 1 at 02-NOV-12
      channel ch00: finished piece 1 at 02-NOV-12
      piece handle=al_4336_1_798295409 tag=TAG20121102T124329 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch00: backup set complete, elapsed time: 00:01:05
      channel ch00: deleting archived log(s)
      archived log file name=/orasw/app/oracle/fast_recovery_area/IAMSUAT/archivelog/2012_11_02/o1_mf_1_2029_896mvj03_.arc RECID=1867 STAMP=798295408
      channel ch01: finished piece 1 at 02-NOV-12
      piece handle=al_4337_1_798295409 tag=TAG20121102T124329 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch01: backup set complete, elapsed time: 00:01:05
      channel ch01: deleting archived log(s)
      archived log file name=/orasw/app/oracle/fast_recovery_area/IAMSUAT/archivelog/2012_11_02/o1_mf_1_2030_896mvjwh_.arc RECID=1868 STAMP=798295408
      Finished backup at 02-NOV-12

      Starting Control File and SPFILE Autobackup at 02-NOV-12
      piece handle=c-3995589581-20121102-0a comment=API Version 2.0,MMS Version 5.0.0.0
      Finished Control File and SPFILE Autobackup at 02-NOV-12

      released channel: ch00

      released channel: ch01

      allocated channel: ch00
      channel ch00: SID=23 device type=SBT_TAPE
      channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010070723)

      Starting backup at 02-NOV-12
      channel ch00: starting full datafile backup set
      channel ch00: specifying datafile(s) in backup set
      including current control file in backup set
      channel ch00: starting piece 1 at 02-NOV-12
      channel ch00: finished piece 1 at 02-NOV-12
      piece handle=cntrl_4339_1_798295541 tag=TAG20121102T124541 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch00: backup set complete, elapsed time: 00:00:55
      Finished backup at 02-NOV-12

      Starting Control File and SPFILE Autobackup at 02-NOV-12
      released channel: ch00
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channel at 11/02/2012 12:54:03
      ORA-19509: failed to delete sequential file, handle="c-3995589581-20121102-0c", parms=""
      ORA-27027: sbtremove2 returned error
      ORA-19511: Error received from media manager layer, error text:
      Failed to remove, c-3995589581-20121102-0c, from image catalog.
      ORA-19513: failed to identify sequential file
      ORA-27206: requested file not found in media management catalog

      RMAN>

      Recovery Manager complete.

      Script /softwares/nbu/rman_bkup/hot_database_backup.sh
      ==== ended in error on Fri Nov 2 12:54:04 SGT 2012 ====
        • 1. Re: Rman backup with Netbackup failed on controlfile
          mseberg
          Hello;

          It looks like you don't have "CONTROLFILE AUTOBACKUP FORMAT" setup in RMAN
          configure controlfile autobackup format for device type disk to '/yourlocation';
          Best Regards

          mseberg
          • 2. Re: Rman backup with Netbackup failed on controlfile
            Hemant K Chitale
            The controlfile backup attempt appears twice in the output. The first pass is successful
             Starting Control File and SPFILE Autobackup at 02-NOV-12
            piece handle=c-3995589581-20121102-0a comment=API Version 2.0,MMS Version 5.0.0.0
            Finished Control File and SPFILE Autobackup at 02-NOV-12
            
            released channel: ch00
            
            released channel: ch01
            
            allocated channel: ch00
            channel ch00: SID=23 device type=SBT_TAPE
            channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010070723)
            
            Starting backup at 02-NOV-12
            channel ch00: starting full datafile backup set
            channel ch00: specifying datafile(s) in backup set
            including current control file in backup set
            channel ch00: starting piece 1 at 02-NOV-12
            channel ch00: finished piece 1 at 02-NOV-12
            piece handle=cntrl_4339_1_798295541 tag=TAG20121102T124541 comment=API Version 2.0,MMS Version 5.0.0.0
            channel ch00: backup set complete, elapsed time: 00:00:55
            Finished backup at 02-NOV-12
            it is the second pass that is failing. The sequential file is the default autobackup format name. Can we see
            (a) your RMAN script
            (b) the output of SHOW ALL from the RMAN command line ?


            Hemant K Chitale