6 Replies Latest reply: Feb 12, 2013 7:56 AM by 525819 RSS

    Importvol of old tapes: no backup pieces?

    525819
      Hello,

      Another day I replaced some full tapes by new ones. Today I decided to read some data from these old tapes, thus imported them back using:
      ob> importvol -L taperobot -D tape1 -m --obtaropt -G iee1-2

      After the import I cannot see any backup pieces on these volumes, although volume names and list of backup sections are correct.

      ob> lssection -v GENERIC-000033
      BSOID Volume File Sect Level Client Size Created Attributes
      6634 GENERIC-000033 93 2 0 oraserv 2011/03/05 content manages reuse
      6635 GENERIC-000033 94 1 0 oraserv 2011/03/05 content manages reuse
      6636 GENERIC-000033 95 1 0 oraserv 2011/03/05 content manages reuse
      6637 GENERIC-000033 96 1 0 oraserv 2011/03/05 content manages reuse
      6638 GENERIC-000033 97 1 0 oraserv 2011/03/05 content manages reuse
      6639 GENERIC-000033 98 1 0 oraserv 2011/03/05 content manages reuse
      6640 GENERIC-000033 99 1 0 oraserv 2011/03/05 content manages reuse
      6641 GENERIC-000033 100 1 0 oraserv 2011/03/05 content manages reuse
      6642 GENERIC-000033 101 1 0 oraserv 2011/03/05 content manages reuse
      6643 GENERIC-000033 102 1 0 oraserv 2011/03/05 content manages reuse
      6644 GENERIC-000033 103 1 0 oraserv 2011/03/05 content manages reuse
      ob> lspiece -v GENERIC-000033
      Error: no backup pieces for the specified volume(s)

      -----
      Can I make available these backup pieces?
      If not, does that mean these old volumes are useless for RMAN restore?

      Thanks a lot for your answers.
        • 1. Re: Importvol of old tapes: no backup pieces?
          brunors
          Hello,

          check the contents about the V$BACKUP_PIECE e and check this article <http://oracleprof.blogspot.com.br/2010/02/rman-and-sbttape-backup-pieces-how-to.html>

          Kind regards, Bruno Reis.
          • 2. Re: Importvol of old tapes: no backup pieces?
            525819
            Hello Bruno,

            THanks for your advice. Unfortunately, V$BACKUP_PIECE has no data on these old backup pieces (our backup policy is to keep the last backup set only)

            The article you suggested assumes knowledge of backup piece names:
            Only thing I knew was a backup piece name. This is a prerequisite but it can be found quite easily...
            Unfortunately, this is exactly what DO NOT know, and why I asked the question.

            Any more ideas, please?
            • 3. Re: Importvol of old tapes: no backup pieces?
              rdoogan-Oracle
              I think the problem is that "--import" translates to obtaropt zz which prevents the use of the -t option.

              So you could try doing identifyvol -D tape1 -o -tG

              Thanks

              Rich
              • 4. Re: Importvol of old tapes: no backup pieces?
                525819
                Hello Rich,

                Thanks for your input. I tried as suggested:

                ob> identifyvol -D tape1 -o -tG 48-52,54-58
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image
                Error: index creation must start with first section of backup image

                Does that mean that none of the 10 tapes contain the first section of a backup image?

                Thanks,
                Dmitry.
                • 5. Re: Importvol of old tapes: no backup pieces?
                  rdoogan-Oracle
                  Yeah looks like it
                  • 6. Re: Importvol of old tapes: no backup pieces?
                    525819
                    Hi Rich,

                    Apparently, obtar (who actually does identification) needs exact specification of a file xxx to read (providing the correct tape is already in the drive):
                    *$ obtar -f tape1 -tG -F xxx*

                    The best thing IMO is to make a one-line bash script sweeping over the needed files:
                    *$ for i in {94..103}; do obtar -f tape1 -tG -F $i; done;*

                    Please, note, the file #93 (from my initial example) should not be in the range, because there is only its second half on this tape


                    In terms of identofyvol the command would be like:
                    ob> identifyvol -D tape1 -o '-tG -F 94' 54

                    where 94 is the file, 54 is the slot with the tape (note the obtar argument isolation by quotes!) . But it is not practical, because identofyvol loads/unloads the tape before/after each run, while obtar just reads files (and it can load the next tape if the next file is there).

                    HTH the next poor soul...
                    Dmitry.