dg broke导入导出配置信息

目录

• 导出
• 导入

导出

[oracle@db1 ~]$ dgmgrl sys/Oracle123
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Feb 10 10:05:28 2025
Version 19.3.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"
Connected as SYSDBA.
DGMGRL> EXPORT CONFIGURATION TO 'oracledbwr.txt'
Succeeded.


[oracle@db1 ~]$ cat /u01/app/oracle/diag/rdbms/orcl/orcl/trace/oracledbwr.txt
<?xml version="1.0" encoding="UTF-8"?>
<DRC Version="19.3.0.0.0" CurrentPath="True" Name="my_dg_config">
  <DefaultState>ONLINE</DefaultState>
  <DRC_UNIQUE_ID>1438592050</DRC_UNIQUE_ID>
  <IntendedState>ONLINE</IntendedState>
  <FastStartFailoverOBID1>354967671</FastStartFailoverOBID1>
  <FastStartFailoverOBID2>354967672</FastStartFailoverOBID2>
  <FastStartFailoverOBID3>354967673</FastStartFailoverOBID3>
  <Configuration_Name>my_dg_config</Configuration_Name>
  <Member MemberID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" Name="orcl">
    <IntendedState>PRIMARY</IntendedState>
    <DefaultState>PRIMARY</DefaultState>
    <Status>
      <Severity>Success</Severity>
      <Error>0</Error>
      <Timestamp>1739153145</Timestamp>
    </Status>
    <StandbyType>PhysicalStandby</StandbyType>
    <DGConnectIdentifier>orcl</DGConnectIdentifier>
    <DbDomain/>
    <ResourceType>Database</ResourceType>
    <Instance InstanceID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" DefaultWriteOnce="True" Name="orcl">
      <PlannedState/>
      <HostName Default="True">db1</HostName>
      <StaticConnectIdentifier Default="True">(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))</StaticConnectIdentifier>
      <InstanceName>orcl</InstanceName>
      <Status>
        <Severity>Success</Severity>
        <Error>0</Error>
        <Timestamp>1739153145</Timestamp>
      </Status>
    </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,1189179698,1*1,1,1005785759,0#</IncarnationTable>
    <SRLStatus>1</SRLStatus>
    <CurrentRole>PRIMARY</CurrentRole>
    <PlannedState/>
  </Member>
  <Status>
    <Severity>Success</Severity>
    <Error>0</Error>
    <Timestamp>1739153145</Timestamp>
  </Status>
  <PRIMARY_SITE_ID>65281</PRIMARY_SITE_ID>
  <ConfigurationWideServiceName>orcl_CFG</ConfigurationWideServiceName>
  <OVERALL_PROTECTION_MODE>3</OVERALL_PROTECTION_MODE>
  <FastStartFailoverLagLimit Default="True">30</FastStartFailoverLagLimit>
  <Member MemberID="2" CurrentPath="True" Enabled="True" MultiInstanced="True" Name="orcl_stdy">
    <DefaultState>STANDBY</DefaultState>
    <IntendedState>STANDBY</IntendedState>
    <Status>
      <Severity>Success</Severity>
      <Error>0</Error>
      <Timestamp>1739153145</Timestamp>
    </Status>
    <StandbyType>PhysicalStandby</StandbyType>
    <DGConnectIdentifier>orcl_stdy</DGConnectIdentifier>
    <DbDomain/>
    <ResourceType>Database</ResourceType>
    <Instance InstanceID="1" CurrentPath="True" Enabled="True" MultiInstanced="True" DefaultWriteOnce="True" Name="orcl">
      <HostName Default="True">db2</HostName>
      <StaticConnectIdentifier Default="True">(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_stdy_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))</StaticConnectIdentifier>
      <InstanceName>orcl</InstanceName>
    </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>
    <DelayMins>0</DelayMins>
    <Binding>OPTIONAL</Binding>
    <MaxFailure>0</MaxFailure>
    <ReopenSecs>300</ReopenSecs>
    <NetTimeout>30</NetTimeout>
    <RedoCompression>DISABLE</RedoCompression>
    <IncarnationTable>2,1920977,1189179698,1*1,1,1005785759,0#</IncarnationTable>
    <SRLStatus>1</SRLStatus>
    <CurrentRole>STANDBY</CurrentRole>
    <ActualApplyInstance>orcl</ActualApplyInstance>
  </Member>
  <MIV>5</MIV>
</DRC>

导入

DGMGRL> IMPORT CONFIGURATION FROM ‘oracledbwr.txt’ ;
Succeeded. Run ENABLE CONFIGURATION to enable the imported configuration.