DB2 does not lie - you are missing a log file or the database cannot
reach a consistent point in the logs. Try archiving the logs on the
PROD DB and getting the latest logs. Make sure you have all logs
especially the early ones. If you have long running transactions
reaching a consistent point can take a while. You can also try 'db2
roll forward db elsag complete'. This will give you a time stamp where
the DB must be rolled forward to. Then do a 'db2 roll forward db elsag
to <Timestamp> and complete overflow log path '(/tmp)' noretrieve'.
Good luck, JDPope
-----Original Message-----
From: Balrinder Singh Balwant Singh
[mailto:db2udbdba-ezmlmshield-x19208077.[Email address protected]
Sent: Wednesday, March 28, 2007 6:26 AM
To: LazyDBA Discussion
Subject: DB2 Restore and Rollforward
Hi Gurus,
Please Help Me, I did a online backup. I copied the backup image to my
DR server and issued this command :
db2 restore database bal FROM "/home/backup" TAKEN AT 20070122120112
WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT
PROMPTING
then I got this message : DB20000I The Restore Database command
completed successfully
after that I did this :
db2 rollforward database elsag to end of logs and complete
and got this message : SQL4970N Roll-forward recovery on database
"ELSAG" cannot reach the specified stop point (end-of-log or
point-in-time) because of missing log files(s) on node(s) "0".
So I coppied over the Log from my PROD machine and put it in my DR
server under /tmp, Then I issues this command :
db2 "rollforward database elsag to end of logs overflow log path
('/tmp')
the message I received is : SQL4970N Roll-forward recovery on database
"ELSAG" cannot reach the specified stop point (end-of-log or
point-in-time) because of missing log files(s) on node(s) "0".
Can anyone advise on this please...
Thanks.
Regards,
Balrinder
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page