Why don't you just send your first tape off-site since it can only be used
for a PIT restore anyway and keep the second tape on-site for the
rollforward restore of your database?


Mark


-----Original Message-----
From: Johnson, Milton [IT] [mailto:milton.johnson AT CITIGROUP DOT COM]
Sent: Tuesday, February 17, 2004 2:41 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Question on Restoration from DBSNAPSHOT


Mark,

Actually it's not confusing.  Logically since there have been no
transactions between the two full DBB, resetting the recovery log should not
logically cause any problems.  Of course if TSM is marking each DBB and
recovery log set with some sort of serial number, and will only play with
matching serial numbers I can understand the "mechanical" reason why it
won't work.

Of course I can have my cake and eat it too by:
1) Doing a full DBB to disk
2) Sending that DBB to tape during my daily Sysback system backup

Thanks,
H. Milton Johnson
Voice: (210) 677-6728

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mark D. Rodriguez
Sent: Tuesday, February 17, 2004 1:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Question on Restoration from DBSNAPSHOT

Milton,

The short answer is no.  You can only use the most recent full/incremental
series to restore to the most current state, i.e. using the ROLLFORWARD log.
The reason is that once you do a DBB (either full or incremental) the log is
reset.  Therefore any older version, in your case the first DBB full, can
only be used for a PIT restore.

Hang in there, I know it gets confusing at times but it really does make
sense in a crazy sort of way!

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

============================================================================
===
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced
Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP,
TSM/ADSM and Linux Red Hat Certified Engineer, RHCE
============================================================================
===



Johnson, Milton [IT] wrote:

>Mark / Mike,
>
>Nice to here from you Mark.  I am aware that DBSNAPSHOT can only be
>used for PIT restoration, at least after refreshing myself, and that
>only the BACKUP DB FULL/INCR resets the recovery log. What I'm now
>asking is can I make two DBB (full), one immediately after the other,
>and then use either one to do a restore to the point of failure using the
recovery log?
>
>Thanks,
>H. Milton Johnson
>Voice: (210) 677-6728
>
>

Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.