Oracle 12C dataguard实现一主库两备库的Dg Broker架构

最新推荐文章于 2021-04-10 21:26:05 发布
最新推荐文章于 2021-04-10 21:26:05 发布
阅读量513 收藏 1
点赞数
分类专栏： Oracle dataguard
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zjw922/article/details/102557639
版权

DGMGRL> show configuration

Configuration - dg

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

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 44 seconds ago)

DGMGRL> show database verbose orcl2

Database - orcl2

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    orcl2

  Properties:
    DGConnectIdentifier             = 'orcl2'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl2_DGMGRL)(INSTANCE_NAME=orcl2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcl2/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> disabel
Unrecognized command "disabel", try "help"
DGMGRL> remove configuration
Removed configuration
DGMGRL> exit
[oracle@node1 admin]$ ssh node3
oracle@node3's password: 
Last login: Mon Oct 14 20:32:15 2019 from node1
[oracle@node3 ~]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@orcl2
Connected as SYSDBA.
DGMGRL> create configuration dg as primary database is 'orcl2' connect identifier is 'orcl2';
Configuration "dg" created with primary database "orcl2"
DGMGRL> add database 'orcl' as connect identifier is 'orcl';
Database "orcl" added
DGMGRL> ena 
Unrecognized command "ena", try "help"
DGMGRL> enable configuration
Enabled.
DGMGRL> show database verbose orcl2

Database - orcl2

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    orcl2

  Properties:
    DGConnectIdentifier             = 'orcl2'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl2_DGMGRL)(INSTANCE_NAME=orcl2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcl2/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL>  show database verbose orcl2

Database - orcl2

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    orcl2

  Properties:
    DGConnectIdentifier             = 'orcl2'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl2_DGMGRL)(INSTANCE_NAME=orcl2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcl2/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> edit database orcl2 set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl2)(INSTANCE_NAME=orcl2)(SERVER=DEDICATED)))'
> ;
Property "staticconnectidentifier" updated
DGMGRL> show database verbose orcl

Database - orcl

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 2.00 KByte/s
  Active Apply Rate:  0 Byte/s
  Maximum Apply Rate: 0 Byte/s
  Real Time Query:    ON
  Instance(s):
    orcl

  Properties:
    DGConnectIdentifier             = 'orcl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcl'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcl'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcl/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> edit database orcl set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
> ;
Property "staticconnectidentifier" updated
DGMGRL> swir;
Unrecognized command "swir", try "help"
DGMGRL> switchover to orcl
Performing switchover NOW, please wait...
Operation requires a connection to instance "orcl" on database "orcl"
Connecting to instance "orcl"...
Connected as SYSDBA.
New primary database "orcl" is opening...
Operation requires start up of instance "orcl2" on database "orcl2"
Starting instance "orcl2"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "orcl"
DGMGRL> switchover to orcl2
Performing switchover NOW, please wait...
Operation requires a connection to instance "orcl2" on database "orcl2"
Connecting to instance "orcl2"...
Connected as SYSDBA.
New primary database "orcl2" is opening...
Operation requires start up of instance "orcl" on database "orcl"
Starting instance "orcl"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "orcl2"
DGMGRL> show pdbs;
show pdbs;
     ^
Syntax error before or at "pdbs"
DGMGRL> show configurtal
show configurtal
     ^
Syntax error before or at "configurtal"
DGMGRL> show configuration

Configuration - dg

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

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 16 seconds ago)

DGMGRL> add database 'orcls' as connect identifier is 'orcls';
Error: ORA-12541: TNS:no listener

Failed.

-------------------------启动监听 lsnrctl start------------------------------


DGMGRL> add database 'orcls' as connect identifier is 'orcls';
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Failed

-------------------------在sqlplus中执行-------------------------------------

SQL> alter system set dg_broker_start=true scope=both;

System altered.

SQL> alter system set LOG_ARCHIVE_DEST_2='' scope=both;

alter system set LOG_ARCHIVE_DEST_3='' scope=both;
System altered.

------------------------------------------------------------

.
DGMGRL> add database 'orcls' as connect identifier is 'orcls';
Error: ORA-16525: The Oracle Data Guard broker is not yet available.

