show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- -------------------
spfile string +DATA/AGAP/PARAMETERFILE/spfil
To backup the spfile e.272.954841567
create pfile='$ORACLE_HOME/dbs/initagap.ora.migratation.bck' from spfile;
To stop database to avoid the cluster starting the database automatically
srvctl stop database -d agap
To start up one instance
sqlplus / as sysdba
startup nomount
To restore controlfile from +DATA to +DATA_GRUP
rman target /
restore controlfile to '+DATA_GRUP' from '+DATA/AGAP/CONTROLFILE/current.256.954836893';
restore controlfile to '+DATA_GRUP' from '+DATA/AGAP/CONTROLFILE/current.257.954836893';
If you have been use OMF for creating location within ASM you must to check
asmcmd ls -l +DATA_GRUP/AGAP/CONTROLFILE
Type Redund Striped Time Sys Name
CONTROLFILE UNPROT FINE SEP 21 18:00:00 Y none => current.265.955304607
CONTROLFILE UNPROT FINE SEP 21 18:00:00 Y none => current.266.955304615
To set up control_files parameter with new location
alter system set control_files='+DATA_GRUP/AGAP/CONTROLFILE/current.265.955304607','+DATA_GRUP/AGAP/CONTROLFILE/current.266.955304615' scope=spfile;
shutdown instance
shutdown immediate
exit
Startup database
sqlplus / as sysdba
startup
or for RAC or Oracle restart
srvctl start database -d agap
To check the result
show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- -------------------
control_files string +DATA_GRUP/AGAP/CONTROLFILE/cu
rrent.265.955304607, +DATA_GRU
P/AGAP/CONTROLFILE/current.266.955304615
