Recently we found that, one of our asm instance was using a different spfile. So used below steps to change the spfile. existing spfile – > /u01/app/grid/dbs/asmbackup.ora new spfile ...
spfile
How to restore lost spfile in oracle
What if you lost both spfile and pfile of the instance when it is up and running. Suppose you don’t have any type of rman or autobackup also. How can you restore that. Let’s see the below ...
ORA-32001: write to SPFILE requested but no SPFILE is in use
PROBLEM: While altering parameter in parameter file got below error. ALTER SYSTEM SET processes = 900 SCOPE=SPFILE; ALTER SYSTEM SET processes = 900 SCOPE=SPFILE * ERROR at line 1: ORA-32001: write to...