Upgrading to Oracle 12c - Expert Consolidation in Oracle Database 12c - page 447

will be sufficient. What remains to be done is the move of the server parameter file into ASM, followed by the control
file, then the online redo logs at last. The previously taken backup of the server parameter file is the first to be migrated
into ASM:

RMAN> startup mount;
[...]
RMAN> restore spfile to '+DATA/CDB2/spfileCDB2.ora';

Starting restore at 15.08.2013 18:01
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=237 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring SPFILE
output file name=+DATA/CDB2/spfileCDB2.ora
channel ORA_DISK_1: reading from backup piece 
/u01/fra/CDB2/autobackup/2013_08_15/o1_mf_s_823542889_90t1yso5_.bkp
channel ORA_DISK_1: piece handle=/u01/fra/CDB2/autobackup/2013_08_15/o1_mf_s_823542889_90t1yso5_.bkp 
tag=TAG20130815T175449
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 15.08.2013 18:01

To ensure that Oracle can make use of the spfile you should update the database definition in Oracle Restart to
point to the spfile:

[oracle@server1 dbs]$ srvctl config database -db CDB2 | grep -i spfile
Spfile:
[oracle@server1 dbs]$ srvctl modify database -db CDB2 -spfile '+DATA/CDB2/spfileCDB2.ora'
[oracle@server1 dbs]$ srvctl config database -db CDB2 | grep -i spfile
Spfile: +DATA/CDB2/spfileCDB2.ora

The old server parameter file in the $ORACLE_HOME/dbs directory should be renamed-a server parameter
file in the default location will most likely be chosen first when starting the database, and you want it to use the
spfile in ASM.
Restart the instance to force the use of the new spfile. To instruct the database to use the ASM disk groups from
now on rather than the file system, you need to update the following initialization parameters related to Oracle
Managed Files:

• db_create_file_dest

• db_recovery_file_dest_size (if a FRA was not in use previously)

• db_recovery_file_dest

• db_create_online_log_dest_n (optional)

In addition the control file needs to be restored into ASM, so while you are setting the OMF parameters you might
as well change “control_files.” This can all be done in RMAN or SQL*Plus using the following examples:

RMAN> alter system set db_create_file_dest='+DATA';

Statement processed