RMAN-07553 / RMAN-07554 - POST DATABASE UPGRADE TO 19C (Doc ID 2887420.1)

 RMAN-07553 / RMAN-07554 - POST DATABASE UPGRADE TO 19C

APPLIES TO:Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

getting warning message while executing delete obsolete


rman target /



RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF X DAYS;

RMAN> DELETE OBSOLETE;

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of X days

RMAN-07554: warning: CONTROL_FILE_RECORD_KEEP_TIME is too large (n days)

or

RMAN-07553: warning: RECOVERY WINDOW is more than CONTROL_FILE_RECORD_KEEP_TIME

In the above example, the parameter control_file_record_keep_time is set to n days which is greater than 30 (RMAN-07554) or recovery window is greater than CONTROL_FILE_RECORD_KEEP_TIME(RMAN-07553)
CHANGES

RMAN-07554 - Recovery catalog is not used and CONTROL_FILE_RECORD_KEEP_TIME is set to greater than 31

RMAN-07553 - Recovery catalog is not used and recovery window is greater than CONTROL_FILE_RECORD_KEEP_TIME

CAUSE


These warning messages are printed intentionally during report obsolete / delete obsolete commands which is expected to warn user if recovery window is > 31 days in nocatalog mode. Also, it warns
if control_file_record_keep_time is < recovery window in nocatalog mode.

SOLUTION

These warning messages are introduced to suggest user to use catalog db if control_file_record_keep is greater than 31 or control_file_record_keep_time is < recovery window. To avoid these warning messages, use recovery catalog or set the value for CONTROL_FILE_RECORD_KEEP_TIME to less than 31 for RMAN-07554 and set the value of control_file_record_keep_time greater than recovery window when recovery catalog is not used.