FW: Need Your Inputs : DBA - ATG

In article <703iao$4r4$1@news.xmission.com>, Thalavoipuram, Kalyan <Kalyan_Thalavoipuram@amr-corp.com> writes > > >> Informix DBA's need your help. >> >> System: sparc SUNW, Ultra -2 box. >> OS : Solaris 2.5.1 >> Database Ver: Informix Online 7.20.UC2 >> Sounds resonably solid. We run 7.0.UD2 but this sounds and ok setup.. > >> 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 Sounds ok. You could look at www.iiug.org under Special Software. June Tong wrote some tools to unload a table from a level 0 ontape archive. I think Solaris 2.5.1 is one of the support platform. You could unload the tables to files using this, I think you get them in onunload format. Then load them into a separate test instance of online.. Would mean you have more time to check the data without affecting the users and do not need the users off the system for so long (only whilst loading the required rows..).. >> 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 >> -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care