Failed.
DGMGRL> add database 'orcls' as connect identifier is 'orcls';
Database "orcls" added
DGMGRL> switchover to oracl;
Object "oracl" was not found
DGMGRL> switchover to orcls
Performing switchover NOW, please wait...
Error: ORA-16505: site identifier is invalid

Failed.
Unable to switchover, primary database is still "orcl2"
DGMGRL> show configuration

Configuration - dg

  Protection Mode: MaxPerformance
  Members:
  orcl2 - Primary database
    orcl  - Physical standby database 
    orcls - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 2 seconds ago)

DGMGRL> show database verbose orcls

Database - orcls

  Role:               PHYSICAL STANDBY
  Intended State:     OFFLINE
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Active Apply Rate:  (unknown)
  Maximum Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    orcls

  Properties:
    DGConnectIdentifier             = 'orcls'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'MANUAL'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls_DGMGRL)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcls/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
DISABLED

DGMGRL> edit database orcl set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))';
Property "staticconnectidentifier" updated
DGMGRL> show database verbose orcls

Database - orcls

  Role:               PHYSICAL STANDBY
  Intended State:     OFFLINE
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Active Apply Rate:  (unknown)
  Maximum Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    orcls

  Properties:
    DGConnectIdentifier             = 'orcls'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'MANUAL'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls_DGMGRL)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcls/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
DISABLED

DGMGRL> edit database orcl set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
> ;
Property "staticconnectidentifier" updated
DGMGRL> edit database orcls set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))';
Property "staticconnectidentifier" updated
DGMGRL> show database verbose orcls

Database - orcls

  Role:               PHYSICAL STANDBY
  Intended State:     OFFLINE
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Active Apply Rate:  (unknown)
  Maximum Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    orcls

  Properties:
    DGConnectIdentifier             = 'orcls'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'MANUAL'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    LogFileNameConvert              = '/home/oracle/app/oracle/oradata/orcl, /home/oracle/app/oracle/oradata/orcls, /home/oracle/app/oracle/oradata/orcl2, /home/oracle/app/oracle/oradata/orcls'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcls)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/home/oracle/app/oracle/oradata/orcls/archivelog'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
DISABLED

DGMGRL> switchover to orcls
Performing switchover NOW, please wait...
Error: ORA-16505: site identifier is invalid

Failed.
Unable to switchover, primary database is still "orcl2"
DGMGRL> enable database orcls;
Enabled.
DGMGRL> show configuration

Configuration - dg

  Protection Mode: MaxPerformance
  Members:
  orcl2 - Primary database
    orcl  - Physical standby database 
    orcls - Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 26 seconds ago)

DGMGRL> switchover to orcls;
Performing switchover NOW, please wait...
Operation requires a connection to instance "orcls" on database "orcls"
Connecting to instance "orcls"...
Connected as SYSDBA.
New primary database "orcls" is opening...
Operation requires start up of instance "orcl2" on database "orcl2"
Starting instance "orcl2"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "orcls"
DGMGRL> 
 

