FW: Need Your Inputs : DBA - ATG

> Informix DBA's need your help. > > System: sparc SUNW, Ultra -2 box. > OS : Solaris 2.5.1 > Database Ver: Informix Online 7.20.UC2 > > Quick summarry .. > > Had a disk / subdisk failure on RAID. There was a specified hot spare > disk . We got two mails from > the system ... (1) Informing the failure of the disk / subdisks . and (2) > That the recovery has started > and that there is no loss of data. We never got the mail that the > recovery completed successfully > though. > > We could not restore from the backup because the last level 0 backup was > done way back on Sep > 10th and they did not have any subsequent level 1 backup. This is not our > fault. The site is at Las > Vegas and the local IT staff did not do a good job in putting in the > tapes and taking the backups > properly. > > Ran consistency checks on the database .. found and fixed about 6 tables. > There were bad pages. > We worked around the bad pages to get the maximum possible records off > the tables. We did > lose records because of the bad pages. Did talk with INFORMIX support > also and they too suggested > that we can only do what we did. > > Anyway .. lots of historical info dating back to July / Aug of 1997 was > lost. Since they should be > available in the level 0 backup of Sept 10th we are trying to get the > data from that tape ... > > This is the steps that we are planning to follow ... > > 1. Get all the users off the system., this saturday ( Oct 17th ) > 2. Do a level 0 backup of the database when in quiescent mode. ( using > ontape ) > 3. Do a level 0 restore of the database ( cold restore ) using Sept 10th > level 0 backup ( using ontape ). > 4. Bring the database up online .. and download from tables july / aug > 1997 records that were lost . > 5. Shutdown the databse. > 6. Do a level 0 restore of the database ( cold restore ) using the Oct > 17th level 0 backup ( step 2). > 7. Load the data downloaded in step 4 .. and insert into the appropriate > tables. > > This is the first time I'm dealing with something like this. Please > comment on any possible mistakes > in the above steps. If there is a better alternative please let me know > about that too. When the backup > was done on Sep 10th.. The disk that had failed was fine. Will this cause > any problems when restoring > the database from Sept 10th level 0 backup ? > > Any other inputs will be appreciated. If you need any other information > please let me know and I can send that too. > Please if you want you can call me .. or you can even page me - (800) > 537-1092 > > Kalyan.T.S > @American Medical Response. > Phone... (303)481-3506 > Fax... (303)481-3507 >