My Oracle Support Banner

EXACS:Datagaurd creation fails with error: 'CDG-50104 : DataGuard Configuration failed for <DBNAME>' (Doc ID 2904375.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Datagaurd creation fails with error - CDG-50104 : DataGuard Configuration failed for <DBNAME>

 

//From /var/opt/oracle/log/<DBNAME>/dgdeployer/dgdeployer_2022-10-17_10:01:03.377793145275.log

2022-10-17 10:09:02.702372 - RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
2022-10-17 10:09:02.702741 - cmd took 278.430857896805 seconds
2022-10-17 10:09:02.706353 - Output from cmd /bin/rm -f /var/opt/oracle/dbaas_acfs/<DBNAME>/299617.rman run on localhost is:
2022-10-17 10:09:02.744407 - cmd took 0.0377109050750732 seconds
2022-10-17 10:09:02.744682 - Interrupting child process monitoring restore progress: 12669
2022-10-17 10:09:02.744810 - restore process for database: <DBNAME> completed successful
2022-10-17 10:09:02.750176 - INFO: Restoring control file and missing datafiles before recover>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2022-10-17 10:09:02.765166 - Starting restore process for database: <DBNAME>
2022-10-17 10:09:02.765311 - Capturing SCN from old controlfile
2022-10-17 10:09:02.765601 - Output from sql select trim(current_scn) from v$database is:
2022-10-17 10:09:02.771077 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off prompt =START= select trim(current_scn) from v$database; quit
2022-10-17 10:09:03.257881 - 6450721441279

2022-10-17 10:11:14.874985 - RMAN script:
2022-10-17 10:11:14.875347 - Output from cmd /bin/cat /var/opt/oracle/dbaas_acfs/<DBNAME>/299617.rman run on localhost is:
2022-10-17 10:11:14.890062 - switch database to copy;
2022-10-17 10:11:14.890307 - cmd took 0.0144269466400146 seconds
2022-10-17 10:11:14.894086 - Output from cmd /bin/rm -f /var/opt/oracle/dbaas_acfs/<DBNAME>/299617.rman run on localhost is:
2022-10-17 10:11:14.940372 - cmd took 0.0458660125732422 seconds
2022-10-17 10:11:14.940899 -
CDG-50701 : Restore from service failed to restore control file of <DBNAME>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
RMAN> 2>
File: odg, Line#: 5584, Log: /var/opt/oracle/log/<DBNAME>/dgrops/dgrops_duplicate_db_service_2022-10-17_10:02:09.724058299617.log
2022-10-17 10:11:14.941687 -
CDG-50104 : DataGuard Configuration failed for <DBNAME>
ERROR: Failed restore control file before recover>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Control file restore failure before recover.

File: dgdb, Line#: 1878, Log: /var/opt/oracle/log/<DBNAME>/dgrops/dgrops_duplicate_db_service_2022-10-17_10:02:09.724058299617.log
2022-10-17 10:11:20.110717 - INFO: NO of retries = 1

2022-10-17 10:11:20.110917 - INFO: exec_on_node end:

2022-10-17 10:11:20.111394 -
CDG-50102 : <DBNAME> Database not ready for DG Configuration>>>>>>>>>>>>>>>>>>>>>>>>>>>
ERROR: Error in creation of standby database>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Standby DB error.
File: dgdeployer, Line#: 204, Log: /var/opt/oracle/log/<DBNAME>/dgdeployer/dgdeployer_2022-10-17_10:01:03.377793145275.log

 

//From rman_restore_recover_299617.log,Can you please check whether the primary is intact or not?

datafile 9 not processed because file is offline

channel C8: specifying datafile(s) to restore from backup set
channel C8: restoring datafile 00008 to +DATAC1/<DBNAME>_FK/DATAFILE/undotbs3.3006.1118311537>>>>>>>>>>>>>>>>>>>>>>>>>After Datafile#8,went to 13
channel C8: restoring section 1 of 1
channel C1: restore complete, elapsed time: 00:00:17
channel C1: starting datafile backup set restore
channel C1: using network backup set from service <DBNAME>_MI
channel C1: specifying datafile(s) to restore from backup set
channel C1: restoring datafile 00013 to +DATAC1/<DBNAME>_FK/658E1D34E7B850D3E0538D808C0A5A38/DATAFILE/system.3020.1118311539>>>>>>>>>>>>>>>>>>>>>>>Datafile#13
channel C1: restoring section 1 of 1
channel C2: restore complete, elapsed time: 00:00:18
channel C2: starting datafile backup set restore
channel C2: using network backup set from service <DBNAME>_MI
channel C2: specifying datafile(s) to restore from backup set
channel C2: restoring datafile 00014 to +DATAC1/<DBNAME>_FK/658E1D34E7B

released channel: C8

Recovery Manager complete.

Recovery Manager: Release 12.2.0.1.0 - Production on Mon Oct 17 10:11:06 2022

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: <DBNAME> (DBID=1396773581, not open)

RMAN> switch database to copy;
2>
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 10/17/2022 10:11:14
RMAN-06571: datafile 9 does not have recoverable copy

 

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
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.