RE: restore question

Posted in 2000

mosserp@WellsFargo.COM — Tue, 22 Feb 2000 12:37:39 -0800 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF7D74.A96EF193 Content-Type: text/plain; charset="iso-8859-1" Assuming that your "restore" is of a level-0 archive... -- are OS versions (incl. patches) and IDS versions identical on both boxes? -- is your disk layout identical on both boxes? -- have you synchronized adding/removing of any chunks/dbspaces on both boxes? And if all of these answers are "yes", have you considered using HDR? It could save you *a lot* of time and effort every week! HTH, Paul Mosser -----Original Message----- From: Rock, Howard [mailto:HRock@iso.com] Sent: Tuesday, February 22, 2000 1:13 PM To: 'Informix List' Subject: restore question I am running Informix 7.24 and I have a question for anyone who can answer it I have been backing up my production server and restoring it on my backup system once a week for about 6 months. This past weekend I tried to restore but the restore never finished. It normally runs for 4 1/2 hours. I let it run for 8 hours the first time and 11 hours the second before I broke out of it. The interesting part is I CAN bring the system online and the only problem I have had is an assert failed on 1 index (Which I dropped and recreated). This is our backup server so the importance of this particular data being perfect is not the most important issue. The questions I have is: What could be the reasons that the restore never finished? (One clue is that it was waiting on a checkpoint( CHKPT BLOCKED ) & how can I correct this for my next restore next week? How clean is the data? I know this is an impossible question to answer but I would like opinions. I don't know what further information you might need but I will provide any more information that might help. Thanks, Howard Rock mailto:hrock@iso.com visit our website at http://www.iso.com ------_=_NextPart_001_01BF7D74.A96EF193 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: restore question</TITLE> </HEAD> <BODY> Assuming that your "restore" is of a = level-0 archive...  -- are OS versions (incl. patches) and IDS = versions identical on both boxes?  -- is your disk layout identical on both = boxes?  -- have you synchronized adding/removing of = any chunks/dbspaces on both boxes? And if all of these answers are "yes", have = you considered using HDR?  It could save you *a lot* of time and = effort every week! HTH, Paul Mosser -----Original Message----- From: Rock, Howard [<A = HREF=3D"mailto:HRock@iso.com">mailto:HRock@iso.com</A>] Sent: Tuesday, February 22, 2000 1:13 PM To: 'Informix List' Subject: restore question I am running Informix 7.24 and I have a question for = anyone who can answer it I have been backing up my production server and = restoring it on my backup system once a week for about 6 months. This past = weekend I tried to restore but the restore never finished. It normally runs for = 4 1/2 hours. I let it run for 8 hours the first time and 11 hours the = second before I broke out of it. The interesting part is I CAN bring the system = online and the only problem I have had is an assert failed on 1 index = (Which I dropped and recreated). This is our backup server so the = importance of this particular data being perfect is not the most important issue. = The questions I have is: What could be the reasons that the restore never = finished? (One clue is that it was waiting on a checkpoint( CHKPT BLOCKED ) = & how can I correct this for my next restore next week? How clean is the data? I know this is an impossible = question to answer but I would like opinions. I don't know what further information you might need = but I will provide any more information that might help. Thanks, Howard Rock <A = HREF=3D"mailto:hrock@iso.com">mailto:hrock@iso.com</A> visit our website at <A HREF=3D"http://www.iso.com"; = TARGET=3D"_blank">http://www.iso.com</A>; </BODY> </HTML> ------_=_NextPart_001_01BF7D74.A96EF193--

RE: restore question

Related threads

Your privacy choices