Migration Oracle ASM to File System Different Host

Assalamu’alaikum ..

How to migration Oracle Database 11G ASM to other machine in file system?

Source: Oracle Database Enterprise 11.2.0.4 64-bit Linux (ASM)

Target: Oracle Database Enterprise 11.2.0.4 64-bit Linux (File System).

Step 1: Backup source database using RMAN

Step 2: Create pfile from Source DB

SQL> CREATE PFILE='/home/orekel/rmanBackup/initasem.ora' from spfile';

Note: The target has an Oracle instance (PROD) and we will drop it first ..

Shutdown first:

Step 3: Drop Existing DB on Target

Step 4: Copy Backup to Target Machine

Step 5: Extract Backup on Target

Step 6: Edit the pfile

Original pfile:

Edit to be:

Create directory:

$ mkdir -p /u01/app/orekel/admin/asem/adump
# mkdir -p /DATA/asem/datafile && mkdir -p /DATA/asem/onlinelog && chown orekel:oinstall -R /DATA/
# mkdir /ARC && chown -R orekel:oinstall /ARC

 Step 7: Startup Nomount

Setting the new environment first, such as ORACLE_SID. In this case I modified .bash_profile and compile it.

Step 8: Restore Controlfile

Step 9: Mount the Oracle Instance

Step 10: Catalog RMAN

We can see the backup:

Step 11: Restore the DB

output:

Step 12: Query the SCN to Recover

Step 13: Recover Set Until SCN

Step 14: Open Resetlogs

Step 15: Final Check

Step 16: Create spfile

done

Wassalamu’alaikum

by Aziz Prastyo Wibowo.

 

Advertisement