How to move RAC database to new location
378552Jan 6 2009 — edited Jan 6 2009We 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?