adg
文章平均质量分 89
好记忆不如烂笔头abc
Oracle GoldenGate认证,超15年电信、金融、医疗、政府、教育等数据库运维经验,擅长oracle数据库高可用技术RAC/ADG以及跨平台跨版本数据库各种方法最短时间大数据量迁移升级:
oracle各版本之间:从9i->10g->11g->12c,19c,21c
sqlserver各版本之间:从2000->2008->2012->2014->2016->2017->2019
db2->oracle,oracle->postgresql等
展开
-
Centos7.9+Oracle11.2.0.4数据库ADG主备环境搭建
Oracle11.2.0.4数据库ADG主备环境搭建实现目标两台X86数据库服务器实现oracle11g的主备adg环境,避免单点故障,满足数据库基本容灾备份需求。其中操作系统版本要求centos7.9,数据库版本要求oracle11.2.0.4+最新psu201020版本。环境准备 主库 备库 主机名 prebilla prebillb 本机ip.原创 2021-08-04 09:50:07 · 3241 阅读 · 0 评论 -
adg实现浮动ip自动切换主备
两个节点都添加,每三秒检测一次。[root@prebilla keepalived]# crontab -l* * * * * /etc/keepalived/ip.sh[root@prebilla keepalived]# cat /etc/keepalived/ip.shstep=3for ((i = 0; i < 60; i = (i + step))); do $(/etc/keepalived/db_ip.sh) sleep $stepdoneexit...原创 2021-07-28 16:53:05 · 743 阅读 · 0 评论 -
SWITCHOVER ORA-12514 ORA-12545
DGMGRL> SWITCHOVER TO prebillbPerforming switchover NOW, please wait...Operation requires a connection to instance "prebill" on database "prebillb"Connecting to instance "prebill"...Connected.New primary database "prebillb" is opening...Operati...原创 2021-07-28 14:00:59 · 507 阅读 · 0 评论 -
Tablespace-SYSTEM during PDB create skipped since source is in r/w mode or this is a refresh clone
问题来源:http://www.itpub.net/thread-2140439-1-1.html解释:Standby Database Behavior when Creating, Cloning or Plugging in a PDBThe following items describe the various behaviors that will occur at the standby database when a PDB is created, either as a n原创 2021-01-06 14:54:12 · 484 阅读 · 0 评论