In my environment we are using DB2 v9.7 on AIX 6.1 version.
I restored full database backup using online include logs with redirect restore option.it done successfully.later as per my requirement i have to restore online delta backup with include logs.So when i am applying delta backup on full backup i used the following commands.
bash-3.2$ db2 restore db dogear incremental automatic taken at 20140504215454
SQL2539W Warning! Restoring to an existing database that is the same as the
backup image database. The database files will be deleted.
Do you want to continue ? (y/n) y
DB20000I The RESTORE DATABASE command completed successfully.
after i tried to roll forward the database by using below command.
bash-3.2$ db2 "rollforward db dogear to end of logs and stop overflow log path ('/tmp/logtarget/') noretrieve"
SQL4970N Roll-forward recovery on database "DOGEAR" cannot reach the
specified stop point (end-of-log or point-in-time) on database partition(s)
"0". Roll-forward recovery processing has halted on log file "S0000850.LOG".
i tried with many more roll forward options but no luck So Could you please suggest what are all the steps that i have to follow for completing this rollforward.
Any help greatly Appreciated.