Re: SCN wrapping
From: mhoys <matthias.hoys_at_gmail.com>
Date: Fri, 20 Jan 2012 00:39:11 -0800 (PST)
Message-ID: <10019ea7-2195-4501-8007-3a71ea30d7d9_at_b20g2000yqb.googlegroups.com>
On Jan 20, 1:09 am, joel garry <joel-ga..._at_home.com> wrote:
> On Jan 19, 12:11 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
>
>
>
>
>
>
>
>
>
> > "Mladen Gogala" <gogala.REMOVETHISmla..._at_google.com> wrote in message
>
> >news:jf9kek$gk8$1_at_solani.org...
>
> > > It appears that Oracle 11G has a rather serious bug: it wraps SCN numbers
> > > around, when doing begin/end backup type of backup:
>
> > >http://tinyurl.com/6wbker6
>
> > > --
> > >http://mgogala.freehosta.com
>
> > I wonder if it's only 11g that's affected by the bug or also any older
> > versions? I don't remember reading anything about this in the last PSU patch
> > notes for 10g... And yes, there are still people using prehistoric
> > technology like 10g! ;-)
>
> > Matthias Hoys
>
> Note the link I posted used 9i. And we have another Wartiki-wannabe:http://blogs.oracle.com/UPGRADE/entry/fundamental_oracle_flaw_reveale...
>
> Mladen, see Bug 12371955 - Hot Backup can cause increased SCN growth
> rate leading to ORA-600 [2252] errors [ID 12371955.8]
> I think there is confusion because that was in 11.2.0.3, but is also
> available as a patch 12371955 for earlier versions. They don't seem
> to put the old patches in the new listing you posted.
>
> jg
> --
> _at_home.com is bogus.http://www.informationweek.com/news/security/app-security/232500111
Date: Fri, 20 Jan 2012 00:39:11 -0800 (PST)
Message-ID: <10019ea7-2195-4501-8007-3a71ea30d7d9_at_b20g2000yqb.googlegroups.com>
On Jan 20, 1:09 am, joel garry <joel-ga..._at_home.com> wrote:
> On Jan 19, 12:11 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
>
>
>
>
>
>
>
>
>
> > "Mladen Gogala" <gogala.REMOVETHISmla..._at_google.com> wrote in message
>
> >news:jf9kek$gk8$1_at_solani.org...
>
> > > It appears that Oracle 11G has a rather serious bug: it wraps SCN numbers
> > > around, when doing begin/end backup type of backup:
>
> > >http://tinyurl.com/6wbker6
>
> > > --
> > >http://mgogala.freehosta.com
>
> > I wonder if it's only 11g that's affected by the bug or also any older
> > versions? I don't remember reading anything about this in the last PSU patch
> > notes for 10g... And yes, there are still people using prehistoric
> > technology like 10g! ;-)
>
> > Matthias Hoys
>
> Note the link I posted used 9i. And we have another Wartiki-wannabe:http://blogs.oracle.com/UPGRADE/entry/fundamental_oracle_flaw_reveale...
>
> Mladen, see Bug 12371955 - Hot Backup can cause increased SCN growth
> rate leading to ORA-600 [2252] errors [ID 12371955.8]
> I think there is confusion because that was in 11.2.0.3, but is also
> available as a patch 12371955 for earlier versions. They don't seem
> to put the old patches in the new listing you posted.
>
> jg
> --
> _at_home.com is bogus.http://www.informationweek.com/news/security/app-security/232500111
Thanks, that MOS article helped to clear up the confusion a bit :-) Looks like the bug was already fixed in the 11.2.0.3 server patch set.
And this is what they say about pre-11g versions:
"This fix is *NOT* required in any release prior to 11g. For 11g onwards this fix is already included in various Patch Set Updates and bundles as listed above."
*getting even more confused*
Matthias Hoys Received on Fri Jan 20 2012 - 02:39:11 CST