zjw922
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle dataguard一主两备环境搭建
lk的窝
05-25 8690
测试环境说明： 主 库：Reahat 6.5 x64 + Oracle 11.2.0.3 x64 单机（IP：192.168.6.10  db）  DB_UNIQUE_NAME=orcl 备库1：Reahat 6.5 x64 + Oracle 11.2.0.3 x64 单机（IP：192.168.6.101 db1） DB_UNIQUE_NAME=dglocal 备库2：Reahat 6.5
(可参考)ORACLE 12C DATAGUARD环境搭建和主从切换.docx
06-04
(可参考)ORACLE 12C DATAGUARD环境搭建和主从切换，本人实际生产环境搭建测试，大神请忽略。
Oracle 12c DG 一主多备搭建
leo__1990的博客
05-10 2458
环境说明： 1）数据库版本 12.2.0.1.0 2）db_name为cndba,db_unique_name 分别为 pdbcndba_p(主库),pdbcndba_s(备库1),pdbcndba_c(备库2) 3）主库地址 192.168.1.74，备库1地址 192.168.1.75,备库2地址 192.168.1.78 4）一个备库搭建和多个备库搭建方法一样，配置修改可参考下面链...
oracle12c的dg配置,Oracle 12C dgbroker 配置
weixin_42298415的博客
04-04 333
关于DGbroker的配置网上有太多资料了，此处在不做详细介绍配置，贴一片metalink上的文章共大家参考学习。1. Prerequisits,Start the Dataguard broker DMON process.----------启动dg_brokerOn Primary and Standby,SQL> alter system set dg_broker_start=tr...
oracle dataguard 维护命令大全及注意事项
zjw922的专栏
10-14 481
-----数据库管理员切记：查看日志 /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace tail -f alert_orcl.log 查询当前数据库的主备状态 select log_mode,open_mode,database_role from v$database; select log_mode,open_mode,datab...
Oracle数据库DG实现主从数据库同步
代码君的博客
10-11 9511
概述 参考文档下载链接：链接: https://pan.baidu.com/s/1gcSw0qsb8sI4XY84ZGV5Xg 提取码: sn1p 前提:本文档基于已经创建了oracle数据库，两台服务器网络可以互相访问， 主库 备库 OS系统 Centos 7.5x64 ...
oracle DG 主备库为RAC及一个主库对多个从库的实验环境搭建
weixin_34367845的博客
07-02 447
主库 RAC ：192.168.1.210 node1192.168.1.211 node2备库（1） RAC:192.168.1.247 rac1192.168.1.248 rac2备库（2） 单实例：192.168.1.219 dataguard以上均为ASM管理...
Oracle数据库 DGbroker三种保护模式的切换
09-10
在这种模式下，Oracle确保从库与主库的数据完全一致，实现零数据丢失。事务在主从库上同时提交完成，如果从库宕机或网络出现问题导致主从库无法通信，主库也会立即停止服务。这种模式提供了最高的数据保护等级，但...
ORACLE 12C RAC 主库配置单实例ADG
02-08
Oracle 12C RAC 主库配置单实例 ADG 是一种高可用性和灾难恢复解决方案，旨在提供高可用性和数据保护。下面将详细介绍 ORACLE 12C RAC 主库配置单实例 ADG 的知识点。 一、ORACLE RAC 概述 ORACLE RAC（Real ...
Oracle 12c内存架构
03-04
Oracle 12c内存架构
oracle12cRAC+DG+ASM标准搭建.doc
07-31
oracle文档实测通过，并已规范为公司安装标准文档。oracle下任何安装不再愁，46页图文详细手把手教你安装RAC，DG，ASM，无基础也可轻松安装。
Oracle 12c RAC+DG安装配置
08-09
Oracle 12c RAC (Real Application Clusters) 和 DG (Data Guard) 是企业级数据库解决方案的重要组成部分，用于实现高可用性和灾难恢复。在Vmware 15虚拟环境中结合CentOS 7.6进行安装配置，可以提供一个灵活且可...
数据库读写分离，主从同步实现方法
热门推荐
starlh35的博客
12-06 8万+
通过实际的例子编码实现数据库读写分离，实现数据库主从同步
Data Guard broker系列之一：Data Guard Broker基础
congmao4272的博客
12-29 373
转自：http://www.dbabeta.com/2009/learn-data-guard-broker_basics.htmlData Guard broker概览 Data Guard broker组成 broker的配...
Oracle DG broker搭建
lc724234511的专栏
12-11 500
oracle data guard broker搭建文档
DataGuard之DG Broker配置详解
雨花石
02-17 1万+
oracle dg datagurad failover swithover broker fsfo
oracle 12c dg broker,Oracle 12c --- DG系列汇总
weixin_30431043的博客
04-10 140
Oracle 12c Data Guard 搭建http://www.cndba.cn/leo1990/article/1935https://www.cndba.cn/leo1990/article/2709https://www.cndba.cn/leo1990/article/2709Oracle 12c DG 一主多备搭建http://www.cndba.cn/leo1990/articl...
oracle 12c dg broker,Oracle 11g DG Broker 开启和配置
weixin_42473904的博客
04-10 284
Oracle 11g DG Broker 开启和配置Oracle11g 开启 db broker 实现管理 dg 的目的保证两边都设置的如下几个参数:1.SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/data/u01/app/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_U...
取暖锅炉管理制度.docx
最新发布
07-09
取暖锅炉管理制度

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值