DB2 Tape Backup & Restore Problem 
Author Message
 DB2 Tape Backup & Restore Problem

When you make a second backup to /dev/rmt0, the first will have been
overwritten.  On AIX, the /dev/rmt0 device automatically rewinds the
tape after the device is closed.  The second backup operation will then
write an image starting at the beginning of the tape.  There are other
special files associated with the rmt0 device, such as /dev/rmt0.1,
where the rewind-on-close feature is turned off.

I would not recommend putting more than one backup on a tape, because it
becomes very difficult to keep track of and to manage your backups.  It
can be done if you're very careful, but as you've seen you run the risk
of losing an important backup image.  Also, if you want to restore an
image from the middle of a tape, you will have to handle the tape
positioning yourself before attempting the restore.

Hope that helps.


> I'm having a problem when restoring a backup file from tape backup device. The
> tape device installed in my AIX machine is a 4.0 GB 4mm Tape Drive.

> Here are the scenarios :

> Two Sample database    : DAT01
>                          DAT02

> 1) Backup DAT01 to tape device (/dev/rmt0)
>    -  Status : Backup Success.
> 2) Restore DAT01 from tape device (/dev/rmt0)
>    -  Status : Restore Success.
> 3) Now, backup DAT02 to tape device (/dev/rmt0)
>    -  Status : Backup Success.
> 4) Restore DAT02 from tape device (/dev/rmt0)
>    -  Status : Restore Success.
> 5) Ok.. now restore DAT01 from tape device (/dev/rmt0)
>    -  Status : I/O Error!
>         DB2 Message :   Warning! I/O error "-2069" accessing device
>                         "dev/rmt0". Additional information (if available):
>                         "DAT01". Please ensure media is mounted
>                         and positioned correctly.
> 6) Try restore back, DAT02 from tape device (/dev/rmt0)
>    -  Status : Restore Success.

>    The DAT01 backup look like missing?? Where have it gone? Deleted or still
>    inside the tape?
>    Lets, continue the 2nd backup of the same database.

| DB2 Workstation Database Development            Backup and Restore |
| IBM Toronto Lab                                     IBMCA(krodger) |


Fri, 22 Jun 2001 03:00:00 GMT
 [ 4 post ] 

 Relevant Pages 

1. Problem restoring tables from tape backup

2. Problems restoring from backup tape

3. Tape multivolume backup/restore problems

4. Problem restoring tables from tape backup

5. Problem restoring SQL 6.5 table from tape backup

6. Wangtek 525MB tape got problem on file-restore at the second tape

7. Redirect Restore on DB2 7 EEE using a backup from DB2 EE

8. backup & restore: database user problem

9. Backup & Restore Problem

10. Restore db on W2000 by a tape backup from NT

11. Restore Tape Backup SQL7/NT4 to SQL2000/Win2k

Powered by phpBB® Forum Software