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