+1Hello,
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.
Why ?
Regards
Chris
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.
+23Hey
Does the job show any error messages?
I’d like to see what I can find in our database if you can share some details, error messages, logs, etc.
For the log files we need ClOraAgent.log on the client with debug level 6 (at least) and backup rman log.
Thanks!
+2Can 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.
+1Hello,
many thanks to you
Now the spfile and the galaxy-files don't be deleted.
But I think it will be better if those new settings will communicated on a new patch-level.
For our RAC Agent I set this on the physical nodes, right ?
Note: In a cluster environment, you must specify the additional settings on the physical nodes (the client computers), not on the cluster server. For more information, see Configuring Additional Settings in a Cluster Environment.
many regards
chris
+2Excellent, glad to hear that did the trick! And yes, you would configure an additional setting on the properties of each of the physical nodes in the case of a RAC.
As far as I understand, however, this specific setting should NOT be required as the original SPfile to start the database and the copy of SPfile created during the snap backup should be in separate locations.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
