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