Hi,
Also - remember that the timestamp used for the rollforward is GMT.
I've been caught out a few times with that.
Glenn
-----Original Message-----
From: Balrinder Singh Balwant Singh
[mailto:db2udbdba-ezmlmshield-x19208077.[Email address protected]
Sent: Wednesday, 28 March, 2007 6:26 PM
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
____________________________________________________________________
This email is intended for the designated recipient(s) only, and may be confidential, non-public, proprietary, protected by the attorney/client or other privilege. Unauthorized reading, distribution, copying or other use of this communication is prohibited and may be unlawful. Receipt by anyone other than the intended recipient(s) should not be deemed a waiver of any privilege or protection. If you are not the intended recipient or if you believe that you have received this email in error, please notify the sender immediately and delete all copies from your computer system without reading, saving, or using it in any manner. Although it has been checked for viruses and other malicious software (“malware”), we do not warrant, represent or guarantee in any way that this communication is free of malware or potentially damaging defects. All liability for any actual or alleged loss, damage, or injury arising out of or resulting in any way from the receipt, opening or use of this email is expressly disclaimed.
______________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page