![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle-Dataguard
文章平均质量分 81
bitko
这个作者很懒,什么都没留下…
展开
-
Oracle11g Dataguard配置
---------------------------------配置环境--------------------------------------------------------------------------------主库主机名:centos6 ip地址:192.168.48.10操作系统版本:Centos6.5(final)数据库版本:11.2.0.4.0O原创 2016-11-27 13:39:30 · 5125 阅读 · 0 评论 -
Oracle12c ADG for Centos7
1. 修改主端为归档模式两节点执行:SQL> alter system set log_archive_dest_1='location=+data_dg/arch';System altered.--关闭两节点SQL> shutdown immediate;--启动一个节点到mount状态SQL> startup mount;SQL> alter databa原创 2017-08-06 08:47:29 · 2202 阅读 · 0 评论 -
Oracle12c 容灾切换完全步骤
一. 切换前检查1. 参数检查----------------------------主端-------------------------------------------------------定义dataguard配置的有效db_unique_nameSQL> show parameter log_archive_configNAME原创 2017-08-06 08:52:05 · 3396 阅读 · 0 评论 -
Oracle11g dgbroker进行自动failover
环境:192.168.48.10 orcl 192.168.48.20 orcl_adg(db_unqiue_name)1. 配置dgbroker DGMGRL> help create;Creates a broker configurationSyntax: CREATE CONFIGURATION AS PRIMARY原创 2017-12-01 12:04:05 · 1872 阅读 · 0 评论 -
Reinstate Failed Primary Database into Physical Standby
官方文档:Step by Step Guide on How To Reinstate Failed Primary Database into Physical Standby (Doc ID 738642.1)一. 利用闪回前提条件:a. failover之前需要在主库和备库开启闪回b. 必须有"备转主"的时刻到现在所有的闪回日志c. 主备数据库能够通过网络连接原创 2017-12-04 10:12:50 · 448 阅读 · 0 评论 -
RFS[1]: No standby redo logfiles available for thread 1
场景:备库只能接收归档日志,不能实时应用redo log,如果主端日志不切换,备端一直会有adg延迟后台日志:RFS[1]: Assigned to RFS process 5351RFS[1]: No standby redo logfiles available for thread 1 RFS[2]: Assigned to RFS process 5353RFS[2]: No原创 2017-12-27 14:35:37 · 4414 阅读 · 0 评论 -
使用Rman增量备份修复Oracle11g adg传输Gap
场景:主库在传输之前被删除导致出现gap 数据库版本:Oracle11.2.0.4此时,备库依然可以接收来自主库的归档,但不会应用Wed Dec 27 09:07:27 2017FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 73-73 DBID 1485808053 branch原创 2017-12-27 13:49:10 · 1626 阅读 · 0 评论