ORA-38754 FRA space pressure deleted archivelog required for guaranteed restore point

(Doc ID 2396155.1)

Last updated on MAY 10, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2 BETA1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Tried to flashback a database to a guaranteed restore point and got the following error:

RMAN> flashback database to restore point GRP_EUPP_PROD;

Starting flashback at 26-MAR-2018 12:03:14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
...

starting media recovery
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of flashback command at 03/26/2018 12:07:07
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 3 with sequence 53590 and starting SCN of 37182601188 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 53638 and starting SCN of 37182601185 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 53858 and starting SCN of 37182601191 found to restore

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