Recover with corruped log file ? - 03-21-2012 , 06:44 AM
New to DB/2, but have been DBA'ing on Ingres for some time.
We're running DB/2 9.7 Fix Pack 1. We have a Cognos BI database which beganrefusing connections with the 58030 error. It turns out our log disk ran out of space, and the logs were moved to another location. We then moved thelogs back to the correct location and tried reconnecting. Unfortunately wenow are getting the SQL1042C/58004 error, and it looks like the first of the logs has a problem.
We seem to have hit a perfect storm with this. The log (3538) is corrupt, and dates back to 19/3/2012. We have an online database backup from yesterday which was run excluding logs (but db2ckbkp shows that the first referenced log file is the corrupted 3538 from two days earlier). The "delete old backups" script has run overnight and removed any old backups, and from what I can gather no successful backup to tape has happened in the relevant window.
Are we now basically toast, and are looking to try recreate this database ?
If it were Ingres, I'd be able to do a rollforward and exclude the journal files to restore to the point in time of the backup without any further processing - is this possible in DB/2 with an online backup ? From my frantic reading this morning it looks like it would be possible with an offline backup, but restoring an online backup without further processing basically dumps me back to where I currently am ?
Thankfully it's a Cognos BI database so all the source data is available, but it's 69Gb and I'd rather avoid recreating it from scratch if possible...
Re: Recover with corruped log file ? - 03-21-2012 , 10:36 AM
On Wed, 21 Mar 2012 05:44:03 -0700, Tony Douglas wrote:
company management will have to sign waivers that you understand that such a restore (without logs)
may result in a logically inconsistant database. You obviously will need a support contract to be in
BTW, it is DB2, not DB/2.
Re: Recover with corruped log file ? - 03-23-2012 , 12:04 PM
On 3/21/2012 8:44 AM, Tony Douglas wrote:
--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---