We have a 3 node RAC on Redhat Linux 2.6.18-92.1.18.el5. After a media problem we cannot start them with svrctl. Got error
[grid@cchORdb2 ~]$ srvctl start database -d cchprd
PRCR-1079 : Failed to start resource ora.cchprd.db
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
I can start individual instance with sqlplus and find out that in one of the instance the db_recovery_file_dest_size parameter differ from the other and its spfile parameter is different from the other. That is the problematic instance somehow use a different local spfile, while the other 2 instances used the shared spfile. I tried to use alter system to change the parameter but all failed
SQL> alter system set spfile='+DATA/cchprd/spfilecchprd.ora' scope=both;
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.
SQL> alter system set spfile='+DATA/cchprd/spfilecchprd.ora'
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.
SQL> alter system set spfile='+DATA/cchprd/spfilecchprd.ora' scope=memory;
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-32030: an SPFILE is already associated with the instance
How can I set this parameter correctly? v$parameter view tells me that parameter spfile is modifiable
SQL> select name,isdefault,ISSES_MODIFIABLE,ISSYS_MODIFIABLE,ISINSTANCE_MODIFIABLE,ISMODIFIED from v$parameter where name='spfile';
NAME ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED
---------------------- --------- ----- --------- ----- ----------
spfile TRUE FALSE IMMEDIATE TRUE FALSE