Re: data load
From: Oracle DBA <oradba.training_at_gmail.com>
Date: Thu, 24 May 2012 01:08:39 -0700 (PDT)
Message-ID: <eef5bac5-a5af-4dc6-896b-c0d890b59995_at_oe8g2000pbb.googlegroups.com>
On May 23, 10:39 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 22, 6:35 pm, oradba.train..._at_gmail.com wrote:
>
> > hi
> > we have application version x and database is running at 10g
> > we have plan to upgrade the application version to y and database to 11g.
> > Oracle upgrade to 11g is arlight.
> > but the complexity in application upgrade is that - there are many schema changes in version y of schema.
> > so i.e. data load to new schema wont be straightforward.
> > we are looking for any tool etc which would be useful here which can save the development work here.
> > many thanks
>
> Doesn't the application have such a tool? Does y run with 10g or x
> with 11g?
>
> When I've faced such a complex migration, I've usually done it in a
> number of steps and backups, so any step can be restarted. Since
> major metadata changes usually means major data updates, for me it
> often makes sense to go noarchivelog and depend on cold backups, then
> switch to archivelog and backup at end (or beginning, depending on
> your point of view).
>
> jg
> --
> _at_home.com is bogus.http://www.nctimes.com/news/local/san-marcos/san-marcos-educators-que...http://www.utsandiego.com/news/2012/may/15/dont-take-incredible-schoo...
> Bad data is forever:http://www.usnews.com/education/best-high-schools/california/district...
Date: Thu, 24 May 2012 01:08:39 -0700 (PDT)
Message-ID: <eef5bac5-a5af-4dc6-896b-c0d890b59995_at_oe8g2000pbb.googlegroups.com>
On May 23, 10:39 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 22, 6:35 pm, oradba.train..._at_gmail.com wrote:
>
> > hi
> > we have application version x and database is running at 10g
> > we have plan to upgrade the application version to y and database to 11g.
> > Oracle upgrade to 11g is arlight.
> > but the complexity in application upgrade is that - there are many schema changes in version y of schema.
> > so i.e. data load to new schema wont be straightforward.
> > we are looking for any tool etc which would be useful here which can save the development work here.
> > many thanks
>
> Doesn't the application have such a tool? Does y run with 10g or x
> with 11g?
>
> When I've faced such a complex migration, I've usually done it in a
> number of steps and backups, so any step can be restarted. Since
> major metadata changes usually means major data updates, for me it
> often makes sense to go noarchivelog and depend on cold backups, then
> switch to archivelog and backup at end (or beginning, depending on
> your point of view).
>
> jg
> --
> _at_home.com is bogus.http://www.nctimes.com/news/local/san-marcos/san-marcos-educators-que...http://www.utsandiego.com/news/2012/may/15/dont-take-incredible-schoo...
> Bad data is forever:http://www.usnews.com/education/best-high-schools/california/district...
Thanks Joel.
we are at 10g.
target us 11g.
Somthing Oracle GoldenGate can do both the work here..
i.e. Upgrade and Tranformation.
some doc links on that would be useful.
Received on Thu May 24 2012 - 03:08:39 CDT