giovedì 28 aprile 2016

db2 backup online and rollforward

I want to share one situation where I got an error during the rollforward of a restore of a backup taken online because an error of missing transaction log files.

So I did backup of the database:

db2 -v backup db DBNAME online to /DB_BACKUPS compress  UTIL_IMPACT_PRIORITY 50 include logs without prompting

Then I transfered it to a computer destination where executed the restore:

db2 restore database MAXDB75 from /DB_BACKUPS taken at 20160419133051 into DBNAME NEWLOGPATH '/transationlogs' redirect


Bur during rollforward I've got:

db2 "rollforward database DBNAME to end of backup and complete"

SQL1273N An operation reading the logs on database "DBNAME" cannot continuebecause of a missing log file "S0017002.LOG" on database partition "0" and logstream "0".

I solved copying manually the olds transaction logs into the new database log path.



Nessun commento:

Posta un commento