Steps to migrate database files from local disk/SAN to ASM :
First create ASM disks and diskgroup – here
Migrating all data (Datafiles, Controlfiles, logfiles) to DATA diskgroup.
Startup mount and restore SPFILE to ASM
SYS @ test > startup mount [[email protected] dbs]$ rman target / Recovery Manager: Release 188.8.131.52.0 - Production on Fri Feb 8 11:15:51 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST (DBID=2104987387, not open) RMAN> RESTORE SPFILE TO '+DATA/spfiletest.ora'; Starting restore at 08-FEB-17 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=18 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: restoring SPFILE output file name=+DATA/spfiletest.ora channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/dbs/01o1et80_1_1 channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/dbs/01o1et80_1_1 tag=TAG20130208T111407 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 Finished restore at 08-FEB-17
Copy and switch database files to ASM Read More