HI
We have successfully restore from TSM but when we perform rollback got error as below.
ON /db2/GQB/sapdata6 ,/db2/GQB/sapdata5 ,/db2/GQB/sapdata4 ,/db2/GQB/sapdata3 ,/db2/GQB/sapdata2 ,/db2/GQB/sapdata1 DBPATH ON /db2/GQB INTO GQB LOGTARGET /db2/GQB/log_dir/NODE0000/ WITH 2 BUFFERS BUFFER 1024
SQL2528W Warning! Restoring to an existing database that is the same as the
backup image database, but the alias name "GQB" of the existing database does
not match the alias "GPB" of backup image, and the database name "GQB" of the
existing database does not match the database name "GPB" of the backup image.
The target database will be overwritten by the backup version.
Do you want to continue ? (y/n) y
SQL2580W Warning! Restoring logs to a path which contains existing log files.
Attempting to overwrite an existing log file during restore will cause the
restore operation to fail.
Do you want to continue ? (y/n) y
DB20000I The RESTORE DATABASE command completed successfully.
***********************************************************
***********************************************************
GMU-BIQB:db2gqb 56> db2 rollforward db GQB to end of logs
SQL4970N Roll-forward recovery on database "GQB" cannot reach the specified
stop point (end-of-log or point-in-time) because of missing or corrupted log
file(s) on database partition(s) "0". Roll-forward recovery processing has
halted on log file "S0130978.LOG".
GMU-BIQB:db2gqb 57> db2 rollforward db GQB complete
SQL1276N Database "GQB" cannot be brought out of rollforward pending state
until roll-forward has passed a point in time greater than or equal to
"2011-07-08-08.18.22.000000 UTC", because node "0" contains information later
than the specified time.
Appreciated your help on this.
Regards,
Kumar
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.