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.