This discussion is archived
6 Replies Latest reply: Feb 12, 2013 5:56 AM by 525819 RSS

Importvol of old tapes: no backup pieces?

525819 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Yeah looks like it
  • 6. Re: Importvol of old tapes: no backup pieces?
    525819 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points