Oracle11gR2_使用GoldenGate配置单向同步

※1、机器清单机器名ip系统版本DB版本SIDrac1（source）192.168.167.110CentOS release 6.8 (Final)oracle11G R2rac1rac2（target）192.168.167.111CentOS release 6.8 (Final)oracl

oracle-11G-R2安装

1、System infocat /etc/redhat-releaseDistributor ID: CentOS#CentOS Linux release 7.9.2009 (Core)redhat-72、Memery infofreeMema、grep MemTotal /proc/memin

ORACLE 日常维护命令简记

∵1、Oracle 查看失效的存储或无效对象JOB等 1-1、查看失效的存储 select * from user_objects where status <> 'VALID'; 1-2、查找到无效对象 select 'Alter '||object_type||' '||ob