My Oracle Support Banner

Dataguard association fails with 'ORA-38706: Cannot turn on FLASHBACK DATABASE logging.' (Doc ID 2785129.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Information in this document applies to any platform.

Symptoms

Datagaurd association fails with the following error on standby side.

 

2021-06-14 20:14:11.883830 - sql execution failed:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38788: More standby database recovery is needed2021-06-14 20:14:11.884567 - Could not enable flashback - please check db Error: $VAR1 = [
          'ORA-38706: Cannot turn on FLASHBACK DATABASE logging.',
          'ORA-38788: More standby database recovery is needed'
        ];
2021-06-14 20:14:11.884935 -
CDG-50711 : Failed enable flashback after restore from service   <<<<

dgdeployer_2021-06-14_16:32:22.765264231843.log shows

 


2021-06-14 19:55:59.398283 - Output from cmd /u02/app/oracle/product/19.0.0.0/dbhome_3/bin/rman target sys/******** @/var/opt/oracle/dbaas_acfs/RMXYZ4P/235495.rman run on localhost is:
2021-06-14 20:05:12.806124 -
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jun 14 19:55:59 2021
Version 19.8.0.0.0
......
10> recover database from service 'RMXYZ4P_iad2dc' section size 64G; <<<<
11> }
12>

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.