Oracle 19C : Exporting and Importing Broker Configuration

Oracle 19C : Exporting and Importing Broker Configuration

Oracle 19C : Exporting and Importing Broker Configuration


dgmgrl   EXPORT CONFIGURATION


[oracle@oracentd19c ~]$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue May 5 08:06:17 2026
Version 19.31.0.0.0

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

Welcome to DGMGRL, type "help" for information.
Connected to "orcl_stdy"
Connected as SYSDG.
DGMGRL> EXPORT CONFIGURATION TO anujdgmgrl_config.txt
Succeeded.
DGMGRL>


in trace dir


[oracle@oracentd19c trace]$ pwd
/u01/app/oracle/diag/rdbms/orcl_stdy/orcls/trace



[oracle@oracentd19c trace]$ ls -ltr anuj*
-rw-r--r--. 1 oracle oinstall 5490 Jan  6  2024 anuj_dg_config.txt
[oracle@oracentd19c trace]$ ls -ltr *.txt
-rw-r--r--. 1 oracle oinstall 5490 Jan  6  2024 anuj_dg_config.txt
[oracle@oracentd19c trace]$


[oracle@oracentd19c trace]$ cat anuj_dg_config.txt
<?xml version="1.0" encoding="UTF-8"?>
<DRC Version="19.3.0.0.0" CurrentPath="True" Name="DG_CONF">
  <DefaultState>ONLINE</DefaultState>
  <DRC_UNIQUE_ID>1306264893</DRC_UNIQUE_ID>
  <FastStartFailoverOBID1>688061044</FastStartFailoverOBID1>
  <FastStartFailoverOBID2>688061045</FastStartFailoverOBID2>
  <FastStartFailoverOBID3>688061046</FastStartFailoverOBID3>
  <Configuration_Name>DG_CONF</Configuration_Name>
  <Member MemberID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" Name="orcl">
    <IntendedState>PRIMARY</IntendedState>
    <DefaultState>PRIMARY</DefaultState>
    <Status>
      <Severity>Failure</Severity>
      <Error>12541</Error>
      <Timestamp>1704554000</Timestamp>
    </Status>
    <StandbyType>PhysicalStandby</StandbyType>
    <DGConnectIdentifier>orclprim</DGConnectIdentifier>
    <DbDomain/>
    <ResourceType>Database</ResourceType>
    <Instance InstanceID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" DefaultWriteOnce="True" Name="orcl">
      <PlannedState/>
      <HostName Default="True">oracent19c</HostName>
      <InstanceName>orcl</InstanceName>
      <Status>
        <Severity>Success</Severity>
        <Error>0</Error>
        <Timestamp>1696320778</Timestamp>
      </Status>
      <StaticConnectIdentifier>orclstdy</StaticConnectIdentifier>
    </Instance>
    <Role>
      <Condition>PRIMARY</Condition>
      <DefaultState>READ-WRITE-XPTON</DefaultState>
      <IntendedState>READ-WRITE-XPTON</IntendedState>
    </Role>
    <Role>
      <Condition>STANDBY</Condition>
      <DefaultState>PHYSICAL-APPLY-ON</DefaultState>
      <IntendedState>OFFLINE</IntendedState>
    </Role>
    <DB_Unique_Name>orcl</DB_Unique_Name>
    <ClusterDatabase>FALSE</ClusterDatabase>
    <LogXptMode Default="True">ASYNC</LogXptMode>
    <IncarnationTable>2,1920977,1145033651,1*1,1,1005785759,0#</IncarnationTable>
    <SRLStatus>1</SRLStatus>
    <CurrentRole>PRIMARY</CurrentRole>
    <PlannedState/>
    <FastStartFailoverTarget>orcl_stdy</FastStartFailoverTarget>
    <DbChangeCritical>FALSE</DbChangeCritical>
    <DbIsCritical>FALSE</DbIsCritical>
    <ActualApplyInstance/>
  </Member>
  <Status>
    <Severity>Warning</Severity>
    <Error>16607</Error>
    <Timestamp>1704554057</Timestamp>
  </Status>
  <DRC_UNIQUE_ID_SEQUENCE>2</DRC_UNIQUE_ID_SEQUENCE>
  <ConfigurationWideServiceName>orcl_CFG</ConfigurationWideServiceName>
  <OVERALL_PROTECTION_MODE>3</OVERALL_PROTECTION_MODE>
  <FastStartFailoverLagLimit Default="True">30</FastStartFailoverLagLimit>
  <IntendedState>ONLINE</IntendedState>
  <Member MemberID="2" CurrentPath="True" Enabled="True" MultiInstanced="True" Name="orcl_stdy">
    <PlannedState>STANDBY</PlannedState>
    <DefaultState>STANDBY</DefaultState>
    <Status>
      <Severity>Success</Severity>
      <Error>0</Error>
      <Timestamp>1704555032</Timestamp>
    </Status>
    <StandbyType>PhysicalStandby</StandbyType>
    <DGConnectIdentifier>orcldstdy</DGConnectIdentifier>
    <DbDomain/>
    <ResourceType>Database</ResourceType>
    <Instance InstanceID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" DefaultWriteOnce="True" Name="orcls">
      <PlannedState/>
      <HostName Default="True">oracentd19c</HostName>
      <InstanceName>orcls</InstanceName>
      <StaticConnectIdentifier>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.56)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls_DGMGRL)(SID=orcls)(SERVER=DEDICATED)))</StaticConnectIdentifier>
      <Status>
        <Severity>Success</Severity>
        <Error>0</Error>
        <Timestamp>1704555032</Timestamp>
      </Status>
    </Instance>
    <Role>
      <Condition>PRIMARY</Condition>
      <DefaultState>READ-WRITE-XPTON</DefaultState>
      <IntendedState>OFFLINE</IntendedState>
    </Role>
    <Role>
      <Condition>STANDBY</Condition>
      <DefaultState>PHYSICAL-APPLY-ON</DefaultState>
      <IntendedState>PHYSICAL-APPLY-ON</IntendedState>
    </Role>
    <DB_Unique_Name>orcl_stdy</DB_Unique_Name>
    <ClusterDatabase>FALSE</ClusterDatabase>
    <LogXptMode Default="True">ASYNC</LogXptMode>
    <IncarnationTable>2,1920977,1145033651,1*1,1,1005785759,0#</IncarnationTable>
    <SRLStatus>2</SRLStatus>
    <IntendedState>STANDBY</IntendedState>
    <CurrentRole>STANDBY</CurrentRole>
    <DbIsCritical>FALSE</DbIsCritical>
    <FastStartFailoverTarget>orcl</FastStartFailoverTarget>
    <DbChangeCritical>FALSE</DbChangeCritical>
    <DelayMins>0</DelayMins>
    <ActualApplyInstance>orcls</ActualApplyInstance>
  </Member>
  <ObserverInfo1>localhost.localdomain</ObserverInfo1>
  <ObserverInfo2>oracentd19c</ObserverInfo2>
  <ObserverName1>localhost.localdomain</ObserverName1>
  <ObserverVersion1>386007040</ObserverVersion1>
  <FSFO_MIV>4</FSFO_MIV>
  <ObserverName2>oracentd19c</ObserverName2>
  <ObserverVersion2>318963712</ObserverVersion2>
  <FastStartFailoverMode>0</FastStartFailoverMode>
  <EXT_COND>7</EXT_COND>
  <RoleChangeHistory>
    <RoleChangeRecord>
      <Event>PhysicalSwitchover</Event>
      <OldPrimary>orcl</OldPrimary>
      <NewPrimary>orcl_stdy</NewPrimary>
      <Status>0</Status>
      <Timestamp>1149239579</Timestamp>
    </RoleChangeRecord>
    <RoleChangeRecord>
      <Event>PhysicalSwitchover</Event>
      <OldPrimary>orcl_stdy</OldPrimary>
      <NewPrimary>orcl</NewPrimary>
      <Status>0</Status>
      <Timestamp>1149241834</Timestamp>
    </RoleChangeRecord>
  </RoleChangeHistory>
  <MIV>0</MIV>
  <PRIMARY_SITE_ID>513</PRIMARY_SITE_ID>
