Hey JDPope,
If you do an offline backup of your DB2 database and you want to move
it to another server, do you have to move the archive logs also?





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Pope John
[mailto:db2udbdba-ezmlmshield-x25099123.[Email address protected]
Sent: Wednesday, March 28, 2007 8:18 AM
To: LazyDBA Discussion
Subject: RE: DB2 Restore and Rollforward

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


---------------------------------------------------------------------
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