Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Remeta, Mark
ry 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 ma

Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Johnson, Milton [IT]
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/i

Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Mark D. Rodriguez
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

Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Remeta, Mark
] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 1:43 PM To: [EMAIL PROTECTED] Subject: Re: Question on Restoration from DBSNAPSHOT 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

Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Johnson, Milton [IT]
EMAIL PROTECTED] Subject: Re: Question on Restoration from DBSNAPSHOT Hi Milton, It's been a long time since we talked. You know you could have just called me and I would have helped you out. But anyway here is what I recommend: DBSNAPSHOT - should be used for your DR backups of the DB. They sh

Re: Question on Restoration from DBSNAPSHOT

2004-02-17 Thread Mark D. Rodriguez
Hi Milton, It's been a long time since we talked. You know you could have just called me and I would have helped you out. But anyway here is what I recommend: DBSNAPSHOT - should be used for your DR backups of the DB. They should be to a tape and taken offsite with your DR tapes. DBSNAPSHOT is

Re: Question on Restoration from DBSNAPSHOT

2004-02-16 Thread Mike Wiggan
/knowledge on this? Thanks, H. Milton Johnson Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mike Wiggan Sent: Friday, February 13, 2004 10:38 PM To: [EMAIL PROTECTED] Subject: Re: Question on Restoration from DBSNAPSHOT M

Re: Question on Restoration from DBSNAPSHOT

2004-02-16 Thread Johnson, Milton [IT]
on this? Thanks, H. Milton Johnson Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mike Wiggan Sent: Friday, February 13, 2004 10:38 PM To: [EMAIL PROTECTED] Subject: Re: Question on Restoration from DBSNAPSHOT Milton, We

Re: Question on Restoration from DBSNAPSHOT

2004-02-13 Thread Mike Wiggan
]) -Original Message- From: Johnson, Milton [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 20:06 To: [EMAIL PROTECTED] Subject: Question on Restoration from DBSNAPSHOT All, TSM: Storage Management Server for AIX-RS/6000 - Version 4, Release 2, Level 1.7 OS: AIX

Question on Restoration from DBSNAPSHOT

2004-02-12 Thread Johnson, Milton [IT]
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