BR0187E: parameter/option 'control_file_record_keep_time' smaller than 180

279 Views

Hi All,

This is our infrastructure:

SAP ECC 6

Oracle 10.2

Windows 2003 Server

Legato Networker 7

Since we need to implement an incremental backup strategy. we changed manually our initSID.sap file backup_mode parameter from ALL to FULL in our DEV and QA since that moment the backups crashed immediate (remenber that you need a FULL backup if you want to run IMCREMENTAL backups).

Error:

DEV System:

BR0477I Oracle pfile E:\oracle\MID\102\database\initMID.ora created from spfile E:\oracle\MID\102\database\spfileMID.ora

BR0187E Value '30' of parameter/option 'control_file_record_keep_time' smaller than 180

BR0158E Error reading database profile E:\oracle\MID\102\database\initMID.ora

QA System:

BR0477I Oracle pfile E:\oracle\MIQ\102\database\initMIQ.ora created from spfile E:\oracle\MIQ\102\database\spfileMIQ.ora

BR0187E Value '30' of parameter/option 'control_file_record_keep_time' smaller than 60

BR0158E Error reading database profile E:\oracle\MID\102\database\initMID.ora

We rollback the change in the backup_mode parameter and the backup run without problems, so it appears that we didn't change the backup_mode parameter in the correct way.

What is the correct way to do this?

Best Regards,

Erick ILarraza