--View the current library file location
Sql> select name from V$datafile
2 Union
3 Select member from V$logfile
4 Union
5 Select name from V$controlfile
6 Union
7 select name from V$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/oradata/tos/control01.ctl
/u01/oradata/tos/control02.ctl
/u01/oradata/tos/control03.ctl
/u01/oradata/tos/example01.dbf
/u01/oradata/tos/redo01.log
/u01/oradata/tos/redo02.log
/u01/oradata/tos/redo03.log
/u01/oradata/tos/sysaux01.dbf
/u01/oradata/tos/system01.dbf
/u01/oradata/tos/temp01.dbf
/u01/oradata/tos/undotbs01.dbf
/u01/oradata/tos/users01.dbf
/u01/oradata/tos/xff01.dbf
/u01/oradata/tos/xff02.dbf
Rows selected.
--Backup control files
sql> ALTER DATABASE backup Controlfile to '/u01/control.ctl ';
Database altered.
--Modify the control file in SPFile to ASM
Sql> alter system set control_files= ' +data ' scope=spfile;
System altered.
--Modify Db_recovery_file_dest to ASM
Sql> alter system set db_recovery_file_dest= ' +flashback ';
System altered.
--Modify the archive log to ASM
Sql> alter system set log_archive_dest_1= ' Location=+data ';
System altered.
--Close the database
sql> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.