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

(Doc ID 2387256.1)

Last updated on MAY 15, 2018

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms