Oracle19c DG环境准备过程
Oracle19c DG环境准备过程
配置hosts
echo "192.168.1.51 fgedu51">> /etc/hosts
echo "192.168.1.70 fgedu70">> /etc/hosts
关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service
配置目录
umount /oracle
mkdir /opt/oracle
mount /dev/sda3 /opt/oracle
vi /etc/fstab
mount /dev/sda3 /opt/oracle xfs defaults 0 0
配置yum环境
mkdir /mnt/linux
mount /dev/cdrom /mnt/linux
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[EL]" >> /etc/yum.repos.d/rac4dg.repo
echo "name =Linux 7.x DVD" >> /etc/yum.repos.d/rac4dg.repo
echo "baseurl=file:///mnt/linux" >> /etc/yum.repos.d/rac4dg.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/rac4dg.repo
echo "enabled=1" >> /etc/yum.repos.d/rac4dg.repo
cat /etc/yum.repos.d/rac4dg.repo
准备预先安装的包：
cd /mnt/hgfs/soft/
rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
根据提示安装所需要的包：
yum -y install compat-libstdc++-33 ksh libaio-devel
修改密码：
passwd oracle
手工目录授权
chown -R oracle:oinstall /opt/oracle
chmod -R 775 /opt/oracle
Oracle19c DG环境准备过程
安装oracle-database-servrer:
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
检查环境：
su - oracle
ps -ef|grep smon
echo $ORACLE_HOME
lsnrctl status
环境变量配置：
su - oracle
echo "export LANG=en_US" >> ~/.bash_profile
echo "export ORACLE_BASE=/opt/oracle" >> ~/.bash_profile
echo "export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1" >> ~/.bash_profile
echo "export ORACLE_UNQNAME=rac4dgdg" >> ~/.bash_profile
echo "export ORACLE_SID=rac4dgdg" >> ~/.bash_profile
echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG" >>
~/.bash_profile
echo "export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin" >> ~/.bash_profile
source ~/.bash_profile
env |grep ORACLE
准备备库监听配置
vi /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fgedu70)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=rac4dgdg)
(SID_NAME=rac4dgdg)
(ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)
)
)
主库配置
01.enable force logging
alter database force logging;
02.enable archivelog mode
alter system set db_recovery_file_dest_size=10g;
alter system set db_recovery_file_dest='/opt/oracle';
startup mount;
alter database archivelog;
alter database open;
alter system swtch logfile;
03.create standby redolog
alter database add standby logfile group 4 '/opt/oracle/oradata/rac4dgDB/stredo04.log'
size 200m;
alter database add standby logfile group 5 '/opt/oracle/oradata/rac4dgDB/stredo05.log'
size 200m;
alter database add standby logfile group 6 '/opt/oracle/oradata/rac4dgDB/stredo06.log'
size 200m;
alter database add standby logfile group 7 '/opt/oracle/oradata/rac4dgDB/stredo07.log'
size 200m;
主备库监听tnsnames.ora：
vi /opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora
rac4dgdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac4dgdb)
)
)
rac4dgdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.52)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rac4dgdg)
)
)
准备数据库密码文件
主库：
orapwd file=/opt/oracle/product/19c/dbhome_1/dbs/orapwrac4dgdb password=rac4dg-
123
备库
cd /opt/oracle/product/19c/dbhome_1/dbs
scp 192.168.1.51:/opt/oracle/product/19c/dbhome_1/dbs/orapwrac4dgdb .
mv orapwrac4dgdb orapwrac4dgdg
登录
sqlplus "sys/rac4dg-123@rac4dgdg as sysdba"
主库：
create pfile='/opt/oracle/pfile.ora' from spfile;
主库参数（重启生效）：
alter system set db_unique_name='rac4dgdb' scope=spfile;
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac4dgdb,rac4dgdg)' scope=both;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rac4dgdb' scope=both;
alter system set LOG_ARCHIVE_DEST_2='SERVICE=rac4dgdg LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac4dgdg'
scope=both;
alter system set fal_client='rac4dgdb' scope=both;
alter system set FAL_SERVER='rac4dgdg' scope=both;
alter system set DB_FILE_NAME_CONVERT='rac4dgDG','rac4dgDB' scope=spfile;
alter system set LOG_FILE_NAME_CONVERT='rac4dgDG','rac4dgDB' scope=spfile;
alter system set standby_file_management=AUTO scope=both;
备库参数：
vi pfile.ora
db_unique_name='rac4dgdg'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac4dgdg,rac4dgdb)'
LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rac4dgdg'
LOG_ARCHIVE_DEST_2='SERVICE=rac4dgdb LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac4dgdb'
fal_client='rac4dgdg'
FAL_SERVER='rac4dgdb'
DB_FILE_NAME_CONVERT='rac4dgDB','rac4dgDG'
LOG_FILE_NAME_CONVERT='rac4dgDB','rac4dgDG'
standby_file_management=AUTO
mkdir -p /opt/oracle/admin/rac4dgdg/adump
mkdir -p /opt/oracle/oradata/rac4dgDG
启动到nomunt;
sqlplus "sys/rac4dg-123@rac4dgdg as sysdba"
startup pfile='/opt/oracle/pfile.ora' nomount;
create spfile from pfile='/opt/oracle/pfile.ora';
shutdown immediate;
startup nomount;
创建dataguard数据库
rman target sys/rac4dg-123@rac4dgdb auxiliary sys/rac4dg-123@rac4dgdg
duplicate target database for standby from active database;
检查测试：
检查dataguard状态：
select NAME,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS
from v$database;
启动dataguard数据同步：
sqlplus "/as sysdba"
alter database recover managed standby database disconnect from session;
关闭dataguard数据同步：
alter database recover managed standby database cancel;
dataguard数据同步测试
主库：
create tablespace tdata datafile '/opt/oracle/oradata/rac4dgDB/tdata.dbf' size 10m
autoextend off;
create user tdata identified by tdata default tablespace tdata;
grant dba to tdata;
conn tdata/tdata;
create table tdata.rac4dg01(c1 varchar2(10),c2 number);
insert into rac4dg01 values('rac4dg01','1');
insert into rac4dg01 values('rac4dg02','2');
commit;
select * from tdata.rac4dg01;
alter system switch logfile;
Oracle19c DG测试过程
备库检查：
select * from tdata.rac4dg01;
检查dataguard状态：
SELECT UNIQUE THREAD#, MAX(SEQUENCE#) OVER(PARTITION BY THREAD#) LAST
FROM V$ARCHIVED_LOG;
检查dataguard日志
tail -100f /opt/oracle/diag/rdbms/rac4dgdg/rac4dgdb/trace/alert_rac4dgdg.log
tail -100f /opt/oracle/diag/rdbms/rac4dgdg/rac4dgdg/trace/alert_rac4dgdg.log
