Migrate non-ASM to ASM

1. Note the filenames of the control files and online redo log files
2. Shutdown the database using NORMAL, IMMEDIATE or TRANSACTIONAL keywords
3. Backup the database
4. Edit the SPFILE to use OMF for all file destinations
5. Edit the SPFILE to remove the CONTROL_FILE parameter
6. Run the following RMAN script:

RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM controlfile_location
RMAN> ALTER DATABASE MOUNT;
RMAN> BACKUP AS COPY DATABASE FORMAT '+diskgroup_destination';
RMAN> SWITCH DATABASE TO COPY;
RMAN> SQL ALTER DATABASE RENAME logfile TO '+diskgroup_destination';
RMAN> ALTER DATABASE OPEN RESETLOGS;

7. Delete or archive the old dtaabase files;

---

NOTES:
SBT - System Backup Tape
CTWR - Change Tracking Writer
RVWR - Recover Log Writer
RMAN - Recovery Manager
ASM - Automatic Storage Management
ADDM - Automatic Database Diagnostic Management
MML - Memony Monitoring Light process
MON - Memony Managaibility Monitoring process
MML- Media Management Layer