Skip to Content
avatar image
Former Member

Change rman backup retention

Hello everyone,

I am using rman backup with Oracle 11.2.0.3. I am trying to reduce the backup retention from 40 day to 22. I changed parameter "control_file_record_keep_time" both in DB and DB17. I also set expire_period to the same value in initSID.sap. When I run the backup, I get the following error:

BR0187E Value 22 of parameter/option 'control_file_record_keep_time' smaller than 30.

Does anyone know how to fix this?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 07, 2016 at 01:01 AM

    Hi Nader,

    As per SAP note 1888485 , more than 30 for control_file_record_keep_time is recommended value.
    So brtools follow this rule. it is not recommended to set 22.control_file_record_keep_time

    However if you really want to set it, you can adjust the check condition in:

    dbacockpit-> alerts -> check conditions, search for control_file_record_keep_time

    best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 01:00 PM

    Hi Nader

    Check the following :

    Thanks

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I checked it over again and still no go. I do not see any details in BRTools documentation about that either.