Moving Production database to new machine
We have one production oracle database ver 18.104.22.168.on solaris 8.We want to move it to new solaris machine.I have two questions first We want to move it to new machine whats the best possible way to go so that downtime is minimal or no downtime. Second question is we want to upgrade this database ver to 22.214.171.124 on new machine. Should we install 10g database on new machine and do import/export from older version of our database or should we install the same version 126.96.36.199 on new machine and apply upgrade patch on new machine. I want to minimse the time of transition for this process. Any Suugestions will be greatly appreciated
the upgrade is your downtime.
If you are moving same to same (ie hardware, software etc) then create a standby db on the new server and then perform a switchover operation that will gracefully switch the db to the new server and zero data loss. Your downtime with a switchover should be inside of an hour if all goes well.
I'm stmontgo and I approve of this message
Use RMAN and Auxiliary Instance to duplicate, its the fastest and easiest... zip... zip... zooooom..........
"There is a difference between knowing the path and walking the path."
Oracle it's not just a database it's a lifestyle!
BTW....You need to get a girlfriend who's last name isn't .jpg
Yep, duplicate! Very fast and safe method.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
Click Here to Expand Forum to Full Width