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

01BackupSource

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 ..

01InfoTarget

Shutdown first:

02ShutdownInstanceTarget


Step 3: Drop Existing DB on Target

03DropDBTarget


Step 4: Copy Backup to Target Machine

04scpBackuptoTarget


Step 5: Extract Backup on Target

05ExtractBackuptoTarget


Step 6: Edit the pfile

Original pfile:

06initasem_original.ora

Edit to be:

07initasem.ora

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.

08StartupNomount


Step 8: Restore Controlfile

09RestoreControlfile


Step 9: Mount the Oracle Instance

10MountDB


Step 10: Catalog RMAN

11CatalogRMAN

We can see the backup:

12ListBackupSummary


Step 11: Restore the DB

13RestoreScript

output:

13RestoreLog


Step 12: Query the SCN to Recover

14QuerySCN


Step 13: Recover Set Until SCN

15SetUntilRecover


Step 14: Open Resetlogs

16OpenResetlogs


Step 15: Final Check

17Finish


Step 16: Create spfile

18Createspfile


done


Wassalamu’alaikum

by Aziz Prastyo Wibowo.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s