Database Migration to ASM

Database Migration to ASM
Since ASM files can not be accessed via the operating system, we need to use the RMAN to move database objects from a non-ASM disk location to an ASM disk group.
Following are the steps to move objects:-
1. Note the filenames of the control files and the online redo log files.
2. Shut down the database NORMAL, IMMEDIATE or TRANSACTIONAL.
3. Backup the database.
4. Edit the SPFILE to use OMF for all the file destinations.
5. Edit the SPFILE to remove the CONTROL_FILES parameter.
6. Run the following RMAN script, substituting your specific filenames as needed:-

STARTUP NOMOUNT;
RESTORE CONTROLFILE FROM '';
ALTER DATABASE MOUNT;
BACKUP AS COPY DATABASE FORMAT '+disk group destination';
SWITCH DATABASE TO COPY;
SQL "ALTER DATABASE RENAME TO '+disk group destination>' ";
ALTER DATABASE OPEN RESETLOGS;
Delete or archive the old database files.