I have three regions: hsprd
, hstst
, and hstrn
.
A request came in to restore hstst
to hstrn
, then to restore hsprd
to hstst
.
I don't run backups on my hstst
or hstrn
regions. So I manually ran a backup of hstst
to restore into hstrn
using this command:
db2 restore db hstst taken at XXXXXXXXXXXXXXXX to /dbs into hstrn newlogpath /dbs/log/hstrn
My users said the system 'looked good'.
I delete my hstst
backup, run a manual backup of hsprd
, and repeat my process to restore hsprd
into hstst
. Everything goes fine, but I was getting an error about a ROLL-FORWARD PENDING
status. So then I run these commands:
db2 restore db hsprd logs logtarget /dbs/log/hstst
db2 rollforward db hstst to end of logs and complete
Now my users are saying the hstrn
region is reporting the same ROLL-FORWARD PENDING
status. I try to run the same commands as above, but on my hstrn
region, however my database backup for hstst
has been deleted. When trying to rollforward, I get this message:
(/home/hs/hstrn)> db2 rollforward db hstrn to end of logs and complete
SQL4970N Roll-forward recovery on database "HSTRN" 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 "S0006597.LOG".
Is there something I can do?
EDIT: I've tried to db2 rollforward db hstrn to end of logs and complete
but receive this error:
SQL4970N Roll-forward recovery on database "HSTRN" 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 "S0006597.LOG"
Aucun commentaire:
Enregistrer un commentaire