Login to the first node
column is_recovery_dest_file format a25
column name format a60
set linesize 160
select status, name, is_recovery_dest_file from v$controlfile;
check the control file status and names using the above quey,
i my case i had
STATUS NAME IS_RECOVERY_DEST_FILE
------- ------------------------------------------------------------ -------------------------
+DATA_RAJ/rajesh/controlfile/current.986.790135655 NO
hence ,
login in to sqlplus , and alter the system as below with your new place pointed to
alter system set control_files = '+DATA_RAJ/rajesh/controlfile/current.986.790135655','+RECO_RAJ' scope=spfile sid='*';
in my case i have the data and reco groups created on the asm, hence trying to place the controlfiles in to two different disk groups.
once alterd the system , shutdown the instance using srvctl
srvctl stop database -d xxx
after then , login to sql prmpt and startup the instance in no mount stage , once the db came up on nomount stage exit from the sql prompt and login in rman prompt
example
rman
connect target
restore controlfile from '+DATA_RAJ/rajesh/controlfile/current.986.790135655';
it will restore/multiplex our control file to the existing and our new path. once the restore complete, shutdown the instances and startup normal
it should come up with the two controlfiles,
issues i was facing here were, one of the instance spfile was not on the shared drive hence i was failing on the below command
alter system set control_files = '+DATA_RAJ/rajesh/controlfile/current.986.790135655','+RECO_RAJ' scope=spfile sid='*';
as spfile could not be modifiable etc ... after which i have mounted the spfile on the shared drive and followed the same
Good Luck !!
Thanks
