Q
Problem solve Get help with specific problems with your technologies, process and projects.

Taking delta changes after migration

I want to migrate from Oracle 8i to 10gR1 on a new server. If any of my applications are not working, I need to fall back on the old server. Is it possible to take only the delta changes from 10g and apply them to 8i?

I want to migrate from Oracle 8i (8.1.7) to 10gR1 on a new server. I will shut down 8i and run with 10gR1 on a new server. If any of my applications are not working with 10g, I need to fall back to 8i on the old server. Is it possible to take only the delta changes from 10gR1 which has happend for such a duration and apply them to 8i (8.1.7)? If yes, how? If no, what is the best practice?
It is not possible to replay transactions from a 10g database in an 8i database. In all of my upgrades, I have never had to resort to going back to an older Oracle version. That is because we test the upgrade process and we test our applications against the newest version in a test environment before upgrading production. If you have performed adequate testing, going back to an older Oracle version should not arise.
This was last published in December 2006

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close