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






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