Oracle dataguard
Oracle dataguard技术及相关
zjw922
这个作者很懒,什么都没留下…
展开
-
oracle 12C dataguard同步状态RESYNCHRONIZATION异常处理
oracle 12C dataguard同步状态(主备库可以同步数据,但是配置dg broker时会出错)问题:DGMGRL> enable configurationEnabled.DGMGRL> show configurationConfiguration - dg Protection Mode: MaxAvailability Members: ...原创 2019-10-14 20:51:15 · 821 阅读 · 0 评论 -
Oracle 12C dataguard 切换中报错 ORA-01017: invalid username/password; logon denied
DGMGRL> switchover to ORCL2Performing switchover NOW, please wait...Operation requires a connection to instance "orcl2" on database "orcl2"Connecting to instance "orcl2"...ORA-01017: invalid us...原创 2019-10-14 20:57:53 · 813 阅读 · 0 评论 -
oracle dataguard 维护命令大全及注意事项
-----数据库管理员切记:查看日志/home/oracle/app/oracle/diag/rdbms/orcl/orcl/tracetail -f alert_orcl.log查询当前数据库的主备状态select log_mode,open_mode,database_role from v$database;select log_mode,open_mode,datab...原创 2019-10-14 21:17:25 · 518 阅读 · 0 评论 -
Oracle 12C dataguard实现一主库两备库的Dg Broker架构
DGMGRL> show configurationConfiguration - dg Protection Mode: MaxPerformance Members: orcl2 - Primary database orcl - Physical standby databaseFast-Start Failover: DISABLEDConfig...原创 2019-10-14 22:01:35 · 537 阅读 · 0 评论 -
Oracle 12c dgmgrl 关闭、启动dataguard的顺序
使用dg broker管理的dataguard环境,启动时还是先启动备库、再启动主库。详细操作如下:GMGRL> connect sys/oracle@orclConnected as SYSDBA.DGMGRL> startupORACLE instance started.Database mounted.Database opened.DGMGRL> con...原创 2019-10-15 17:17:21 · 604 阅读 · 0 评论 -
Oracle 12C dg broker实现swithover后failover,也可以failover后再switchover
特别强调:在使用dg broker在执行failover to xxx需要确认一下 主备库是否开启flashback,如果没有开启,需要执行,否则会报错并且库基本上需要重新手工同步了。alter database flashback on; --开启数据库一级的flashback功能[oracle@node1 ~]$ dgmgrlDGMGRL for Linux: Version...原创 2019-10-17 11:26:22 · 721 阅读 · 0 评论