Here in this article, We will provide detailed steps for converting a non-asm instance to an asm-instance. 

Prerequisites:

1. Oracle cluster  need to be installed on that server( for ASM) 

2. Create required asm disk groups.

EXAMPLE:

Currrently the datafiles are in /u02 mount point. We will move them to ASM DISK GROUP +TEST_DG’.

Database Name: DEVDBA

Asm disk group: +TEST_DG’

 

First move the controlfile to ASM disk

 

 

MOVE DATAFILE TO ASM:

 

Once files are copied to ASM , switch database

 

MOVE REDOLOGS TO ASM:

 

 

MODIFY THE PFILE POINTING TO SPFILE:

 

 

MOVING THE TEMP FILE: