Mike,

I'm somewhat surprised that so far yours has been the only reply. I have
reviewed the 4.2 Administrators Reference and it clearly states on page 873
that a snapshot can not be used to restore a db to it's most current state,
so I guess that answer's my original question but begs another.  If I make a
full backup to tape/disk and immediately follow it with another full backup
to disk/tape, can I do a db restore to it's most current state using either
one of the full db backups as a starting point and the recovery log?

Richard,

Do you have any thoughts/knowledge on this?

Thanks,
H. Milton Johnson
Email: milton.johnson AT citigroup DOT com

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mike Wiggan
Sent: Friday, February 13, 2004 10:38 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Question on Restoration from DBSNAPSHOT

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