This content has been marked as final. Show 6 replies
This is just my point of view, being more an oracle apps dba.
A. Install 11.2 on the same box and upgrade the DB to 11.2
B. Setup a dataguard to the RAC
C. Switch Over
Will be clean, and you will do one clear step at the time.
also you can do that what Oracle says if you want to migrate for example to exadata.
Use Oracle Golden Gate to replicate your data. But all if this options are extra cost.
Hi Guys, than you for the reply, the golden gate is bit off the price and we do use oracle EE so data guard option is tempting. my worry is if some thing to go wrong while doing this on the live it self only options will be to activate the DR I dont want this risk as of now, please advice on below
1. using datapump with parallel=X and cluster=y can speedup
2. is there a way to use RMAN for the purpose if so would appreciate for some instruction and precautions (URL to some resources)
3. Will data guard support different platforms (10g is on redhat 5 and 11g2 is on 6.3)
Thanks and Best Regards
Edited by: user4433949 on Oct 17, 2012 11:44 PM
rman is a good option
here is an example, similar to what you are trying to accomplish. This user also migrated to ASM.
Much of the work on the new db can be done ahead of time, I mean before the final cutover.
I will insist a bit on the do one task at the time.
Single instance, 10.2
You install 11.2
make sure the database instance is on oratab
run dbua, this will ask you to take a bakacup. Here you have your restore point.
Once the DB is on 11.2, setting up dataguard is online, creating the standby is online.. you can open the stand by as real time query (read only) or convert to snapshot database (Read Write), then you can switch back to be a physical standby, and the system automagically roll back to the restore point and apply logs
Clone the 10.2, and do a test, is fair simple.
I think there is a way to use an rman from 10.2 into 11.2 (rac in your case) then do the upgrade.. but I think will take more downtime, and you won't know where's the problem if any.
Thank you Guys for all the help extended, let me go through my options and do a test run