做网站需要监事吗,玉林网站优化,西宁做网站君博领先,定制应用软件有哪些d1.基本操作
1.1 划分虚拟机区域
主库、备库、单实例adg存放目录
以上便是我虚拟机以及共享磁盘存放目录
1.2建立共享盘
1.2.1主库
打开windows自带软件 Windows PowerShell ,管理员身份打开
打开后进入到VMware软件所在位置
我的软件安装在d:需要安装的软件/嵌入式这…d1.基本操作
1.1 划分虚拟机区域
主库、备库、单实例adg存放目录
以上便是我虚拟机以及共享磁盘存放目录
1.2建立共享盘
1.2.1主库
打开windows自带软件 Windows PowerShell ,管理员身份打开
打开后进入到VMware软件所在位置
我的软件安装在d:需要安装的软件/嵌入式这个目录中开始创建共享磁盘./vmware-vdiskmanager -c -s 10Gb -a lsilogic -t 2 D:\11g-adg\11g-rac\disk\data01.vmdk
./vmware-vdiskmanager -c -s 5Gb -a lsilogic -t 2 D:\11g-adg\11g-rac\disk\fra01.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac\disk\clus01.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac\disk\clus02.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac\disk\clus03.vmdk1.2.2备库
开始创建共享磁盘./vmware-vdiskmanager -c -s 10Gb -a lsilogic -t 2 D:\11g-adg\11g-rac-1\disk\data01.vmdk
./vmware-vdiskmanager -c -s 5Gb -a lsilogic -t 2 D:\11g-adg\11g-rac-1\disk\fra01.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac-1\disk\clus01.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac-1\disk\clus02.vmdk
./vmware-vdiskmanager -c -s 1Gb -a lsilogic -t 2 D:\11g-adg\11g-rac-1\disk\clus03.vmdk./vmware-vdiskmanager -c -s 30Gb -a lsilogic -t 6 C:\11g-adg\11g-rac\disk\data01.vmdk1.3虚拟机安装
镜像选择Oracle-Linux-7.9 进入之后选择安装回车 配置静态ip
设置root密码
我设置为123456
安装成功
1.4 ip地址规划
本次两个网卡
第一个网卡配置信息如下
TYPEEthernet
BOOTPROTOnone
DEFROUTEyes
NAMEens33
DEVICEens33
ONBOOTyes
IPADDR10.0.0.11
PREFIX24
GATEWAY10.0.0.2
DNS1223.5.5.5第二个网卡配置如下
TYPEEthernet
PROXY_METHODnone
BROWSER_ONLYno
BOOTPROTOnone
DEFROUTEyes
NAMEens37
DEVICEens37
ONBOOTyes
IPADDR172.0.0.11
PREFIX24
DNS1223.5.5.5
GATEWAY172.0.0.1第二张网卡和安装时不一致因为网关需要和虚拟网络配置的一样。故修改
虚拟网络编辑器中我的网关设置为10.0.0.2 和172.0.0.1需要和你自己的一致。
除此还需要规划vip和scan-ip
只是规划还未使用
这是我主库ip规划
10.0.0.11 rac1
10.0.0.12 rac2
172.0.0.11 priv1
172.0.0.12 priv2
10.0.0.13 vip1
10.0.0.14 vip2
10.0.0.10 scan-ip备库ip规划
10.0.0.21 rac1
10.0.0.22 rac2
172.0.0.21 priv1
172.0.0.22 priv2
10.0.0.23 vip1
10.0.0.24 vip2
10.0.0.20 scan-ip单实例adg ip规划
10.0.0.301.5 配置hosts
vim /etc/hosts10.0.0.11 rac1
10.0.0.12 rac2
172.0.0.11 priv1
172.0.0.12 priv2
10.0.0.13 vip1
10.0.0.14 vip2
10.0.0.10 scan-ip1.6 关闭防火墙
systemctl disable --now firewalld.service[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-6ZKgQVHi-1692582179026)(assets/1690879154795.png)]
1.7 修改SElinux
vim /etc/selinux/config
SELINUXdisabled#将selinux修改成不可使用
保存退出
setenforce 0 修改会话中selinux的值1.8 配置yum 源
cd /etc/yum.repos.d/
mkdir bak
mv * bakvim local.repo[local]
nameapp
baseurlfile:///mnt
enabled1
gpgcheck0[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-VSCt2KSY-1692582179026)(assets/1690879802153.png)]
虚拟机连接镜像
mount /dev/sr0 /mnt
yum makecache
1.9依赖包以及Oracle预安装包
yum install oracle-database-preinstall-19c
yum install gcc gcc-c elfutils-libelf-devel iotop tigervnc-server1、会自动安装依赖的rpm
2、会自动修改/etc/sysctl.conf
3、会自动添加/etc/security/limits.d/oracle-database-preinstall-19c.conf
4、会自动关闭透明大页、NUMA
5、会自动创建oracle用户和oinstall组1.10 内核参数调整
#修改/etc/sysctl.conf中的fs.aio-max-nr为3145728
vi /etc/sysctl.conf
fs.aio-max-nr3145728systcl -p#修改/etc/security/limits.d/oracle-database-preinstall-19c.conf中的soft nofile为65536
vi /etc/security/limits.d/oracle-database-preinstall-19c.conf
oracle soft nofile 65536
oracle soft memlock -1
oracle hard memlock -11.11补充创建grid用户和相关用户组
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadminusermod -a -G asmdba oracle
useradd -u 54331 -g oinstall -G dba,asmadmin,asmdba,asmoper,racdba gridecho 123456 | passwd oracle --stdin
echo 123456 | passwd grid --stdin1.12 补充添加grid用户资源限制配置
cat ! /etc/security/limits.d/oracle-database*.conf
grid soft nproc 65536
grid soft nofile 65536
grid soft stack -1
grid hard nproc 65536
grid hard nofile 65536
grid hard stack -1
!1.13 补充内核参数配置
cat ! /etc/sysctl.conf
$(free|grep Mem|awk {if($2/1024/102429)print vm.nr_hugepages int($2/1024*0.4*0.8/2)})
$(free|grep Mem|awk {print vm.min_free_kbytes int($2/1000*4)})
kernel.randomize_va_space 0
!
sysctl -p1.14 建立目录
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
mkdir /u01/install
chmod -R 775 /u01/1.15 环境变量配置
cat! /home/oracle/.bash_profile
export ORACLE_BASE/u01/app/oracle
export ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1
export GRID_HOME/u01/app/11.2.0/grid
export PATH\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch:\$GRID_HOME/bin:\$PATH
export ORACLE_SIDorcl1
export LD_LIBRARY_PATH\$ORACLE_HOME/lib
export NLS_DATE_FORMATyyyy-mm-dd hh24:mi:ss
export TZAsia/Shanghai
alias sqlsqlplus / as sysdba
alias csrcrsctl stat res -t
alias csricrsctl stat res -t -init
export DISPLAY10.0.0.1:0.0
set -o vi
export EDITORvi
!cat! /home/grid/.bash_profile
export ORACLE_BASE/u01/app/grid
export ORACLE_HOME/u01/app/11.2.0/grid
export PATH\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch:\$PATH
export ORACLE_SIDASM1
export LD_LIBRARY_PATH\$ORACLE_HOME/lib
export NLS_DATE_FORMATyyyy-mm-dd hh24:mi:ss
export TZAsia/Shanghai
alias sqlsqlplus / as sysasm
alias csrcrsctl stat res -t
alias csricrsctl stat res -t -init
export DISPLAY10.0.0.1:0.0
set -o vi
export EDITORvi
!cat! /root/.bash_profile
export PATH/u01/app/11.2.0/grid/bin:\$PATH:\$HOME/bin
!cat! /etc/profile
export ORACLE_BASE/u01/app/grid
export ORACLE_HOME/u01/app/11.2.0/grid
export PATH\$ORACLE_HOME/bin:\$ORACLE_HOME/OPatch:\$PATH
alias csrcrsctl stat res -t
alias csricrsctl stat res -t -init
set -o vi
export EDITORvi
!1.16克隆虚拟机
关机克隆虚拟机取名为rac1-1、rac2、rac2-2启动rac2修改ip 10.0.0.12和172.0.0.12
切换oracle用户
修改实例名
orcl2vim .bash_profile
ORACLE_SIDorcl2修改主机名
hostnamectl set-hostname rac21.17 添加共享盘信息
disk.EnableUUIDTRUE
scsi1.shared TRUE
disk.locking FALSE
diskLib.dataCacheMaxSize 0
diskLib.dataCacheMaxReadAheadSize 0
diskLib.dataCacheMinReadAheadSize 0
diskLib.dataCachePageSize 4096
diskLib.maxUnsyncedWrites 0
scsi1.present TRUE
scsi1.virtualDev lsilogic
scsil.sharedBus VIRTUAL
scsi1:0.present TRUE
scsi1:0.mode independent-persistent
scsi1:0.fileName D:\11g-adg\11g-rac\disk\data01.vmdk
scsi1:0.deviceType disk
scsi1:0.redo
scsi1:1.present TRUE
scsi1:1.mode independent-persistent
scsi1:1.fileName D:\11g-adg\11g-rac\disk\fra01.vmdk
scsi1:1.deviceType disk
scsi1:1.redo
scsi1:2.present TRUE
scsi1:2.mode independent-persistent
scsi1:2.fileName D:\11g-adg\11g-rac\disk\clus01.vmdk
scsi1:2.deviceType disk
scsi1:2.redo
scsi1:3.present TRUE
scsi1:3.mode independent-persistent
scsi1:3.fileName D:\11g-adg\11g-rac\disk\clus02.vmdk
scsi1:3.deviceType disk
scsi1:3.redo
scsi1:4.present TRUE
scsi1:4.mode independent-persistent
scsi1:4.fileName D:\11g-adg\11g-rac\disk\clus03.vmdk
scsi1:4.deviceType disk
scsi1:4.redo 1.18udev配置
for disk in ls /dev/sd*doecho $disk/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device$diskdone添加信息
vim /etc/udev/rules.d/99-oracle-asmdevices.rulesKERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2929fae26308b80cb52630fb619, SYMLINKasm-data01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2930976cabb656367d1a1bf769e, SYMLINKasm-fra01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c296df780b9c74e41554d43091e3, SYMLINKasm-clus01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c29749235922d26499ae34ffa7f0, SYMLINKasm-clus02, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2964d0dafc012b68612dde8dc21, SYMLINKasm-clus03, OWNERgrid, GROUPasmadmin, MODE0660udevadm trigger
扫描识别
ll /dev/asm*
查看是否识别成功2.安装grid
2.1上传grid包
su - grid
cd /u01
mkdir install
cd install上传grid包 2.2解压
unzip p13390677_112040_Linux-x86-64_3of7.zip -d $ORACLE_HOME
unzip p13390677_112040_Linux-x86-64_2of7.zip -d $ORACLE_HOME2.3 安装
打开Xmanager-Passive设置display
export DISPLAY10.0.0.1:0.0
进入解压目录
cd /u01/app/11.2.0/grid/grid
./runInstall1.
2. 3. 4. 5. 6. 7. 8. 9. 10 统一密码123456
yes
11. 12. 13. 14. su - root
yum install -y gcc*
yum install -y compat-libstdc*
yum install -y elfutils-libelf* /tmp/CVU_11.2.0.4.0_grid/runfixup.sh点击忽略继续安装 15. 16. 输入脚本
/u01/app/oraInventory/orainstRoot.sh
/u01/app/11.2.0/grid/root.sh输入第二个脚本遇见错误Adding Clusterware entries to inittab
ohasd failed to start
Failed to start the Clusterware. Last 20 lines of the alert log follow:原因
linux 7 使用的是 systemd而root.sh 是使用initd 来运行ohasd进程
需要做一些简单修改root用户创建服务文件touch /usr/lib/systemd/system/ohas.service;
chmod 777 /usr/lib/systemd/system/ohas.service;
vim /usr/lib/systemd/system/ohas.service
i
[Unit]
DescriptionOracle High Availability Services
Aftersyslog.target[Service]
ExecStart/etc/init.d/init.ohasd run /dev/null 21 Typesimple
Restartalways[Install]
WantedBymulti-user.target
启用服务# systemctl daemon-reload;
systemctl enable ohas.service;
systemctl start ohas.service;
systemctl status ohas.service;再次执行root.sh 脚本安装完成
3.安装oracle
3.1上传软件 3.2解压
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip 3.3 开始安装
./runInstall1. 2. 3. 4.
5. 6. 7. 8. 9. 10. 11. 报错
Error in invoking target agent nmhs of makefile /u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk. See /u01/app/oraInventory/logs/installActions2023-08-03_05-54-20PM.log for details.linux7 安装oracle11g会出现此错误
解决方案
新建窗口
cd $ORACLE_HOME/sysman/libcp ins_emagent.mk ins_emagent.mk.bakvim ins_emagent.mk进入vi编辑器后 命令模式输入/NMECTL 进行查找快速定位要修改的行
在后面追加参数-lnnz11 第一个是字母l 后面两个是数字1
返回点击Retty 12. 安装完成
3.4 创建磁盘组
su - grid
asmca 3.5 打补丁
su - root
上传补丁包
p31718723_112040_Linux-x86-64.zip
上传补丁工具
p6880880_112000_Linux-x86-64.zip解压补丁工具
chown grid:oinstall p6880880_112000_Linux-x86-64.zip
su - grid
cd /u01/install
unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOMEsu - root
cd /u01/install
chown oracle:oinstall p6880880_112000_Linux-x86-64.zip
su - oracle
cd /u01/install
unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME解压补丁包unzip p31718723_112040_Linux-x86-64.zip #解压到当前
chown grid:oinstall 31718723/ -R打grid补丁/u01/app/11.2.0/grid/OPatch/opatch auto 31718723 -oh /u01/app/11.2.0/grid打oracle补丁chown oracle:oinstall 31718723/ -R
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto 31718723 -oh /u01/app/oracle/product/11.2.0/db_1两节点都需要进行打补丁
rac1打完后对rac2进行打补丁
3.6 安装数据库实例
su - oracle
export DISPLAY10.0.0.1:0.0
dbca
1. 2. 3. 4. 5. 6. 7. 8. 9. 10 11. 12. 13. 14. 3.7检查集群状态
#检查集群状态
su - grid
crsctl status res -tsu - oracle
sqlplus / as sysdba#检查操作系统的多路径情况
su - root
multipath -ll
tail -2000 /var/log/messages|less#检查字符集是否正确UTF8
select userenv(language) from dual;#操作系统层面检查内存大页使用情况
cat /proc/meminfo |grep HugePages#检查时区是否正常
su - oracle
sqlplus / as sysdba
select sysdate from dual;
exit
su - grid
cd $GRID_HOME/crs/install/
cat s_crsconfig_cbsdb3_env.txt |grep TZ -----时区需要是TZAsia/Shanghai3.8 调整参数
su - oracle
sqlplus / as sysdba
alter database force logging;
alter system set db_recovery_file_destFRA scopeboth sid*;
alter system set db_recovery_file_dest_size10G scopeboth sid*;
alter profile default limit password_life_time unlimited;
alter profile default limit failed_login_attempts unlimited;
exit
srvctl stop database -d orcl
srvctl start database -d orcl#开启归档
su - oracle
srvctl stop database -d orcl
sqlplus / as sysdba
startup mount;
alter database archivelog;archive log list; #查看归档
shutdown immediate;
exit
srvctl start database -d orcl3.9配置集群服务
srvctl add database -d database name [-m domain_name] -o ORACLE_HOME path -p spfile location and namesrvctl add instance -d database name -i instance 1 name -n node 1 name srvctl add instance -d database name -i instance 2 name -n node 2 name srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/db_1
srvctl add instance -d orcl -i orcl1 -n rac1
srvctl add instance -d orcl -i orcl2 -n rac2以上三条可能已经添加3.10 修改rman配置
su - oracle
rman target /
configure controlfile autobackup off;
configure snapshot controlfile name to data/ORCL/snapcf.f;3.11 配置standby日志(主库)
创建主库standby日志文件每个实例的组数要比logfile多一组
select * from v$log;
alter database add standby logfile thread 1 size 500m;
alter database add standby logfile thread 1 size 500m;
alter database add standby logfile thread 2 size 500m;
alter database add standby logfile thread 2 size 500m;4.建立备库
4.1 添加共享盘到虚拟机
disk.EnableUUIDTRUE
scsi1.shared TRUE
disk.locking FALSE
diskLib.dataCacheMaxSize 0
diskLib.dataCacheMaxReadAheadSize 0
diskLib.dataCacheMinReadAheadSize 0
diskLib.dataCachePageSize 4096
diskLib.maxUnsyncedWrites 0
scsi1.present TRUE
scsi1.virtualDev lsilogic
scsil.sharedBus VIRTUAL
scsi1:0.present TRUE
scsi1:0.mode independent-persistent
scsi1:0.fileName D:\11g-adg\11g-rac-1\disk\data01.vmdk
scsi1:0.deviceType disk
scsi1:0.redo
scsi1:1.present TRUE
scsi1:1.mode independent-persistent
scsi1:1.fileName D:\11g-adg\11g-rac-1\disk\fra01.vmdk
scsi1:1.deviceType disk
scsi1:1.redo
scsi1:2.present TRUE
scsi1:2.mode independent-persistent
scsi1:2.fileName D:\11g-adg\11g-rac-1\disk\clus01.vmdk
scsi1:2.deviceType disk
scsi1:2.redo
scsi1:3.present TRUE
scsi1:3.mode independent-persistent
scsi1:3.fileName D:\11g-adg\11g-rac-1\disk\clus02.vmdk
scsi1:3.deviceType disk
scsi1:3.redo
scsi1:4.present TRUE
scsi1:4.mode independent-persistent
scsi1:4.fileName D:\11g-adg\11g-rac-1\disk\clus03.vmdk
scsi1:4.deviceType disk
scsi1:4.redo 4.2 配置网络
vim /etc/hosts
10.0.0.21 rac1
10.0.0.22 rac2
172.0.0.21 priv1
172.0.0.22 priv2
10.0.0.23 vip1
10.0.0.24 vip2
10.0.0.20 scan-ipTYPEEthernet
BOOTPROTOnone
DEFROUTEyes
NAMEens33
DEVICEens33
ONBOOTyes
IPADDR10.0.0.21
PREFIX24
GATEWAY10.0.0.2
DNS1223.5.5.5TYPEEthernet
PROXY_METHODnone
BROWSER_ONLYno
BOOTPROTOnone
DEFROUTEyes
NAMEens37
DEVICEens37
ONBOOTyes
IPADDR172.0.0.21
PREFIX24
DNS1223.5.5.5
GATEWAY172.0.0.14.3 识别共享盘udev配置
for disk in ls /dev/sd*doecho $disk/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device$diskdonevim /etc/udev/rules.d/99-oracle-asmdevices.rulesKERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2917faa72b7dc8b9f85fe22afe7, SYMLINKasm-data01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2923e1e1d95cb752e807318c743, SYMLINKasm-fra01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c292364338cf71469de63b976f33, SYMLINKasm-clus01, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2962b132345e4ea0f4fff33970e, SYMLINKasm-clus02, OWNERgrid, GROUPasmadmin, MODE0660
KERNELsd?, SUBSYSTEMblock, PROGRAM/usr/lib/udev/scsi_id -g -u -d /dev/$name, RESULT36000c2995f2a0931dedc55f805a43ee6, SYMLINKasm-clus03, OWNERgrid, GROUPasmadmin, MODE06604.4安装grid
略和主库一样4.5 安装oracle软件
略和主库一样4.6打补丁
su - root
上传补丁包
p31718723_112040_Linux-x86-64.zip
上传补丁工具
p6880880_112000_Linux-x86-64.zip解压补丁工具
chown grid:oinstall p6880880_112000_Linux-x86-64.zip
su - grid
cd /u01/install
unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOMEsu - root
cd /u01/install
chown oracle:oinstall p6880880_112000_Linux-x86-64.zip
su - oracle
cd /u01/install
unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME解压补丁包
unzip p31718723_112040_Linux-x86-64.zip #解压到当前
chown grid:oinstall 31718723/ -R
打grid补丁
/u01/app/11.2.0/grid/OPatch/opatch auto 31718723 -oh /u01/app/11.2.0/grid
打oracle补丁
chown oracle:oinstall 31718723/ -R
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto 31718723 -oh /u01/app/oracle/product/11.2.0/db_1目前主库备库都已经建立好了。
5.搭建adg
5.1 打开归档和强制日志
1.确保主库为归档模式
2.配置主库强制写日志至关重要
alter database force logging;5.2 配置standby日志(主库)
创建主库standby日志文件每个实例的组数要比logfile多一组select * from v$log;
alter database add standby logfile thread 1 size 500m;
alter database add standby logfile thread 1 size 500m;
alter database add standby logfile thread 2 size 500m;
alter database add standby logfile thread 2 size 500m;5.3在备库每个节点创建审计日志目录
mkdir -p /u01/app/oracle/admin/orcl/adump
5.4 配置listener
在主库、备库每个节点配置grid的listener.ora
以主库节点1为例其中GLOBAL_DBNAME配置为db_unique_nameSID_NAME配置为该节点ORACLE_SID
su - grid
vi $ORACLE_HOME/network/admin/listener.ora
添加
主
SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME orcl)(ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1)(SID_NAME orcl1))(SID_DESC (GLOBAL_DBNAME orcl_DGMGRL)(ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1)(SID_NAME orcl1)))备
SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME orcl_yzg)(ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1)(SID_NAME orcl1))(SID_DESC (GLOBAL_DBNAME orcl_yzg_DGMGRL)(ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1)(SID_NAME orcl1)))#重启监听
srvctl stop listener
srvctl start listener5.5配置TNSNAMES主备库
在主库、备库每个节点配置oracle的tnsnames.ora
其中host配置为VIPservice_name配置为listener.ora文件中的GLOBAL_DBNAMEsu - oracle
cd $ORACLE_HOME/network/admin
cp tnsnames.ora tnsnames.ora.bak
vim tnsnames.ora
ORCL_JWH (description (address_list (address (protocol tcp)(host 10.0.0.11)(port 1521))(address (protocol tcp)(host 10.0.0.12)(port 1521))(address (protocol tcp)(host 10.0.0.13)(port 1521))(address (protocol tcp)(host 10.0.0.14)(port 1521)))(connect_data (serverdedicated)(service_name orcl)))ORCL_YZG (description (address_list (address (protocol tcp)(host 10.0.0.21)(port 1521))(address (protocol tcp)(host 10.0.0.22)(port 1521))(address (protocol tcp)(host 10.0.0.23)(port 1521))(address (protocol tcp)(host 10.0.0.24)(port 1521)))(connect_data (serverdedicated)(service_name orcl_yzg)))5.6配置数据库ADG参数
主库配置如下
su - oracle
sqlplus / as sysdba
alter system set log_archive_configdg_config(orcl,orcl_yzg);
alter system set log_archive_dest_1locationuse_db_recovery_file_dest valid_for(all_logfiles,all_roles);
alter system set standby_file_managementAUTO scopespfile;
alter system set fal_serverorcl_yzg;
alter system set dg_broker_config_file1data/dr1orcldb.dat scopespfile ;
alter system set dg_broker_config_file2data/dr2orcldb.dat scopespfile ;
alter system set dg_broker_starttrue;
配置备库参数
主库
create pfile /tmp/pf from spfile;
exit
scp /tmp/pf 10.0.0.21:/tmp
备库
vi /tmp/pf
增加
db_unique_nameorcl_yzg
修改fal_serverorcl注
1检查以下参数是否配置正确
db_name
service_names
compatible11.2.0 #注意主备库一致
db_recovery_file_dest_size
db_recovery_file_destFRA
db_create_file_destDATA
sga_target
pga_aggregate_target
open_cursors
diagnostic_dest/u01/app/oracle
cluster_databasetrue
orcl1.instance_name
orcl2.instance_name
orcl1.instance_number1
orcl2.instance_number2
orcl1.undo_tablespaceUNDOTBS1
orcl2.undo_tablespaceUNDOTBS25.7 添加备库数据库服务
在备库节点1执行
su - oracle
srvctl add database -d orcl_yzg -o $ORACLE_HOME -r physical_standby -a DATA,FRA -s open
srvctl add instance -d orcl_yzg -i orcl1 -n rac1
srvctl add instance -d orcl_yzg -i orcl2 -n rac2配置备库参数文件
alter diskgroup FRA mount;
alter diskgroup DATA mount;su - oracle
sqlplus / as sysdba
startup nomount pfile/tmp/pf;
create spfileDATA from pfile/tmp/pf;
shutdown abort;
startup nomount;
show parameter spfile;
exit
srvctl modify database -d orcl_yzg -p DATA/spfileorcl.ora
srvctl config database -d orcl_yzgcreate spfile from pfile
中途可能会有DATA盘有问题的错误只是Oracle执行文件属组和权限不对。oracle:
chown oracle:asmadmin /u01/app/oracle/product/dnhome/bin/oracle
chmod 6751 u01/app/oracle/product/dnhome/bin/oraclegrid:
chwon grid:oinstall /u01/app/11.2.0/grid/bin/oracle
chmod 6751 /u01/app/11.2.0/grid/bin/oracle5.8 配置备库密码文件
su - oracle
cd $ORACLE_HOME/dbs
scp orapworcl1 10.0.0.21:/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl1
scp orapworcl1 10.0.0.22:/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl2
5.9 开始同步
1.启动备库到nomount模式
srvctl start instance -d orcl_yzg -i orcl1 -o nomount
2.暂停主库备份归档日志的自动任务
3.复制主库数据到备库
su - oracle
rman target sys/123456orcl_jwh auxiliary sys/123456orcl_yzg
duplicate target database for standby from active database nofilenamecheck;5.10 部署Broker
1.检查参数
dg_broker_start
dg_broker_config_file1
dg_broker_config_file2show parameter dg_broker;
2.部署broker
dgmgrl /
show configuration
create configuration dg as primary database is orcl connect identifier is orcl_jwh;
add database orcl_yzg as connect identifier is orcl_yzg;
enable configuration
3.检查状态
show configuration
show database verbose orcl_gsh4.修改模式edit database orcl_yzg set property LogXptModeSYNC;
edit configuration set protection mode as MaxAvailability;edit database orcl set property LogXptModeSYNC;上述检查均正常后开始进行switchover切换
主库节点1
su - oracle
dgmgrl sys/123456
show configuration;
show database verbose orcl_yzg;
switchover to orcl_yzg;
