Title: Best way to move the modified data after upgrade
|
Chetan ,
Do you have connectivity between two sites ? How
much downtime ? and how much data ( archived log files ) will be generated in 3
days ? ( rough idea ) .
If answer to first question is yes and not
much ( terabites ) of redo is generated then you can first install same
version of databases as originally then recover till current date and
migrate to 9i finally . But yeah during 9i migration I guess you will need some
downtime .
-ak
----- Original Message -----
Sent: Monday, September 15, 2003 2:34
PM
Subject: Best way to move the modified
data after upgrade
Kindly read the whole scenario and let me
know your views.
(1) What we have ?
- Three db instances on the same
machine.
- Two of the instances are on
8.1.7.4
- One of the instance is on
8.1.6.0
- Oracle as well as O/S is running on
32-bit.
- Database is running in archivelog
mode.
- The current box is Sun SPARK
E6500.
- Use BCV backup solutions with Veritas
NetBackup for tape integration.
- The production server (E6500) and the
backup server both are physically located in Ohio.
- The total db size is 1.5 TB.
(2) What we are going to do ?
- Migrate to a new E12K server.
- Migrate all three instances to
9.2.0.4
- Install Oracle on top of 64-bit Sun
Solaris 2.9 version.
- Install 64-bit Oracle software on top
of it.
- The new server is supposed to be
located in Arizona.
(3) How we are going to do ?
- Shut down all three instances on the
production server.
- Take the backup on the backup
server.
- Copy the data on to tape.
- Ship the tapes over to Arizona where
the new E12K box resides.
- Copy all the data from tape on to the
new E12K.
- Upgrade all three instances on the new
E12K as mentioned above on DAY1.
- Back up all the data locally.
- Now it takes around 2 days to ship all
the tapes are shipped to Arizona and then copy the data over to new E12K.
During this time the users are still accessing the production server in
Mason. Also the etl jobs are updating/inserting/deleting data from this
server in those two days.
(4) Whether this is possible ?
- Now lets say we want to apply just the
changed data from DAY1 till DAY3 is there any way I can do it ? The only
other option we have at this moment is to run all the jobs against the newly
configured E12K. (I guess the answer is NO, but just wanted to confirm with
u all)
----------------------------------------------------------------------------------------------------------------------
Thanks, Chetan
|
