Milton,

We recently introduced disaster recovery, and I pondered this for a while.
The outcome is that we store the DBSNAPSHOT off site, as one can recover to
a point in time. In our case VIA a SAN to another robot.

We keep the full backup + any incremental within the local robot to avoid
time delay.

Prior to introducing DR, I remember one evening when we had to recover the
database and it took two hours before we got the tape into the robot. One
soon learns.

Kind Regards


Mike Wiggan, TCS/14
IT Infrastructure Integration Specialist
Petroleum Devlopment Oman LLC
(michael.ma.wiggan AT pdo.co DOT om)


-----Original Message-----
From: Johnson, Milton [IT] [mailto:milton.johnson AT CITIGROUP DOT COM]
Sent: Thursday, February 12, 2004 20:06
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Question on Restoration from DBSNAPSHOT

All,

     TSM: Storage Management Server for AIX-RS/6000 - Version 4, Release 2,
Level 1.7
      OS: AIX 4.3.3 ML 9
Log Mode: RollForward
          (Upgrade project planned in near future, but that's another story)

Everyday I do a full backup of the database to 3590E tape, immediately
followed by a DBSNAPSHOT to a file on disk.  The 3590E tape promptly goes
offsite.  My question is if I experience a loss of the database can I then
restore from the DBSNAPSHOT and recover to the point of failure using the
RECOVERY LOG?  I would like to avoid the time delay of returning the 3590E
tape, containing the database backup, from the vault.

Anyone done this?

Thanks,
H. Milton Johnson
UNIX Systems Administrator - USCC San Antonio, TX
Email: milton.johnson AT citigroup DOT com