check your archive logs, may not all logs needed for rollforward it



Lekharaju Ennam

-----Original Message-----
From: Sandeep_Shah
[mailto:db2udbdba-ezmlmshield-x58070993.[Email address protected]
Sent: Wednesday, May 25, 2005 7:52 AM
To: LazyDBA Discussion
Subject: Restoring online backup


Hi all,



Am unable to restore an online backup. Here the steps done:



1. created a database and tables in it
2. set the userexit, logretain and trackmod ON
3. took an offline backup (backup db sample)
4. took an online backup (backup db sample online)
5. dropped the database (drop db sample)
6. restored the online backup version (restore db sample taken at
timestamp)
7. rollforward db sample to end of logs and complete (since the
database goes into rollforward pending state)



I get the following error after executing step 7:

SQL4970N Roll-forward recovery on database "SANDB1" cannot reach the

specified stop point (end-of-log or point-in-time) because of missing
log

file(s) on node(s) "0".



Is there any way out of this or any other alternative? Any suggestions
are appreciated.



Thanks,

Sandeep.









DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page