migrate a database to ASM

1. SQL>alter system set db_create_file_dest=’+DATA’ scope=spfile;
SQL>alter system set control_file=’’ scope=spfile;
2. SQL>shutdown immediate;
3. SQL>startup nomount;
4. RMAN>restore controlfile from ‘/u01/ORCL/control01.ctl’;
5. SQL>alter database mount;
6. RMAN>backup as copy database format ‘+DATA’;
7. RMAN>switch database to copy;
8. RMAN>recover database;
9. SQL>alter database open;
10. SQL>alter database tempfile ‘/u01/ORCL/temp1.dbf’ DROP;
SQL>alter tablespace temp add tempfile;