Machine Critical Oracle Database Upgrade

Here is what our system looks
 
Primary oracle database 10.2.0.2
logical standby orcale database:10.2.0.2
 
Our system is machine critical and we get an average of 7 transactions per second during noraml time and may be 20 transactions during peak hours. There are 5 impotant tables which we are concerned the data.

TRANS tables is about 100M+ Rows,
MASTER is 100M+ rows
AUTH is 7m+
CAPTis less 100,000
SETTLE is less then 5000 rows. Each time we may need a mximum of last 10 days of data to process incoming transactions which is about 100,000 rows in the big tables and less then that in other tables.
 
Our plan is to upgrade both database to 11gSR2. Options we have is doing SWITCHOVER and which invloves a minimum of 3 minutes down time to a maximum of 30 minutes. Other option I suggestes is bit complex. create a maintenence database of small size with populating last 10 days of data. then put database insert trigger on the parent database and insert them all in the maintenence database after it was setup initially. But I still expect a gap between the time the maintenence database was setup and the trigger was created

Also bringing them back to the primary database also may be a pain
 
Oracle provide a solution but waaay expensive.Oracle golden gate tool which is very nice but our company cannot afford it this time. Other option is advanced replication which I need to research more and find out or oracle streams or materialized view which I am affarid to do it from primary database as it may affect the performance and also bringing the data back from the maintenence database to the primary after successfull upgrades

any other better solution if any would be really appreciated
prgeorge3383Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fhsyedCommented:
I'm afraid, you'll have to go with the SWITCHOVER/SWITCHBACK - option.

I had exactly the same problem about a year ago with a customer upgrading from 10.2 to 11.1.

This was the base for the decision on the customer side to switch over to RAC (where you can do rolling upgrades for each node separately) in the long run ...
0
prgeorge3383Author Commented:
still waiting to see an answer
0
sdstuberCommented:
is this question still open?

are your rapid transactions inserts only?
0
gvsbnarayanaCommented:
You might have already evaludated this option or Oracle must have suggested this approach:
Build a Standy Database
Stop log shipping
Upgrade your Standby to 11g
Turn the Standby to Logical Standby; continue the log apply
when you are ready, switch to 11g and then build your standby
This process very very well explained in the presentation available at
http://blogs.oracle.com/UPGRADE
HTH
Regards,
Badri.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavidSenior Oracle Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.