Re: Zero Downtime Upgrade and Migration
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 14 Oct 2010 07:01:50 -0700 (PDT)
100G is nothing.
If you have a small amount of tables I would go with Materialized Views.
You set up the logs on the source db and the snapshots on the target db
and a db link goes between.
You set up refresh groups to sync the data up.
Do you have any long or long raw columns? That would be a challenge to do.
K
--- On Thu, 10/14/10, Avadhani mys <avadhanimys@xxxxxxxxx> wrote:
From: Avadhani mys <avadhanimys@xxxxxxxxx>
Subject: Re: Zero Downtime Upgrade and Migration
To: "ora-apps-dba" <ora-apps-dba@xxxxxxxxxxxxx>, "oracle-l"
<oracle-l@xxxxxxxxxxxxx>, oaugnetdba-on@xxxxxxxx
Date: Thursday, October 14, 2010, 3:12 AM
Hello Gurus,
Answers to some of the queries:
1) I'm not sure why they preferred Solaris than Linux.
2) Size of the database is close to 100G
3) Oracle AS with Developer 6i forms and reports
Thanks for all your suggestions
On Wed, Oct 13, 2010 at 3:14 PM, Avadhani mys <avadhanimys@xxxxxxxxx> wrote:
Hello Gurus,
Please let me know any suggestions other than Oracle-Golden-gate to achieve
Zero downtime migration.the challenge is we need to Upgrade and Migrate Oracle
8i database [Upgrade to 11gR2 and migrate to Sun-Solaris from AIX]. This is
very critical application and client needs Zero downtime.
Please let me know your valuable suggestions on this. And also please let me
know your valuable inputs/links on the documents on using Oralce Golden gate
to achieve Zero downtime upgrade and migration
Thanks in Advance.
Regards,
Avadhani
Other related posts:
