网站开发 票种,朝阳网站建设开发,百度免费校园网站建设,扬中seo一、环境搭建
主机IPora19192.168.134.239ora19std192.168.134.240
1.配置yum源
1.配置网络yum源
1.删除redhat7.0系统自带的yum软件包#xff1b;
rpm -qa|grep yum oldyum.pkg 备份原信息rpm -qa|grep yum|xargs rpm -e --nodeps 不检查依赖#xff0c;直接删除…一、环境搭建
主机IPora19192.168.134.239ora19std192.168.134.240
1.配置yum源
1.配置网络yum源
1.删除redhat7.0系统自带的yum软件包
rpm -qa|grep yum oldyum.pkg 备份原信息rpm -qa|grep yum|xargs rpm -e --nodeps 不检查依赖直接删除rpm包2.自行下载所需要的软件包。包名会更新根据当前最新的下载。如有有依赖问题下载依赖包进行安装。
阿里云网络源地址https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/
网易163网络源地址http://mirrors.163.com/ CentOS
网络源地址http://centos.ustc.edu.cn/centos/
打开网页ctrlf 搜索相关yum包http://mirrors.163.com/centos/7/os/x86_64/Packages/
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-3.4.3-168.el7.centos.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-langpacks-0.4.2-7.el7.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch.rpmwget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-rhn-plugin-2.0.1-10.el7.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-utils-1.1.31-54.el7_8.noarch.rpm3.根据依赖项安装
rpm -ivh yum-*4.下载repo配置文件。
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.163.com/centos/7/atomic/x86_64/repo/CentOS-Base.repo将文件中所有的$releasever**更换为**7否则无法使用。
sed -i s/$releasever/7/g /etc/yum.repos.d/CentOS-Base.repo5下载KEY文件
wget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 http://mirrors.163.com/centos/7/os/x86_64/RPM-GPG-KEY-CentOS-76.清理yum缓存。将服务器软件包信息缓存至本地提高搜索安装效率
yum -y clean all yum -y makecache2.配置本地yum源
yum源配置
## 挂载镜像
mkdir -p /mnt/cdrom
mount /dev/sr0 /mnt/cdrom
## 编辑yum源文件
cd /etc/yum.repos.d/
vi yum.repo[base]
namebase
baseurlfile:///mnt/cdrom
enabled1
gpgcheck0
gpgkeyfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release[rootredhat yum.repos.d] yum clean all2.配置vnc
nmcli connection modify ens33 ipv4.addresses 192.168.134.240/24 ipv4.gateway 192.168.134.2 ipv4.method manual autoconnect yes1.安装vncserver
yum install tigervnc-servervncserver2.关闭selinux
sed -i s/SELINUXenforcing/SELINUXdisabled/g /etc/selinux/config
setenforce 0
getenforce3.关闭防火墙 使用root权限登录到Red Hat系统的终端。 停止当前运行的防火墙服务。可以使用以下命令 systemctl stop firewalld禁止防火墙服务在系统启动时自动启动。可以使用以下命令 systemctl disable firewalld确认防火墙服务已停止并禁用。可以使用以下命令验证 systemctl status firewalld如果输出显示 “inactive”则表示防火墙服务已成功停止并禁用。 重新启动系统以使更改生效。
3.hosts文件配置 配置hostname
hostnamectl set-hostname ora19
hostnamectl set-hostname ora19std配置hosts文件
cat EOF/etc/hosts
#Public IP
192.168.134.239 ora19
192.168.134.240 ora19std
EOF二、准备阶段
1.安装相关软件
## 安装常用软件
yum install -y vim tree net-tools unzip
## 安装Oracle依赖包
yum install -y binutils compat-libcap1 compat-libstdc-33 compat-libstdc-33.i686 glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libX11 libX11.i686 libXau libXau.i686 libXi libXi.i686 libXtst libXtst.i686 libgcc libgcc.i686 libstdc libstdc.i686 libstdc-devel libstdc-devel.i686 libxcb libxcb.i686 make nfs-utils net-tools smartmontools sysstat unixODBC unixODBC-devel gcc gcc-c libXext libXext.i686 zlib-devel zlib-devel.i6862.用户与组
## 创建oinstall、dba组与oracle用户
groupadd -g 54321 oinstall
groupadd -g 54322 dba
useradd -u 9999 -g oinstall -G dba oracle
## 设置oracle用户密码
echo oracle:123456 | chpasswd3.修改内核参数
## 修改内核参数文件
cat /etc/sysctl.conf EOF
## add for oracle
fs.file-max 6815744
kernel.sem 250 32000 100 128
kernel.shmmni 4096
kernel.shmall 1073741824
kernel.shmmax 4398046511104
kernel.panic_on_oops 1
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
net.ipv4.conf.all.rp_filter 2
net.ipv4.conf.default.rp_filter 2
fs.aio-max-nr 1048576
net.ipv4.ip_local_port_range 9000 65500
EOF
## 使其生效
/sbin/sysctl -p4.资源限制
cat /etc/security/limits.d/20-nproc.conf EOF
* soft nproc 4096
root soft nproc unlimited
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
EOF5.配置用户环境变量
su - oracle
vi ~/.bash_profile## 加入以下配置到文件尾#日志存放位置
export TMP/tmp
export TMPDIR$TMP#主机名
export ORACLE_HOSTNAMEora19
#库名称
export ORACLE_UNQNAMEoracle
export ORACLE_BASE/u01/app/oracle
export ORACLE_HOME$ORACLE_BASE/product/12.2.0.1/db_1
#库名称
export ORACLE_SIDoracleexport PATH/usr/sbin:$PATH
export PATH$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PATH/usr/sbin:$PATH
export PATH$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib6.创建相关文件目录
su root
mkdir /u01/app
mkdir /u01/app/oracle
mkdir /u01/app/oradata
mkdir /u01/app/archive
mkdir /u01/app/oracle/oraInventory
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/7.安装Oracle软件
下载Oracle安装文件 下载地址
上传文件到服务器并将压缩包授权给oracle后用oracle用户解压到$ORACLE_HOME文件夹下
su - root
cd /soft
chown -R oracle:oinstall /soft
su - oracle -c unzip -q /soft/LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.3.0/db/编辑db_install.rsp:
cd $ORACLE_HOME/install/response
cp db_install.rsp /soft
vim /soft/db_install.rsporacle.install.optionINSTALL_DB_SWONLY
UNIX_GROUP_NAMEoinstall
INVENTORY_LOCATION/u01/app/oracle/oraInventory
ORACLE_HOME/u01/app/oracle/product/12.2.0.1/db_1
ORACLE_BASE/u01/app/oracle
oracle.install.db.InstallEditionEE
oracle.install.db.OSDBA_GROUPdba
oracle.install.db.OSOPER_GROUPdba
oracle.install.db.OSBACKUPDBA_GROUPdba
oracle.install.db.OSDGDBA_GROUPdba
oracle.install.db.OSKMDBA_GROUPdba
oracle.install.db.OSRACDBA_GROUPdba
oracle.install.db.config.starterdb.typeGENERAL_PURPOSE
oracle.install.db.config.starterdb.SIDoracle静默安装Oracle软件:
cd $ORACLE_HOME
./runInstaller -silent -responseFile /soft/db_install.rsp -ignorePrereq/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/12.2.0.1/db_1/root.sh配置监听
cat /tmp/netca.rsp EOF
[GENERAL]
RESPONSEFILE_VERSION19.0
CREATE_TYPECUSTOM
[oracle.net.ca]
INSTALLED_COMPONENTS{server,net8,javavm}
INSTALL_TYPEtypical
LISTENER_NUMBER1
LISTENER_NAMES{LISTENER}
LISTENER_PROTOCOLS{TCP;1521}
LISTENER_STARTLISTENER
NAMING_METHODS{TNSNAMES,ONAMES,HOSTNAME}
NSN_NUMBER1
NSN_NAMES{EXTPROC_CONNECTION_DATA}
NSN_SERVICE{PLSExtProc}
NSN_PROTOCOLS{TCP;HOSTNAME;1521}
EOFnetca -silent -responseFile /soft/netca.rsp8.主库安装数据库实例
dbca.rsp:
vim /soft/dbca.rspgdbNameoracle
sidoracle
sysPasswordoracle
oracleHomeUserPasswordoracle
templateNameGeneral_Purpose.dbc
emExpressPort5500
totalMemory1500
datafileDestination/u01/app/oradata
characterSetZHS16GBK
nationalCharacterSetAL16UTF16
databaseTypeOLTP静默安装
dbca -silent -createDatabase -responseFile /soft/dbca.rsp检查状态
## 数据库状态
select name,db_unique_name,open_mode from v$database;## 实例状态
select instance_name,status from v$instance;备库–安装数据库软件不安装实例
备库安装数据库软件
与主库安装数据库软件基本一致
1.配置yum源
1.配置网络yum源
1.删除redhat7.0系统自带的yum软件包
rpm -qa|grep yum oldyum.pkg 备份原信息rpm -qa|grep yum|xargs rpm -e --nodeps 不检查依赖直接删除rpm包
2.自行下载所需要的软件包。包名会更新根据当前最新的下载。如有有依赖问题下载依赖包进行安装。
阿里云网络源地址https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/
网易163网络源地址http://mirrors.163.com/ CentOS
网络源地址http://centos.ustc.edu.cn/centos/
打开网页ctrlf 搜索相关yum包http://mirrors.163.com/centos/7/os/x86_64/Packages/
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-3.4.3-168.el7.centos.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-langpacks-0.4.2-7.el7.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch.rpmwget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-rhn-plugin-2.0.1-10.el7.noarch.rpm wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-utils-1.1.31-54.el7_8.noarch.rpm
3.根据依赖项安装
rpm -ivh yum-*
4.下载repo配置文件。
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.163.com/centos/7/atomic/x86_64/repo/CentOS-Base.repo
将文件中所有的$releasever**更换为**7否则无法使用。
sed -i s/$releasever/7/g /etc/yum.repos.d/CentOS-Base.repo
5下载KEY文件
wget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 http://mirrors.163.com/centos/7/os/x86_64/RPM-GPG-KEY-CentOS-7
6.清理yum缓存。将服务器软件包信息缓存至本地提高搜索安装效率
yum -y clean all yum -y makecache
配置本地yum源
yum源配置
## 挂载镜像
mkdir -p /mnt/cdrom
mount /dev/sr0 /mnt/cdrom
## 编辑yum源文件
cd /etc/yum.repos.d/
vi yum.repo[base]
namebase
baseurlfile:///mnt/cdrom
enabled1
gpgcheck0
gpgkeyfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release[rootredhat yum.repos.d] yum clean all
2.配置vnc
nmcli connection modify ens33 ipv4.addresses 192.168.134.240/24 ipv4.gateway 192.168.134.2 ipv4.method manual autoconnect yes
1.安装vncserver
yum install tigervnc-server
vncserver
2.关闭selinux
sed -i s/SELINUXenforcing/SELINUXdisabled/g /etc/selinux/config
setenforce 0
getenforce3.关闭防火墙 使用root权限登录到Red Hat系统的终端。 停止当前运行的防火墙服务。可以使用以下命令 systemctl stop firewalld 禁止防火墙服务在系统启动时自动启动。可以使用以下命令 systemctl disable firewalld 确认防火墙服务已停止并禁用。可以使用以下命令验证 systemctl status firewalld 如果输出显示 “inactive”则表示防火墙服务已成功停止并禁用。 重新启动系统以使更改生效。
3.hosts文件配置 配置hostname
hostnamectl set-hostname ora19
hostnamectl set-hostname ora19std
配置hosts文件
cat EOF/etc/hosts
#Public IP
192.168.134.239 ora19
192.168.134.240 ora19std
EOF
二、准备阶段
1.安装相关软件
## 安装常用软件
yum install -y vim tree net-tools unzip
## 安装Oracle依赖包
yum install -y binutils compat-libcap1 compat-libstdc-33 compat-libstdc-33.i686 glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libX11 libX11.i686 libXau libXau.i686 libXi libXi.i686 libXtst libXtst.i686 libgcc libgcc.i686 libstdc libstdc.i686 libstdc-devel libstdc-devel.i686 libxcb libxcb.i686 make nfs-utils net-tools smartmontools sysstat unixODBC unixODBC-devel gcc gcc-c libXext libXext.i686 zlib-devel zlib-devel.i6862.用户与组
## 创建oinstall、dba组与oracle用户
groupadd -g 54321 oinstall
groupadd -g 54322 dba
useradd -u 9999 -g oinstall -G dba oracle
## 设置oracle用户密码
echo oracle:123456 | chpasswd
3.修改内核参数
## 修改内核参数文件
cat /etc/sysctl.conf EOF
## add for oracle
fs.file-max 6815744
kernel.sem 250 32000 100 128
kernel.shmmni 4096
kernel.shmall 1073741824
kernel.shmmax 4398046511104
kernel.panic_on_oops 1
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
net.ipv4.conf.all.rp_filter 2
net.ipv4.conf.default.rp_filter 2
fs.aio-max-nr 1048576
net.ipv4.ip_local_port_range 9000 65500
EOF
## 使其生效
/sbin/sysctl -p
4.资源限制
cat /etc/security/limits.d/20-nproc.conf EOF
* soft nproc 4096
root soft nproc unlimited
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
EOF
5.配置用户环境变量
su - oracle
vi ~/.bash_profile
## 加入以下配置到文件尾#日志存放位置
export TMP/tmp
export TMPDIR$TMP#主机名
export ORACLE_HOSTNAMEora19std
#库名称
export ORACLE_UNQNAMEoraclestd
export ORACLE_BASE/u01/app/oracle
export ORACLE_HOME$ORACLE_BASE/product/12.2.0.1/db_1
#库名称
export ORACLE_SIDoraclestdexport PATH/usr/sbin:$PATH
export PATH$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PATH/usr/sbin:$PATH
export PATH$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
6.创建相关文件目录
su root
mkdir /u01/app
mkdir /u01/app/oracle
mkdir /u01/app/oradata
mkdir /u01/app/archive
mkdir /u01/app/oracle/oraInventory
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/ 7.安装Oracle软件
下载Oracle安装文件 下载地址
上传文件到服务器并将压缩包授权给oracle后用oracle用户解压到$ORACLE_HOME文件夹下
su - root
cd /soft
chown -R oracle:oinstall /soft
su - oracle -c unzip -q /soft/LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
编辑db_install.rsp:
cd $ORACLE_HOME/install/response
cp db_install.rsp /soft
vim /soft/db_install.rsporacle.install.optionINSTALL_DB_SWONLY
UNIX_GROUP_NAMEoinstall
INVENTORY_LOCATION/u01/app/oracle/oraInventory
ORACLE_HOME/u01/app/oracle/product/12.2.0.1/db_1
ORACLE_BASE/u01/app/oracle
oracle.install.db.InstallEditionEE
oracle.install.db.OSDBA_GROUPdba
oracle.install.db.OSOPER_GROUPdba
oracle.install.db.OSBACKUPDBA_GROUPdba
oracle.install.db.OSDGDBA_GROUPdba
oracle.install.db.OSKMDBA_GROUPdba
oracle.install.db.OSRACDBA_GROUPdba
oracle.install.db.config.starterdb.typeGENERAL_PURPOSE
oracle.install.db.config.starterdb.SIDoraclestd
静默安装Oracle软件:
cd $ORACLE_HOME
./runInstaller -silent -responseFile /soft/db_install.rsp -ignorePrereq/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/12.2.0.1/db_1/root.sh 配置监听
cat /soft/netca.rsp EOF
[GENERAL]
RESPONSEFILE_VERSION19.0
CREATE_TYPECUSTOM
[oracle.net.ca]
INSTALLED_COMPONENTS{server,net8,javavm}
INSTALL_TYPEtypical
LISTENER_NUMBER1
LISTENER_NAMES{LISTENER}
LISTENER_PROTOCOLS{TCP;1521}
LISTENER_STARTLISTENER
NAMING_METHODS{TNSNAMES,ONAMES,HOSTNAME}
NSN_NUMBER1
NSN_NAMES{EXTPROC_CONNECTION_DATA}
NSN_SERVICE{PLSExtProc}
NSN_PROTOCOLS{TCP;HOSTNAME;1521}
EOFnetca -silent -responseFile /soft/netca.rsp 二、主库配置
1. 开启归档
查看oracle归档状态:
archive log list
关闭数据库:
shutdown immediate;
启动数据库至mount状态:
startup mount;
修改归档位置:
alter system set log_archive_dest_1location/u01/app/archive;
/u01/app/archive用于存放归档文件的目录如果在系统中不存在需要建立并授权给oracle用户
启用归档模式和强制归档:
alter database archivelog;
alter database force logging;
alter database open;
查看修改后的归档状态:
archive log list;
切换在线日志验证归档是否正常:
alter system switch logfile;
!ls /u01/app/archive 2. redo日志
查询现有redo日志的数量:
select group#,type,member from v$logfile;
查询现有redo日志的容量:
select group#,bytes/1024/1024 as MB,status from v$log;
创建standby日志组:
容量要和redo相同数量是redo当前数量1
alter database add standby logfilegroup 6 (/u01/app/oradata/ORACLE/standby_redo04.log) size 200m reuse,group 7 (/u01/app/oradata/ORACLE/standby_redo05.log) size 200m reuse, group 8 (/u01/app/oradata/ORACLE/standby_redo06.log) size 200m reuse, group 9 (/u01/app/oradata/ORACLE/standby_redo07.log) size 200m reuse;
确认状态:
select group#,status,used from v$standby_log; 3. 文件传输
口令文件:
cd $ORACLE_HOME/dbs
cp orapworacle /soft/orapworaclestd
参数文件:
sqlplus / as sysdba
create pfile from spfile;
exit
vim initoracle.ora #数据库唯一名称
*.db_unique_nameoracle
*.log_archive_configdg_config(oracle,oraclestd)
#fal_client填写本机数据库唯一名称
*.fal_clientoracle *.fal_serveroraclestd *.log_archive_dest_1LOCATION/u01/app/archive valid_for(all_logfiles,all_roles) db_unique_nameoracle *.log_archive_dest_2serviceoraclestd lgwr async valid_for(online_logfiles,primary_role) db_unique_nameoraclestd *.log_archive_format%t_%s_%r.arc *.db_file_name_convert/u01/app/oradata/ORACLESTD/,/u01/app/oradata/ORACLE/ *.log_file_name_convert/u01/app/oradata/ORACLESTD/,/u01/app/oradata/ORACLE/
STANDBY_FILE_MANAGEMENTAUTO
启用新的参数文件:
备份之前的spfile
create pfile/soft/spfile.bak from spfile;
启用新的
shutdown immediate;
create spfile from pfile;
startup;
传输文件到备库:
scp /soft/orapworaclestd oracleora19std:/soft
scp $ORACLE_HOME/dbs/initoracle.ora oracleora19std:/soft/initoraclestd.ora
4. tns 配置
cat tnsnames.oraORACLE (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19)(PORT 1521))(CONNECT_DATA (SERVER DEDICATED)(SERVICE_NAME oracle)))LISTENER_ORACLE (ADDRESS (PROTOCOL TCP)(HOST ora19)(PORT 1521))ORACLESTD (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19std)(PORT 1521))(CONNECT_DATA (SERVER DEDICATED)(SERVICE_NAME oraclestd)))
5. 静态监听 特别注意ORACLE_HOME的路径的db_home1后面不要有’/’不然会导致sqlplus sys/oracleoracle as sysdba报错ORA-12537 cd /u01/app/oracle/product/12.2.0.1/db_1/network/admin
LISTENER (DESCRIPTION_LIST (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19)(PORT 1521))(ADDRESS (PROTOCOL IPC)(KEY EXTPROC1521))))SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME oracle)(ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1)(SID_NAME oracle)))
6. 监听重载
lsnrctl reload
7. 网络连接测试
tnsping oracle
tnsping oraclestd
三、备库配置
1. 文件处理
cd /soft
cp orapworaclestd initoraclestd.ora $ORACLE_HOME/dbs
修改参数文件
*.audit_file_dest/u01/app/oracle/admin/oraclestd/adump
*.control_files/u01/app/oradata/ORACLESTD/control01.ctl,/u01/app/oradata/ORACLESTD/control02.ctl
*.db_unique_nameoraclestd
*.log_archive_configdg_config(oracle,oraclestd)
*.fal_clientoraclestd
*.fal_serveroracle
*.log_archive_dest_1LOCATION/u01/app/archive valid_for(all_logfiles,all_roles) db_unique_nameoraclestd
*.log_archive_dest_2serviceoracle lgwr async valid_for(online_logfiles,primary_role) db_unique_nameoracle
*.log_archive_format%t_%s_%r.arc
*.db_file_name_convert/u01/app/oradata/ORACLESTD/,/u01/app/oradata/ORACLE/
*.log_file_name_convert/u01/app/oradata/ORACLESTD/,/u01/app/oradata/ORACLE/
2. 启动备库到nomount
export ORACLE_SIDoraclestd
sqlplus / as sysdba
create spfile from pfile;
startup nomount;# 修改参数standby_file_management
alter system set standby_file_managementMANUAL;
3. tns 配置
cat tnsnames.oraORACLE (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19)(PORT 1521))(CONNECT_DATA (SERVER DEDICATED)(SERVICE_NAME oracle)))LISTENER_ORACLE (ADDRESS (PROTOCOL TCP)(HOST ora19)(PORT 1521))ORACLESTD (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19std)(PORT 1521))(CONNECT_DATA (SERVER DEDICATED)(SERVICE_NAME oraclestd)))
4. 静态监听 特别注意ORACLE_HOME的路径的db_home1后面不要有’/’不然会导致sqlplus sys/oracleoracle as sysdba报错ORA-12537 LISTENER (DESCRIPTION_LIST (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST ora19std)(PORT 1521))(ADDRESS (PROTOCOL IPC)(KEY EXTPROC1521))))SID_LIST_LISTENER (SID_LIST (SID_DESC (GLOBAL_DBNAME oraclestd)(ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1)(SID_NAME oraclestd)))
5. 监听重载
lsnrctl reload
6. 网络连接测试
tnsping oracle
tnsping oraclestdsqlplus sys/oracleoracle as sysdba
sqlplus sys/oracleoraclestd as sysdba
四、构建备库
主库执行
登录到rman: connected状态主库显示DBID备库为not mounted状态是正确的
rman target sys/oracleoracle auxiliary sys/oracleoraclestd 构建备库:
run {
allocate channel ch001 type disk;
allocate channel ch002 type disk;
allocate channel ch003 type disk;
allocate channel ch004 type disk;
allocate auxiliary channel ch005 type disk;
allocate auxiliary channel ch006 type disk;
duplicate target database for standby from active database nofilenamecheck using compressed backupset;
release channel ch001;
release channel ch002;
release channel ch003;
release channel ch004;
release channel ch005;
release channel ch006;
}
备库执行
查询备库状态是否已经mount
select open_mode from v$database; 打开备库
alter database open;
检查文件:
select name from v$datafile;select name from v$tempfile;select group#,type,member from v$logfile order by 2,1;
开启日志应用:
alter database recover managed standby database using current logfile disconnect;
检查数据同步状态: 通过判断transport lag和apply lag两个参数的DATUM_TIME值来判断备库是否在应用主库的日志文件 如果多次查询DATUM_TIME值保持不变则说明备库已经停止从主库接收数据了
select name,value,TIME_COMPUTED,DATUM_TIME
from v$dataguard_stats;
检查MRP进程状态:
select process,status from v$managed_standby; 查看数据库打开状态: READ ONLY WITH APPLY代表ADG启动成功
select open_mode from v$database; 到此单实例一主一备搭建完成接下来你可以进行一些ADG操作
