[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"?><DRCVersion="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><MemberMemberID="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><InstanceInstanceID="1"CurrentPath="True"Enabled="True"MultiInstanced="True"DefaultWriteOnce="True"Name="orcl"><PlannedState/><HostNameDefault="True">db1</HostName><StaticConnectIdentifierDefault="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><LogXptModeDefault="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><FastStartFailoverLagLimitDefault="True">30</FastStartFailoverLagLimit><MemberMemberID="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><InstanceInstanceID="1"CurrentPath="True"Enabled="True"MultiInstanced="True"DefaultWriteOnce="True"Name="orcl"><HostNameDefault="True">db2</HostName><StaticConnectIdentifierDefault="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><LogXptModeDefault="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 CONFIGURATIONto enable the imported configuration.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库