OCI: Automatic Backup Failed With DCS-10013 :'OMF PARAMETERS' CONTAINS UNACCEPTABLE VALUE


Error:

When running the automatic backup from OCI, it was failing. When checked further below error was seen.

"status" : "Failure",
"message" : "DCS-10013:Input parameter 'OMF parameters' contains unacceptable value : {1} .OMF parameter value found as null in Database",
"reports" : [ {


More details can be captured from DBCS system below commands or dcs agent logs.

# /opt/oracle/dcs/bin/dbcli list-jobs | grep 'Failure'

#/opt/oracle/dcs/bin/dbcli describe-job -i 01279373-2649-499f-8d8]6-c5811221504


Reasons for Failure

Check below parameters in database and make sure there values are set properly.

Do show parameter and check these parameter values.

SPFILE
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_1
DB_RECOVERY_FILE_DEST


Solution:

In my case the spfile was fine but other three I needed to set



SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ----------------------
spfile string +DATA/ORCL/PARAMETERFILE/spfileprod.ora


ALTER SYSTEM SET DB_CREATE_FILE_DEST='+DATA' SCOPE =BOTH;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1='+RECO' SCOPE=BOTH;
alter system set db_recovery_file_dest_size=10G;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+RECO' SCOPE=BOTH;

Re-run Automatic backup from OCI, it should be successful.



If you like please follow and comment