RE: Urgent - Failing Chunk

Howdy Folks, Don't worry, got it sorted out, thanks to IFX support. I took the system down before the database had completed the logical recovery. (Won't do that again) so IFX support got me to do an oninit -r and everything is a o.k. Regards Suze > -----Original Message----- > From: Susan Elliott (ISG) > Sent: Sunday, July 18, 1999 10:59 AM > To: 'Informix Mailing List' > Subject: FW: Urgent - Failing Chunk > Importance: High > > > Howdy Folks, > > > > Hopefully someone can share their opion on this one for me. > > > > We have just down an upgrade of some disks in our server. Restored the > > database using ontape -r, which completed normally. I stuffed up on the > > commands for changed the type of server for HDR. So I entered in the > > correct parameters for the secondary server, and then decided to change > it > > to standard, shutdown the system and went bring it back up, and then > enter > > the correct parameters for HDR when I revieved sanity check errors on 1 > > chunk. > > > > It does happen to be one of the chunks that had been moved onto the new > > disk. These disk are striped and mirrored at the h/w level. This is > the > > only lvol out of the set on the disk that is having issues. So > > obvisiously, I checked the links, and the physical disk, everything > looks > > fine. Sort of strikes me funny that the restore completed o.k. cos > > normally a chunk is down while restoring, the restore fails..... > > > > Does this mean, that probably me stuffing up the onmode commands for HDR > > commands has caused some kind of corruption ??? And I now have to > > re-restore from scratch ??? > > > > Any assistance with this matter would be much apprieciated, as this is > my > > production system. > > > > Thanks in advance > > > > Suze. > > > > > > Note: the following entries should not effect the suitation as it is > > normal. > > > > 09:46:20 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > 09:46:20 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP.> > > > > > > > 18:47:42 Checkpoint Completed: duration was 1 seconds. > > 19:06:24 Logical Log 49388 Complete. > > 19:18:05 Checkpoint Completed: duration was 5 seconds. > > 19:48:23 Checkpoint Completed: duration was 0 seconds. > > 20:17:59 Archive on rootdbs, plogdbs, llogdbs, datadbs, idxdbs > Completed. > > 20:18:00 Checkpoint Completed: duration was 0 seconds. > > 20:28:24 Logical Log 49389 Complete. > > 20:37:06 Checkpoint Completed: duration was 0 seconds. > > 20:37:06 INFORMIX-OnLine Stopped.> > > > Sat Jul 17 22:45:35 1999 > > > > 22:45:35 Event alarms enabled. ALARMPROG = > > '/opt/informix/etc/ifx_alarm.sh' > > 22:45:41 DR: DRAUTO is 0 (Off) > > 22:45:42 HPUX Version B.10.20 -> Using flag style KAIO > > 22:45:43 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > > 22:45:43 Dataskip is now OFF for all dbspaces > > 22:45:43 Recovery Mode > > 22:45:44 Physical Restore of rootdbs, plogdbs, llogdbs, datadbs, idxdbs > > started.> > > > > > Sun Jul 18 04:09:00 1999 > > > > 04:09:00 Physical Restore of rootdbs, plogdbs, llogdbs, datadbs, idxdbs > > Completed. > > 04:09:00 Checkpoint Completed: duration was 0 seconds. > > 09:46:20 DR: new type = primary, secondary server name = dr_srsvr > > 09:46:20 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > 09:46:20 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP. > > 09:46:20 DR: Trying to connect to secondary server ... > > 09:46:20 DR: Cannot connect to secondary server > > 09:46:20 DR: Turned off on primary server > > 09:47:05 DR: Primary to Primary > > 09:47:05 DR: new type = primary, secondary server name = dr_drsvr > > 09:47:05 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > 09:47:05 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP. > > 09:47:35 DR: Cannot connect to secondary server > > 09:47:35 DR: Turned off on primary server > > 09:48:12 DR: new type = standard > > 09:48:12 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > 09:48:12 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP. > > 09:48:37 INFORMIX-OnLine Stopped.> > > > Sun Jul 18 09:49:16 1999 > > > > 09:49:16 Event alarms enabled. ALARMPROG = > > '/opt/informix/etc/ifx_alarm.sh' > > 09:49:21 DR: DRAUTO is 0 (Off) > > 09:49:22 HPUX Version B.10.20 -> Using flag style KAIO > > 09:49:23 chunk failed sanity check > > > > 09:49:23 I/O error, Primary Chunk '/dev/ifx_raw_links/tmpdbs1_1' -- > > Offline (sanity) > > 09:49:24 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > > 09:49:24 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > 09:49:24 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP. > > 09:49:24 Physical Recovery Started. > > 09:49:24 Physical Recovery Complete: 0 Pages Restored. > > 09:49:24 Logical Recovery Started. > > 09:49:27 Logical Recovery Complete.> > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks