This posts illustrates steps for cloning a 11gR2 RAC database to a single Instance database. There are many ways to perform a RAC database to NON-RAC database clone, but the below illustrated seems to be the easiest approach for me compare to all other methods. In this demonstration oelrac1 & oelrac2 are OEL 5.6 Linux hosts running 11.2.0.1 GI and 11.2.0.1 database. - erpnode3 running OEL 5.6 configured with all database OS pre-requisites, but does not contain any oracle product installed on it. Steps: 1) perform full database backup from any of the RAC Instance RMAN> connect target connected to target database: PROD (DBID=208065887) RMAN> RUN 2> { 3> allocate channel ch1 type 4> disk format '/u01/11g_db/rman_db_backups/%d_DB_%u_%s_%p'; 5> backup database plus archivelog; 6> release channel ch1; 7> } released channel: ORA_DISK_1 allocated channel: ch1 channel ch1: SID=67 instance=prod1 device type=DISK Startin...
My Experiences with Oracle Technologies .....