RE: Oracle

Posted in 2005

Hamilton, Jerry — Thu, 3 Feb 2005 08:10:40 -0600 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C509FA.2462BF94 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Yes really.... Please read..... I'm sure there are others..... This = is the bug we hit..... =20 Bug: 153256 POINT IN TIME RESTORE DOES NOT WORK IF THERE IS AN OPEN = TRANSACTION THAT STARTED BEFORE LOG WHERE LEVEL 0 BACKUP STARTED Description: This is a regression of bug fix 103496. When we do a point in time restore we clear too much logical logfiles on = disk.=20 If we have an open transaction that started in a logfile before the logfile where the archive level 0 started, which is base of the pit restore, the pit restore will fail because we clear too much logfiles. We start clearing at lgr->lgr_start_id, which is ar_logid of archive_t structure, but we should start at lgr->lgr_oldlogid. This bug is fixed in 9.21.FC7 and above. You are currently on = 9.21.FC6X5, I have talked to my manager and we should be able to create = a patch for you, if you would like that. Please let me know _____ =20 From: Dirk Moolman [mailto:DirkM@mxgroup.co.za]=20 Sent: Thursday, February 03, 2005 3:28 AM To: Hamilton, Jerry; Cesae Cruz; Sebastian, Norma J.; = informix-list@iiug.org Subject: RE: Oracle Really ? =20 _____ =20 From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com]=20 Sent: 02 February 2005 10:05 PM To: Cesae Cruz; Sebastian, Norma J.; Dirk Moolman; = informix-list@iiug.org Subject: RE: Oracle =20 IDS 9.21 had all kinds of problems with open transactions and level-0 = back ups too..... =20 _____ =20 From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] = On Behalf Of Cesae Cruz Sent: Wednesday, February 02, 2005 11:57 AM To: Sebastian, Norma J.; Dirk Moolman; informix-list@iiug.org Subject: RE: Oracle Until you need something live a level 0 backup "Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> wrote:=20 Welcome to the land of "ORA-" errors. I have found you can ignore most of them :) Good Luck with Metalink ! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Dirk Moolman Sent: Tuesday, February 01, 2005 8:04 AM To: informix-list@iiug.org Subject: Oracle I find it quite simple to administor Oracle - they don't worry about number of extents & disk planning much - so its just a matter of creating directories and dumping the files in there ! I'll probably get smarter as I get to know Oracle better. But it beats me how they ignore the extent and disk layout issue. I come from an Informix world where I'm used to spreading load, planning extent sizes, etc. :-o Dirk Moolman Database and Unix Administrator MXGROUP "People demand f! reedom of speech as a compensation for the freedom of thought which they seldom use."=20 sending to informix-list =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D sending to informix-list =20 _____ =20 Do You Yahoo!? Yahoo! Net <http://net.yahoo.com.mx>; : La mejor conexi=F3n a internet y = 25MB extra a tu correo por $100 al mes <http://net.yahoo.com.mx/>; . ------_=_NextPart_001_01C509FA.2462BF94 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns=3D"http://www.w3.org/TR/REC-html40"; xmlns:v =3D=20 "urn:schemas-microsoft-com:vml" xmlns:o =3D=20 "urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word"><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE>@font-face { font-family: Tahoma; } @page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt = 90.0pt; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: blue; TEXT-DECORATION: underline } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: = "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto } SPAN.EmailStyle18 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=3DEN-US vLink=3Dblue link=3Dblue> <DIV dir=3Dltr align=3Dleft><SPAN class=3D439490914-03022005><FONT = face=3DArial=20 color=3D#0000ff size=3D2>Yes really....  Please read.....  I'm = sure there=20 are others.....  This is the bug we = hit.....</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D439490914-03022005><FONT = face=3DArial=20 color=3D#0000ff size=3D2></FONT></SPAN> </DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D439490914-03022005><FONT = face=3DArial>Bug:=20 153256 POINT IN TIME RESTORE DOES NOT WORK IF THERE IS AN OPEN = TRANSACTION THAT=20 STARTED BEFORE LOG WHERE LEVEL 0 BACKUP = STARTED<BR><BR>Description:<BR>This is a=20 regression of bug fix 103496.<BR>When we do a point in time restore we = clear too=20 much logical logfiles on disk. <BR>If we have an open transaction that = started=20 in a logfile before<BR>the logfile where the archive level 0 started, = which is=20 base of<BR>the pit restore, the pit restore will fail because we clear = too=20 much<BR>logfiles. We start

RE: Oracle

Related threads

Your privacy choices