Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to move RAC database to new location

378552Jan 6 2009 — edited Jan 6 2009
We are going to be moving a 2-node RAC database to a new physical location. Since a physical lift and shift will probably result in unacceptable downtime we are trying to plan the best way to move the database to new hardware and SAN. The database is using ASM shared storage for database files, OCFS for clusterware files and local storage for the oracle software/binaries. We have migrated other single instance databases using OS utility TDMF, but I'm not sure that will work for RAC database. What would be the best way to move the database with least amount of downtime and risk? The database is approx 135 GB in size and is backed up nightly using RMAN taking approx 1 hour to backup.

I posed the same quesition in SR to oracle and as I suspected their recommendation follows:

The following procedure should be followed to duplicate the RAC database on new cluster :

1. Install CRS on the new cluster
2. If you are using ASM, create the ASM instances on the new cluster
3. Create a RAC database using DBCA on the new cluster and then restore the RMAN backup(taken on the existing system).

Does anyone konw of other options? Has anyone ever used TDMF to migrate a RAC database, is that possible?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2009
Added on Jan 6 2009
2 comments
626 views