-
hand-rollforward on a standby for windows
Got DB2 v8.2 WUE
-Machine A runnig XP
-Machine B " 2003 server
I have the following error trying to do a hand rollforward on machice B:
db2 => rollforward database BD to end of logs
SQL1265N The archive log file "S0018161.LOG" is not as
current log sequence for database "BD" on node "0".
What I want to have is a standby database of A's bd on B so minimize out of service time. What I did is:
-Make a full online backup including logs of A's bd and send it to B.
-Restore the backup image on B.
-Rollforward it to end of logs but not complete.
-On A did a archive log command.
-did a get db cfg so I can see which logs file were archived so pass them to B.
-Send the archived files to B.
-Did I rollforward to end of logs in B, showing me the error above.
I know HADR is a nice solution but we do not have any budget. I tryed using user exit programs but found to many error and problems.
Appreciate any help.
Juan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|