</DRC>
[oracle@oracentd19c trace]$




==================================



[oracle@oracentd19c trace]$ ls -ltr *.txt
-rw-r--r--. 1 oracle oinstall 5490 Jan  6  2024 anuj_dg_config.txt


DGMGRL> IMPORT CONFIGURATION FROM anuj_dg_config.txt

ORA-16629: database reports a different protection level from the protection mode

ORA-16629: database reports a different protection level from the protection mode

DGMGRL> show configuration ;

Configuration - DG_CONF

  Protection Mode: MaxAvailability  <<<<<<----
  Members:
  orcl_stdy - Primary database
    Warning: ORA-16629: database reports a different protection level from the protection mode

    orcl      - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
WARNING   (status updated 55 seconds ago)


standby 

SQL> select protection_mode,protection_level from v$database;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE


primary 


[-PRIMARY-]sys@orcl_stdy> select protection_mode,protection_level from v$database;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY RESYNCHRONIZATION  <<<<< 



DGMGRL> edit configuration set protection mode as MAXPERFORMANCE;
Succeeded.




DGMGRL> show configuration ;

Configuration - DG_CONF

  Protection Mode: MaxPerformance
  Members:
  orcl_stdy - Primary database
    Warning: ORA-16629: database reports a different protection level from the protection mode

    orcl      - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
WARNING   (status updated 59 seconds ago)





after some time ..

DGMGRL> show configuration ;

Configuration - DG_CONF

  Protection Mode: MaxPerformance
  Members:
  orcl_stdy - Primary database
    orcl      - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 58 seconds ago)

DGMGRL>