Oracle RMAN backups fails with RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE.
To solve this I have to create spfile using create spfile from pfile or create spfile from memory. Then the database must be shutdown and started using the spfile.
Running show parameter spfile on sqlplus shows the value as empty even after the spfile is created but the database has not been restarted, but after shutting down the database and starting up using spfile the value shows the spfile path.
The RMAN command BACKUP AS COPY spfile works fine....
My Question is can we Backup spfile without a shutting down and starting the database using spfile?
Is it possible to set the spfile parameter value post file creation will doing so allow RMAN to backup spfile even when the database is not started using the same?
If setting the value is possible will it cause any issues for the database?
(I am aware that spfile is the recommended way but well some people use pfile )