Oracle Tutorial: How to migrate a common library to ASM storage

--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.