Re: Oracle 11.2 as RMAN Catalog - My experience
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- Date: Fri, 23 Apr 2010 10:27:41 -0300
They finally opened a new bug for us, 9630883 and it's being worked on by
Development.
I know the catalog is a rather simple thing, but even the simplest things
have bugs... and we happened to hit one.
cheers
Alan.-
On Fri, Apr 23, 2010 at 3:53 AM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx>wrote:
> Thanks, Alan. for your experience shared.
>
> Can you explained more detail about what you said "The main bug is
> being worked on at present time so there is not even a workaround.",
> What is the main bug? Bug No. or some other explanation.
>
> Based on my knowledge, RMAN catalog sync process is not complicated, I
> can't imaging such a heavy bug to raise so many 7445 and 600 error.
>
> --
> Kamus <kamusis@xxxxxxxxx>
>
> Oracle8i & 9i Certified DBA from China
> Oracle ACE
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
>
> On Wed, Apr 21, 2010 at 10:10 PM, Guillermo Alan Bort
> <cicciuxdba@xxxxxxxxx> wrote:
> > Listers
> >
> > A few days ago someone decided that one of our catalogs should be
> moved
> > to 11g, they chose to use 11.2.0.1. This is a small catalog, there are
> about
> > 50 databases in it, most of them on AIX and only a few on Linux, with
> > versions going from 9.2.0.6 to 10.2.0.4, interestingly, there were no 11g
> > databases.
> >
> > The migration went flawlessly, schema export, import, statistics,
> > catalog resync, first backup, catalog was updated correctly... so I
> thought
> > it was a happy upgrade (I had never seen one before)... until they
> started
> > to come... endless traces of ORA-7445 and ORA-600, database crashes each
> > time the dump dest filled up. My coworker tried opening an SR but the
> > interface did not work for him, another day went by, several (though not
> > all) backups were failing due to problems with the catalog. They'd
> connect
> > all right but then during the implicit resync they'd crash. I finally
> > managed to open a Service Request, after answering a lot of questions and
> > doing my own investigation in the knowledge base... there are bugs in 11g
> > and there appears to be no solution.
> >
> > The main bug is being worked on at present time so there is not even
> a
> > workaround.
> >
> > It looks like we might be reverting the migration, though this has
> not
> > been decided yet.
> >
> > This is only a warning, so other people don't hit the same wall.
> >
> > Now, I've worked with Oracle for several years now, new software is
> > always buggy as hell (reminds me of 9.2.0.1, or OracleAS 10g 9.0.4) and
> > after a dew patchsets it becomes quiet stable (9.2.0.4, 9.2.0.6, 9.2.0.8,
> > 10.1.0.4, 10.2.0.3, etc)
> >
> > I'd recommend anyone planning to migrate their catalog to 11g to
> hold
> > off for a few months until the grosest bugs are solved.
> >
> > cheers
> > Alan.-
> >
>
Other related posts: