A question about informix 7.31.UD6 Mirroring
Posted in 2006
Topics: Backup & Restore, Storage & Space Management
We have an Informix 7.31.UD6 database running on HPUX 11.11i. For various reasons, the parituclar machine that this database runs on has had quit a few issues with failing hard drives. Our database use software raid for some HPUX volumes and Informix mirroring for the database. In about half the cases where a drive has failed, we've had to reload the database from tape even if the HPUX volumes recover without reloading from tape backup. On the most recent occasion, the a drive was discovered to be failing and replaced prior to complete failure. Again, the HPUX volumes on the failing drive recovered readily and the operating system came up nicely. Unfortunately, the database was not so lucky, it had to be restored from a tape backup. To replace the drive, we shut the database engine down and then took the machine down completely. An hp technician replaced the failing hard drive and used various vg commands to restore logical volumes and data to the new drive. (note: There was no HPUX mirroring of the Informix database, all chunks were mirrored through the datbase engine.) It was assumed that since none of the chunks were marked as down, the database should come up and restore any missing data from the good drive. As mentioned before, this was not the case. Is there anything that should be done to tell Informix that a drive has been replaced? The only thing I can come up with is that the engine saw a blank drive where it expected data and freaked. Should the questionable chunks be taken offline before replacing a failing drive that has not totally died? Any input is appreciated. Chris Salch
from the online docs : Recovering a Mirror Chunk To begin mirroring the data in the chunk that is online, you must recover the down chunk. http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.admin.doc/admin615.htm#sii-20umirr-19632