since we installed the SP23 Hotfix 7 on our commserve we have the following problem.
After wie make a “Database Online Full Snap” on our Oracle-ASM DB (Linux-Server) the Snap-Job delete the SPfile. No chance to restart the DB.
Best answer by Shane S
Can you confirm if it is the SPfile that is created before taking snapshot that is deleted upon completion of the backup, or is the backup process deleting the SPfile used to start the database?
There was a patch in 11.22 (Update 139414) to automatically cleanup the SPfile that was created during the snap backup.
To prevent cleanup of the SPfile, you can configure the below additional setting on the Oracle client.
Name = DELETE_SPFILE_CTRLFILE_COPY
Category = OracleAgent
Type = String
Value = N
Let us know if this helps.