By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,454 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,454 IT Pros & Developers. It's quick & easy.

Procedure to backup/restore Oracle 9 to Oracle 10

P: 1
Hi. I have two servers in the same MS network area:

1: MS 2000 Server, with an Oracle 9 installed (with license 1), and a DB1.
2: MS 2003 Enterprise R2, with an Oracle 10.2.0.3 installed (with license 2), and a DB2.

I want to realize a daemon/script/cmd to backup DB1 to prevent any type of inactivity/anomaly (oracle.exe at 100% during improbable day time, other relevant job that required more system resources) of the server 1, and to switch the DB1 on server2 restoring a robust/last/actual available backup. Suppose that it's possible to have even a network failure limited to server1 (ethernet card adapter in error, cable interruption). So probably is necessary to decide to restore starting from the last cold-backup or directly in a hot-backup way.

First answer: Is it possible to restore on a Oracle 10 environment on server 2 a backup of previous version of DB1, to activate the same DB1 on server2?
Second: Do I must modify the Oracle environment of server 2 to force compatibility on Oracle 9?
Third: What is solution that I will follow to do this job in a "robust way" (cold backup, hot backup, export, RMAN backup, Virtual Machine on server 2 of server 1?).

Thank you.
Mar 13 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.