4 Replies Latest reply: Jun 17, 2013 4:49 AM by 990685 RSS

    Restoring a database from SBT_TAPE, however all backups are expired (10g, Server 2k3, NetBackup 6.5.5)

    990685

      Hey Everyone,

       

      I am having some difficulties in restoring/recovering a database from a tape library.

       

      Basically I know for a fact that there are backups of the database on tape, however, when i did a crosscheck of backupsets,  all backups apart from the most current one, are expired.

       

      I tried numerous things, like:

      - Crosscheck backupsets

      - Crosscheck backup

      - Restoring database when in mount mode

      - Restoring from numerous times, up to a year ago.

      - Restoring from different scn's

       

      When i try to restore from RMAN, i get these errors:

      ------------------------------------------------------------------------------

      run{

      allocate channel t1 device type SBT_TAPE;

      set until scn 123456789;

      restore database;

      recover database;

      }

      ------------------------------------------------------------------------------

       

      RMAN-03002: failure of restore command at 06/17/2013 13:44:38

      RMAN-06026: some targets not found - aborting restore

      RMAN-06026: no backup or copy of datafile 4 found to restore

      RMAN-06026: no backup or copy of datafile 3 found to restore

      RMAN-06026: no backup or copy of datafile 2 found to restore

      RMAN-06026: no backup or copy of datafile 1 found to restore

       

      Would anyone know how to get my catalog to see the tape backups again?

       

      Knowns: Oracle 10g, Server2k3, Netbackup v6.5.5

        • 1. Re: Restoring a database from SBT_TAPE, however all backups are expired (10g, Server 2k3, NetBackup 6.5.5)
          Hemant K Chitale

          >I know for a fact that there are backups of the database on tape, however, when i did a crosscheck of backupsets,  all backups apart from the most current one, are expired.

          That should mean that they have been "purged" by Netbackup, not by Oracle.

          Possibly, the Netbackup catalog has been updated to remove information about these Oracle backups.

           

          Does LIST BACKUP show the backups that Oracle expects (but CROSSCHECK BACKUP marks them as EXPIRED) ?

           

          Hemant K Chitale

          • 2. Re: Restoring a database from SBT_TAPE, however all backups are expired (10g, Server 2k3, NetBackup 6.5.5)
            990685

            Hey Hemant,

             

            I want to restore a particular backup made. So i looked it up in RMAN.

             

            RMAN> list backupset 2;

             

            List of Backup Sets

            ===================

             

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time

            ------- ---- -- ---------- ----------- ------------ ---------------

            2      Incr 0      9.25G       SBT_TAPE    00:06:49     21-MAY-13

                    BP Key: 3   Status: EXPIRED Compressed: NO  Tag: TAG20031021T094513

                    Handle: bk_blah_blah_blah   Media: 7419L3

              List of Datafiles in backup set 2

              File LV Type Ckp SCN    Ckp Time  Name

              ---- -- ---- ---------- --------- ----

              1    0   INCR 175337     21/MAY/13 E:\oradata\PUBDB\SYSTEM01.DBF

              2    0   INCR 175337     21/MAY/13 E:\oradata\PUBDB\UNDOTBS01.DBF

              3    0   INCR 175337     21/MAY/13 E:\oradata\PUBDB\SYSAUX01.DBF

              4    0   INCR 175337     21/MAY/13 E:\oradata\PUBDB\USERS01.DBF

              5    0   INCR 175337     21/MAY/13 D:\oradata\PUBDB\pubdb_blah.DBF

              6    0   INCR 175337     21/MAY/13 D:\oradata\PUBDB\pubdb_blah.DBF

              7    0   INCR 175337     21/MAY/13 D:\oradata\PUBDB\pubdb_blah.DBF

              8    0   INCR 175337     21/MAY/13 D:\oradata\PUBDB\pubdb_blah.DBF

              9    0   INCR 175337     21/MAY/13 D:\oradata\PUBDB\pubdb_blah.DBF

             

            Then i did a crosscheck on it

             

            RMAN> crosscheck backupset 2

             

            crosschecked backup piece: found to be 'EXPIRED'

            backup piece handle bk_blah_blah_blah recid=0000 stamp=000000

            Crosschecked 1 objects.

             

            -----------------------------

            I can see that it was saved on media 7419L3. Might look into that.

             

            Does LIST BACKUP show the backups that Oracle expects (but CROSSCHECK BACKUP marks them as EXPIRED) ? I believe it did when i ran the crosscheck, as it took a while.

            • 3. Re: Restoring a database from SBT_TAPE, however all backups are expired (10g, Server 2k3, NetBackup 6.5.5)
              Hemant K Chitale

              I know this may sound silly....

              Confirm that you ARE connected to NetBackup (and using SBT_TAPE channel) when doing a CROSSCHECK BACKUP.

               

              A LIST BACKUP does not have to be connected to NetBackup and SBT_TAPE to list backups on tape.  But the CROSSCHECK BACKUP does need to be connected to NetBackup to actually find the backups.

               

               

              Hemant K Chitale


              • 4. Re: Restoring a database from SBT_TAPE, however all backups are expired (10g, Server 2k3, NetBackup 6.5.5)
                990685

                Hey Hemant,

                 

                Yes I have checked that SBT_TAPE is allocated.

                 

                By default, my crosscheck gets run as disk, so I have to manually set it to SBT_TAPE.

                 

                Already tried it