Re: Zero Downtime Upgrade and Migration
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 Oct 2010 12:01:17 -0700 (PDT)
For Golden Gate, you could get Oracle in for a demo and see if it will work for
your particular case.
you could try Materialized Views.
Logs would go on the source database the snapshots on the target db using a db
link to the source db.
Maybe alot of work depending upon how many tables you have.
I don't know the amount of data / type you have either.
If you have long/long raw values you need to create updateable Materialized
views and then create a procedure for each table to bring in the long raw
data. This is a bit complicated. I have done it.
K
--- On Wed, 10/13/10, Subodh Deshpande <deshpande.subodh@xxxxxxxxx> wrote:
From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
Subject: Re: Zero Downtime Upgrade and Migration
To: ora-apps-dba@xxxxxxxxxxxxx, avadhanimys@xxxxxxxxx
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, oaugnetdba-on@xxxxxxxx
Date: Wednesday, October 13, 2010, 12:44 PM
Avadhani,
whenever we are saying datababase upgradation or migration then there are only
3-4 methods, I am using very common langauge, so everybody will understand and
can point errors there in..
0) database software and rdbms upgrade
1) data copying using logical backups i.e. export import
2) inserting/updating tuples provided skeleton is confirmed..i.e. tablespace
and datafiles size and locations are confirmed, schemas, privileges, roles,
grants are as per new version..here you can use sqlloader, sql queries,
database links, copying tables using database links etc and tools such as
streams, replication or golden gate primarly based on sql queries..this
exercise requires a lot of ground work..
3) or assume this is the first day of the organisation, declare the cut of date
for previous data and start using latest installed database, with only skeleton
as mentioned in point 2..this type of approch will not require any down time as
you are not consider any thing about past data.
if the past data and time frame is important then down time is required..give a
rough estimation of work, justify it by trying on development..then only
everybody will be comfrtable.
Thanks!
Subodh
On 13 October 2010 15:14, 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
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
