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:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 2:41 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Mark D. Rodriguez Sent: Tuesday, February 17, 2004 1:05 PM To: [EMAIL PROTECTED] 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.
