Milton,

Point of time DB restore is made possible by use of full + incrementals. If
you do a full backup at 10:00am it will clear the logfile. A few changes are
made and again you fire off a full backup at 10:30am. This will then clear
the logfile for 10:00-10:30. You send the 10:00am off site. How can you
restore from 10:15. You can't. Think carefully on the logic.

Ask the question why you send off site immediately? If it is a simple form
of DR then send the snapshot. Keep the DB Full onsite and send the following
day. As I said we keep our DB full's within the Robot.

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: Tuesday, February 17, 2004 00:31
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Question on Restoration from DBSNAPSHOT

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