10 Replies Latest reply: Oct 25, 2012 2:58 PM by user569151 RSS

    cannot find autobackup controlfiles even though we had sunday full backup

    user569151
      I got this when try to restore controlfile:
      RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
      allocated channel: t1
      channel t1: SID=1034 device type=SBT_TAPE
      channel t1: NMO v5.0.0.0

      sent command to channel: t1

      executing command: SET CONTROLFILE AUTOBACKUP FORMAT

      Starting restore at 25-OCT-12

      channel t1: looking for AUTOBACKUP on day: 20121025
      channel t1: looking for AUTOBACKUP on day: 20121024
      channel t1: looking for AUTOBACKUP on day: 20121023
      channel t1: looking for AUTOBACKUP on day: 20121022
      channel t1: looking for AUTOBACKUP on day: 20121021
      channel t1: looking for AUTOBACKUP on day: 20121020
      channel t1: looking for AUTOBACKUP on day: 20121019
      channel t1: no AUTOBACKUP in 7 days found
      released channel: t1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 10/25/2012 18:58:23
      RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


      how to list to see if we have controlfile autobackup? in sunday full backup, there is a full backup.

      here is the script of sunday full backup:
      connect target / ;
      configure backup optimization off;

      run {
      configure controlfile autobackup on;
      configure controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';

      BACKUP INCREMENTAL LEVEL 0 DATABASE plus archivelog delete all input TAG 'prod';

      release channel ch00;
      release channel ch01;
      release channel ch02;
      release channel ch03;
        • 1. Re: cannot find autobackup controlfiles even though we had sunday full backup
          mseberg
          Hello;

          From RMAN can you post the results of this ?

          RMAN> Show ALL;

          This may also help :

          Configuring the Control File Autobackup Format

          http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV8101

          I think I see the issue
          run {
          configure controlfile autobackup on;
          configure controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';
          The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt
          SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE....
          Best Regards

          mseberg

          Edited by: mseberg on Oct 25, 2012 3:00 PM
          • 2. Re: cannot find autobackup controlfiles even though we had sunday full backup
            user569151
            RMAN> show all;

            RMAN configuration parameters for database with db_unique_name PRDL are:
            CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
            CONFIGURE BACKUP OPTIMIZATION ON;
            CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
            CONFIGURE CONTROLFILE AUTOBACKUP ON;
            CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '/NMO_v_%F';
            CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
            CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
            CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
            CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
            CONFIGURE MAXSETSIZE TO UNLIMITED; # default
            CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
            CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
            CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
            CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
            CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DAT/PRD/snapcf_PRD.f';
            CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DAT/prd/snapcf_prd.f';
            • 3. Re: cannot find autobackup controlfiles even though we had sunday full backup
              mseberg
              Hello;

              I think you need to use the SET command with an RMAN script.
              RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE sbt TO 'controlfile_%F';
              or
              RUN { 
                     SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/%F.bck'; 
              set overrides the configured autobackup format in the current session.

              Best Regards

              mseberg
              • 4. Re: cannot find autobackup controlfiles even though we had sunday full backup
                user569151
                but the script did not error out. how do I list autobackups?
                • 5. Re: cannot find autobackup controlfiles even though we had sunday full backup
                  mseberg
                  The no error comment is a good argument

                  But you have :

                  configure controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';

                  And the autobackup specifier only allows %F, no other modifiers.

                  I would think just LIST BACKUP

                  Will test.

                  h2. Test

                  Yes, List backup worked for me :
                  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                  ------- ---- -- ---------- ----------- ------------ ---------------
                  3948113 Full    1.13M      DISK        00:00:01     22-OCT-12      
                          BP Key: 3948128   Status: AVAILABLE  Compressed: YES  Tag: TAG20121022T200104
                          Piece Name: /u01/app/oracle/flash_recovery_area/GEMINI/backupset/2012_10_22/o1_mf_ncnnf_TAG20121022T200104_88cv65nn_.bkp
                    Control File Included: Ckp SCN: 1301528913407   Ckp time: 22-OCT-12
                  Best Regards

                  mseberg

                  Edited by: mseberg on Oct 25, 2012 3:50 PM
                  • 6. Re: cannot find autobackup controlfiles even though we had sunday full backup
                    user569151
                    RMAN> list backup of controlfile;

                    using target database control file instead of recovery catalog

                    List of Backup Sets
                    ===================


                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    20 Full 33.50M SBT_TAPE 00:00:03 16-OCT-12
                    BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20121016T153649
                    Handle: /NMO_v_c-258815187-20121016-00 Media: AB0084
                    Standby Control File Included: Ckp SCN: 90684055703 Ckp time: 16-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    48 Full 33.50M SBT_TAPE 00:00:03 18-OCT-12
                    BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20121018T150454
                    Handle: /NMO_v_c-258815187-20121018-00 Media: AB0021
                    Standby Control File Included: Ckp SCN: 90712912191 Ckp time: 18-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    57 Full 33.50M SBT_TAPE 00:00:03 18-OCT-12
                    BP Key: 57 Status: AVAILABLE Compressed: NO Tag: TAG20121018T184351
                    Handle: /NMO_v_c-258815187-20121018-01 Media: 000035L3
                    Standby Control File Included: Ckp SCN: 90720881766 Ckp time: 18-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    66 Full 33.50M SBT_TAPE 00:00:03 18-OCT-12
                    BP Key: 66 Status: AVAILABLE Compressed: NO Tag: TAG20121018T205107
                    Handle: /NMO_v_c-258815187-20121018-02 Media: 000065L3
                    Standby Control File Included: Ckp SCN: 90722052622 Ckp time: 18-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    77 Full 33.50M SBT_TAPE 00:00:01 19-OCT-12
                    BP Key: 77 Status: AVAILABLE Compressed: NO Tag: TAG20121019T060814
                    Handle: /NMO_v_c-258815187-20121019-00 Media: AB0429
                    Standby Control File Included: Ckp SCN: 90727828319 Ckp time: 19-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    79 Full 33.50M SBT_TAPE 00:00:03 19-OCT-12
                    BP Key: 79 Status: AVAILABLE Compressed: NO Tag: TAG20121019T074905
                    Handle: /NMO_v_c-258815187-20121019-01 Media: AB0031
                    Standby Control File Included: Ckp SCN: 90728613697 Ckp time: 19-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    88 Full 33.50M SBT_TAPE 00:00:05 19-OCT-12
                    BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20121019T093251
                    Handle: /NMO_v_c-258815187-20121019-02 Media: AB0046
                    Standby Control File Included: Ckp SCN: 90733759045 Ckp time: 19-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    99 Full 33.50M SBT_TAPE 00:00:04 20-OCT-12
                    BP Key: 99 Status: AVAILABLE Compressed: NO Tag: TAG20121020T060902
                    Handle: /NMO_v_c-258815187-20121020-00 Media: AB0395
                    Standby Control File Included: Ckp SCN: 90744728646 Ckp time: 20-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    107 Full 33.50M SBT_TAPE 00:00:03 20-OCT-12
                    BP Key: 107 Status: AVAILABLE Compressed: NO Tag: TAG20121020T093338
                    Handle: /NMO_v_c-258815187-20121020-01 Media: AB0421
                    Standby Control File Included: Ckp SCN: 90747005012 Ckp time: 20-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    118 Full 33.50M SBT_TAPE 00:00:03 21-OCT-12
                    BP Key: 118 Status: AVAILABLE Compressed: NO Tag: TAG20121021T060849
                    Handle: /NMO_v_c-258815187-20121021-00 Media: AB0025
                    Standby Control File Included: Ckp SCN: 90758029474 Ckp time: 21-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    126 Full 33.50M SBT_TAPE 00:00:03 21-OCT-12
                    BP Key: 126 Status: AVAILABLE Compressed: NO Tag: TAG20121021T093317
                    Handle: /NMO_v_c-258815187-20121021-01 Media: AB0160
                    Standby Control File Included: Ckp SCN: 90760571940 Ckp time: 21-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    137 Full 33.50M SBT_TAPE 00:00:05 22-OCT-12
                    BP Key: 137 Status: AVAILABLE Compressed: NO Tag: TAG20121022T060823
                    Handle: /NMO_v_c-258815187-20121022-00 Media: AB0094
                    Standby Control File Included: Ckp SCN: 90768623935 Ckp time: 22-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    146 Full 33.50M SBT_TAPE 00:00:03 22-OCT-12
                    BP Key: 146 Status: AVAILABLE Compressed: NO Tag: TAG20121022T093322
                    Handle: /NMO_v_c-258815187-20121022-01 Media: AB0076
                    Standby Control File Included: Ckp SCN: 90770937800 Ckp time: 22-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    157 Full 33.50M SBT_TAPE 00:00:04 23-OCT-12
                    BP Key: 157 Status: AVAILABLE Compressed: NO Tag: TAG20121023T060850
                    Handle: /NMO_v_c-258815187-20121023-00 Media: AB0077
                    Standby Control File Included: Ckp SCN: 90789432656 Ckp time: 23-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    166 Full 33.50M SBT_TAPE 00:00:05 23-OCT-12
                    BP Key: 166 Status: AVAILABLE Compressed: NO Tag: TAG20121023T093342
                    Handle: /NMO_v_c-258815187-20121023-01 Media: AB0077
                    Standby Control File Included: Ckp SCN: 90791401285 Ckp time: 23-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    179 Full 33.50M SBT_TAPE 00:00:03 24-OCT-12
                    BP Key: 179 Status: AVAILABLE Compressed: NO Tag: TAG20121024T060845
                    Handle: /NMO_v_c-258815187-20121024-00 Media: AB0086
                    Standby Control File Included: Ckp SCN: 90805793388 Ckp time: 24-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    188 Full 34.00M SBT_TAPE 00:00:04 24-OCT-12
                    BP Key: 188 Status: AVAILABLE Compressed: NO Tag: TAG20121024T093327
                    Handle: /NMO_v_c-258815187-20121024-01 Media: AB0078
                    Standby Control File Included: Ckp SCN: 90813015199 Ckp time: 24-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    200 Full 34.00M SBT_TAPE 00:00:02 25-OCT-12
                    BP Key: 200 Status: AVAILABLE Compressed: NO Tag: TAG20121025T060922
                    Handle: /NMO_v_c-258815187-20121025-00 Media: AB0103
                    Standby Control File Included: Ckp SCN: 90835280311 Ckp time: 25-OCT-12

                    BS Key Type LV Size Device Type Elapsed Time Completion Time
                    ------- ---- -- ---------- ----------- ------------ ---------------
                    209 Full 34.00M SBT_TAPE 00:00:03 25-OCT-12
                    BP Key: 209 Status: AVAILABLE Compressed: NO Tag: TAG20121025T093358
                    Handle: /NMO_v_c-258815187-20121025-01 Media: AB0103
                    Standby Control File Included: Ckp SCN: 90837633024 Ckp time: 25-OCT-12

                    RMAN>
                    • 7. Re: cannot find autobackup controlfiles even though we had sunday full backup
                      user569151
                      also from 11gr2 document,
                      The control file autobackup file name has a default format of %F for all device types, so that RMAN can determine the file location and restore it without a repository. You can specify a different format with the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command, but all autobackup formats must include the %F variable. If you do not use the default format, then during disaster recovery you must specify the format that was used to generate the autobackups. Otherwise, RMAN cannot restore the autobackup.

                      and out fullbackup script did have %F:
                      configure controlfile autobackup format for device type 'sbt_tape' to '/NMO_v_%F';


                      except set is missing here, I think the format is right?
                      • 8. Re: cannot find autobackup controlfiles even though we had sunday full backup
                        mseberg
                        Hello again;

                        Looks like you found them! Great! So they must mean just the %F part. Always good to learn something new.

                        /NMO_v_c-258815187-20121025-00

                        Not having autobackup working is a nightmare. I know I bank on it.

                        Thanks for letting me know before my day ended.

                        Have a great night.

                        mseberg
                        • 9. Re: cannot find autobackup controlfiles even though we had sunday full backup
                          user569151
                          Thanks. I found this also in document:

                          Overriding the Configured Control File Autobackup Format

                          The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN command or at the RMAN prompt, overrides the configured autobackup format in the current session only. The order of precedence is:

                          SET CONTROLFILE AUTOBACKUP FORMAT (within a RUN block)

                          SET CONTROLFILE AUTOBACKUP FORMAT (at RMAN prompt)

                          CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
                          • 10. Re: cannot find autobackup controlfiles even though we had sunday full backup
                            user569151
                            then document shows some example:

                            The following example shows how the two forms of SET CONTROLFILE AUTOBACKUP FORMAT interact:

                            SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'controlfile_%F';
                            BACKUP AS COPY DATABASE;
                            RUN
                            {
                            SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/%F.bck';
                            BACKUP AS BACKUPSET
                            DEVICE TYPE DISK
                            DATABASE;
                            }