ORA-45159: RECOVERY_WINDOW_GOAL is lost for database <Instance

Asset ID:	1-72-2387256.1
Update Date:	2018-05-15
Keywords:

Solution Type Problem Resolution Sure

Solution 2387256.1 : ORA-45159: RECOVERY_WINDOW_GOAL is lost for database

Applies to:

Zero Data Loss Recovery Appliance X5 Hardware - Version All Versions and later
Information in this document applies to any platform.

Symptoms

ORA-45159: RECOVERY_WINDOW_GOAL is lost for database <Instance_name>

Issue is caused because ZDLRA hasn't received archived redo log.

Example)
At that specific time the ZDLRA hadn't received a backup of thread#1 logseq# 13474,
- this broke the restore range and the warning is completely valid and as designed.

- Execute by rasys user
SQL> SELECT *
FROM (
SELECT thread#, sequence#, low_time, next_time
FROM brl
WHERE thread#=1
ORDER BY low_time DESC)
WHERE rownum <= 5
ORDER BY rownum DESC;

THREAD# SEQUENCE# LOW_TIME NEXT_TIME
---------- ---------- -------------------- --------------------
1 13470 17-JAN-2018 05:14:26 17-JAN-2018 05:21:11
1 13471 17-JAN-2018 05:21:11 17-JAN-2018 05:32:12
1 13472 17-JAN-2018 05:32:12 17-JAN-2018 08:33:05
1 13473 17-JAN-2018 08:33:05 17-JAN-2018 08:46:38 <<<
1 13475 17-JAN-2018 18:08:01 17-JAN-2018 18:26:07 <<<

Changes

Cause

This is expected behavior from ZDLRA point of view.

This is adressed in Bug:26771239.

Solution

If subsequently the archived redo log is backed up to the RA,
the range is complete again and the warning is no longer active.

Therefore if the status of ORA-45159 is FIXED in ra_incident_log,

this warning can be ignored.

References

<BUG:26771239> - ORA-45159 OCCURS FREQUENTLY
<NOTE:2154189.1> - SRDC - Zero Data Loss Recovery Appliance (ZDLRA) Data Collection
<NOTE:2275176.1> - Zero Data Loss Recovery Appliance System Activity Script

Attachments

This solution has no attachment