recreate spfile from pfile in asm location and conffigure srvctl

create pfile from spfile='+DATA_DG/SHODS/PARAMETERFILE/spfile.284.889287671';

Once pfile is created startup database with pfile

startup database pfile='xxxxxxxx';


once it starts up

go to asm instance

my case +ASM1

data_dg/shods/parameterfile/

rm spfile.284.889287671

sql> create spfile='+DATA_DG' from pfile;

shutdown


Go to ASM instance

data_dg/shods/parameterfile/

Note the new name of spfile (spfile.284.899043351)

Goto oracle_home/dbs

take a backup of existing pfile before you make any change

after that edit pfile

delete all contents and put spfile location in it

SPFILE='+DATA_DG/SHODS/PARAMETERFILE/spfile.284.899043351'

sqlplus > startup

show parameter spfile;

It should show new spfile location.

After that register spfile in srvctl

First check config

srvctl config database -d shods

Database unique name: SHODS

Database name: SHODS

Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_1

Oracle user: oracle

Spfile: +DATA_DG/SHODS/PARAMETERFILE/spfile.284.899043351

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: SHODS

Database instances: SHODS1,SHODS2

Disk Groups: DATA_DG,RECO_DG

Mount point paths:

Services:

Type: RAC

Database is administrator managed

Now point it to new spfile

srvctl modify db -d shods -p '+DATA_DG/SHODS/PARAMETERFILE/spfile.284.899043351'

Now you should be able to start db with srvctl