19c RAC Duplicate方式静默安装ADG从库

        前期安装的环境配置

一、安装19c必要的依赖包

yum install bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat  librdmacm-devel   libXext   libaio.i686 libstdc++-devel.i686   libstdc++.i686  libgcc.i686  glibc-devel.i686  
yum install ipmiutil net-tools nfs-utils python python-configshell python-rtslib python-six targetcli compat-libstdc++-33.i686 gcc  compat-libstdc++  readline  libtermcap-devel unixODBC-devel  unixODBC libXi.i686 libxcb.i686 libXau.i686  libX11.i686 libXtst.i686  libXext.i686 gcc-c++  glibc  glibc.i686  libaio-devel.i686
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

二、关闭ntpd服务

[root@rac1 ~]#systemctl disable ntpd.service
[root@rac1 ~]#systemctl stop ntpd.service
[root@rac1 ~]#mv /etc/ntp.conf /etc/ntp.conf.orig
[root@rac1 ~]#systemctl status ntpd

三、关闭防火墙

[root@rac01 ~]# systemctl stop firewalld
[root@rac01 ~]# systemctl disable firewalld
[root@rac01 ~]# systemctl status firewalld

四、关闭avahi-daemon服务，官网建议关闭

[root@rac01 ~]# systemctl stop avahi-daemon
Warning: Stopping avahi-daemon.service, but it can still be activated by:
  avahi-daemon.socket
[root@rac01 ~]# systemctl disable avahi-daemon
Removed symlink /etc/systemd/system/multi-user.target.wants/avahi-daemon.service.
Removed symlink /etc/systemd/system/sockets.target.wants/avahi-daemon.socket.
Removed symlink /etc/systemd/system/dbus-org.freedesktop.Avahi.service.

五、创建用户及用户组

[root@rac1 ~]
groupadd -g 16881 oinstall  
groupadd -g 16882 dba  
groupadd -g 16883 oper  
groupadd -g 16884 backupdba  
groupadd -g 16885 dgdba  
groupadd -g 16886 kmdba  
groupadd -g 16887 asmdba  
groupadd -g 16888 asmoper  
groupadd -g 16889 asmadmin  
groupadd -g 16880 racdba  

useradd -u 16881 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle  
useradd -u 16882 -g oinstall -G asmadmin,asmdba,asmoper,dba grid

六、创建文件目录（在两个节点创建grid、oracle文件目录）

[root@rac1 ~]
mkdir -p /u01/app/19.0.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.0.0/db_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/

七、修改limits.conf（在两个节点修改）

[root@rac1 ~]vi /etc/security/limits.conf
#ORACLE SETTING
grid  soft  nproc 16384
grid  hard  nproc 16384
grid  soft  nofile 1024
grid  hard  nofile 65536
grid  soft  stack 10240
grid  hard  stack 32768
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack  10240
oracle hard stack  32768
oracle hard memlock 3145728
oracle soft memlock 3145728

八、添加 vi /etc/pam.d/login

session required pam_limits.so

九、配置NOZEROCONF

vi /etc/sysconfig/network增加以下内容
NOZEROCONF=yes

十、配置sysctl.conf

[root@rac1 ~]vi /etc/sysctl.conf
#ORACLE SETTING
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 269509197824
kernel.shmall = 65798144
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 104858

十一、关闭大页

echo "never" > /sys/kernel/mm/transparent_hugepage/enabled
echo "never" > /sys/kernel/mm/transparent_hugepage/defrag
chmod +x /etc/rc.d/rc.local

十二、CentOS7关闭networkmanager

[root@p4181-170 ~]# systemctl  stop NetworkManager
[root@p4181-170 ~]# systemctl disable NetworkManager
[root@p4181-170 ~]# mkdir -p /u01/app/oracle/product/19.0.0/db_1
[root@p4181-170 ~]# chown -R oracle:oinstall /u01
[root@p4181-170 ~]# chmod -R 775 /u01

十三、安装19c数据库包并提前安装cvuqdisk包

mv LINUX.X64_193000_db_home.zip $ORACLE_HOME
rpm -ivh $ORACLE_HOME/cv/rpm/cvuqdisk-1.0.10-1.rpm

十四、编辑响应文件

cd $ORACLE_HOME/install/response/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oper
oracle.install.db.OSBACKUPDBA_GROUP=backupdba
oracle.install.db.OSDGDBA_GROUP=dgdba
oracle.install.db.OSKMDBA_GROUP=kmdba
oracle.install.db.OSRACDBA_GROUP=racdba
oracle.install.db.rootconfig.configMethod=ROOT
/u01/app/oracle/product/19.0.0/db_1/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /u01/app/oracle/product/19.0.0/db_1/install/response/db_install.rsp
***************************************************************************

十五、如果安装单节点数据库，编辑数据库响应文件

（1）配置db相应文件内容
vi dbca.rsp
gdbName=SAASN
sid=SAASN
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=PRODPDB
pdbAdminPassword=xxxxx
templateName=General_Purpose.dbc
sysPassword=xxxx
systemPassword=xxxxx
emExpressPort=5500
datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
memoryPercentage=40
automaticMemoryManagement=false
totalMemory=30720
（2）安装数据库
dbca -silent -createDatabase -responseFile
/u01/app/oracle/product/19.0.0/db_1/install/response/dbca.rsp
****************************************************************************

        前期环境设置完成后，开始配置ADG的必要参数

十六、主库开启强制记录日志和归档模式

SQL> select force_logging from v$database;

如果开启闪回，归档日志需提前开启

SQL> alter system set db_recovery_file_dest='+FRA' scope=spfile;
SQL> alter system set db_recovery_file_dest_size=688G scope=spfile;

RAC环境关闭所有节点数据库，只开启一个节点到mount状态，开启强制归档模式。

[[email protected]:/home/grid]$srvctl stop database -d saas
[[email protected]:/home/grid]$srvctl start instance -d saas -i saas1 -o mount
SQL> alter database flashback on;
SQL> alter database force logging;
[[email protected]:/home/grid]$srvctl stop database -d saas
[[email protected]:/home/grid]$srvctl start database -d saas
SQL> select name,log_mode,flashback_on from v$database;
NAME       LOG_MODE        FLASHBACK_ON
------------------ ------------------------ ----------------------------