Oracle11g Rac -> Oracle11g 单实例asm Dataguard安装部署
(Oracle11g Rac -> Oracle11g 单实例asm)
Oracle11g Rac for Aix安装
主机信息
| 主机 | 主中心节点1 | 主中心节点2 | 备中心节点1 |
|---|---|---|---|
| 操作系统 | 7100-03-05-1524 | 7100-03-05-1524 | 7100-03-05-1524 |
| 主机名 | gddb-rac1 | gddb-rac2 | gddb-rac3 |
| db_unique_name | ncloans_primary | ncloans_primary | ncloans_standby |
| db_name | ncloans_ | ncloans_ | ncloans_ |
| instance_name | ncloans1 | ncloans2 | ncloans1 |
| IP | 1.1.1.1 | 1.1.1.2 | 1.1.1.3 |
| IP_VIP | 1.1.1.11 | 1.1.1.12 | 1.1.1.13 |
| IP_PRIV | 200.200.200.74 | 200.200.200.68 | 200.200.200.72 |
| IP_SCAN | 1.1.1.10 | 1.1.1.10 | 1.1.1.20 |
| OCR | 3*5G | 3*5G | 3*5G |
| RECOVER | 500G | 500G | 500G |
| ORADATA | 4T | 4T | 4T |
资源限制配置
ln -s /etc/ssh /usr/local/etc
ln -s /usr/bin /usr/local/bin
cat /etc/security/limits.org |egrep -vp "root|oracle|grid" > /etc/security/limits
echo "root:
core = -1
cpu = -1
data = -1
fsize = -1
nofiles = -1
rss = -1
stack = -1
core_hard = -1
cpu_hard = -1
data_hard = -1
fsize_hard = -1
nofiles_hard = -1
rss_hard = -1
stack_hard = -1
oracle:
core = -1
cpu = -1
data = -1
fsize = -1
nofiles = -1
rss = -1
stack = -1
cpu_hard = -1
core_hard = -1
data_hard = -1
fsize_hard = -1
nofiles_hard = -1
rss_hard = -1
stack_hard = -1
grid:
core = -1
cpu = -1
data = -1
fsize = -1
nofiles = -1
rss = -1
stack = -1
core_hard = -1
cpu_hard = -1
data_hard = -1
fsize_hard = -1
nofiles_hard = -1
rss_hard = -1
stack_hard = -1" >> /etc/security/limits
复制用户创建以及环境变量配置
mkgroup -A id=1024 dba
mkgroup -A id=1025 asmadmin
mkgroup -A id=1026 asmdba
mkgroup -A id=1027 asmoper
mkgroup -A id=1028 oinstall
mkgroup -A id=1029 oper
mkuser -a id=1025 pgrp=oinstall groups=asmadmin,asmdba,asmoper,oinstall home=/home/grid fsize=-1 cpu=-1 data=-1 core=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
echo "grid:grid" |chpasswd pwdadm -c grid
mkuser -a id=1024 pgrp=oinstall groups=dba,oper,asmadmin,asmdba,asmoper,oinstall home=/home/oracle fsize=-1 cpu=-1 data=-1 core=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
echo "oracle:oracle" |chpasswd pwdadm -c oracle
GDDB1:/home/grid#cat .profile
#################################################################
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME
CRS_HOME=$ORACLE_HOME; export CRS_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
export LIBPATH=$ORACLE_HOME/lib
THREADS_FLAG=native; export THREADS_FLAG
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
PATH=$ORACLE_HOME/bin:$PATH:.; export PATH
#################################################################
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$ORACLE_HOME/bin:/usr/bin/X11:/sbin:.
export PATH
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
GDDB1:/home/grid#su - oracle
oracle's Password:
[YOU HAVE NEW MAIL]
GDDB1:/home/oracle#cat .profile
#########################################################
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_SID=ncloans1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
#PATH=/usr/sbin:$PATH; export PATH
#PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
export PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$ORACLE_HOME/bin:/usr/bin/X11:/sbin:.
export PATH=$ORACLE_HOME/bin:.:$PATH:/usr/local/bin:/usr/ccs/bin
export CLASSPATH=$ORACLE_HOME/jlib:.
export LIBPATH=$ORACLE_HOME/JDK/JRE/BIN:$ORACLE_HOME/jdk/jre/bin/classic:$ORACLE_HOME/lib32h
#CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#########################################################
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$ORACLE_HOME/bin:/usr/bin/X11:/sbin:.
复制系统参数配置
#逐行执行
/usr/sbin/chdev -l sys0 -a maxuproc=16384 -a ncargs=256 -a minpout=4096 -a maxpout=8193 -a fullcore=true
vmo -p -o minperm%=3
vmo -p -o maxperm%=90
vmo -p -o maxclient%=90
vmo -p -o lru_file_repage=0
vmo -p -o strict_maxclient=1
vmo -p -o strict_maxperm=0
vmo -r -o page_steal_method=1
/usr/sbin/no -r -o ipqmaxlen=512
/usr/sbin/no -p -o udp_sendspace=65536
/usr/sbin/no -p -o udp_recvspace=655360
/usr/sbin/no -p -o tcp_sendspace=65536
/usr/sbin/no -p -o tcp_recvspace=65536
/usr/sbin/no -p -o rfc1323=1
/usr/sbin/no -p -o sb_max=4194304
/usr/sbin/no -p -o ipqmaxlen=512
/usr/sbin/no -p -o tcp_ephemeral_low=9000
/usr/sbin/no -p -o tcp_ephemeral_high=65500
/usr/sbin/no -p -o udp_ephemeral_low=9000
/usr/sbin/no -p -o udp_ephemeral_high=65500
/usr/sbin/no -p -o clean_partial_conns=1
#重启系统检查参数是否更改成功
使用vmo -a或no -a检查参数是否更改成功
在/etc/rc.net文件中添加
if [ -f /usr/sbin/no ] ; then
/usr/sbin/no -o udp_sendspace=65536
/usr/sbin/no -o udp_recvspace=655360
/usr/sbin/no -o tcp_sendspace=65536
/usr/sbin/no -o tcp_recvspace=65536
/usr/sbin/no -o rfc1323=1
/usr/sbin/no -o sb_max=4194304
/usr/sbin/no -o ipqmaxlen=512
/usr/sbin/no -o tcp_ephemeral_low=9000
/usr/sbin/no -o tcp_ephemeral_high=65500
/usr/sbin/no -o udp_ephemeral_low=9000
/usr/sbin/no -o udp_ephemeral_high=65500
/usr/sbin/no -o clean_partial_conns=1
fi
复制配置互信
ssh gddb-rac2 cat ~/.ssh/id_rsa.pub >> authorized_keys ssh gddb-rac1 date;ssh gddb-rac2 date;ssh gddb-rac1-priv date;ssh gddb-rac2-priv date复制
目录创建及磁盘配置
mkdir -p /u01/app/grid mkdir -p /u01/app/oracle mkdir -p /u01/app/11.2.0 chown -R grid:oinstall /u01 chown -R oracle:oinstall /u01/app/oracle chown grid:asmadmin /dev/rhdisk1 chown grid:asmadmin /dev/rhdisk2 chown grid:asmadmin /dev/rhdisk3 chown grid:asmadmin /dev/rhdisk4 chown grid:asmadmin /dev/rhdisk5 chdev -l hdisk1 -a pv=yes chdev -l hdisk2 -a pv=yes chdev -l hdisk3 -a pv=yes chdev -l hdisk4 -a pv=yes chdev -l hdisk5 -a pv=yes chmod 660 /dev/rhdisk1 chmod 660 /dev/rhdisk2 chmod 660 /dev/rhdisk3 chmod 660 /dev/rhdisk4 chmod 660 /dev/rhdisk5 chdev -l hdisk1 -a reserve_policy=no_reserve -a algorithm=round_robin -a pv=clear chdev -l hdisk2 -a reserve_policy=no_reserve -a algorithm=round_robin -a pv=clear chdev -l hdisk3 -a reserve_policy=no_reserve -a algorithm=round_robin -a pv=clear chdev -l hdisk4 -a reserve_policy=no_reserve -a algorithm=round_robin -a pv=clear chdev -l hdisk5 -a reserve_policy=no_reserve -a algorithm=round_robin -a pv=clear ./runcluvfy.sh stage -pre crsinst -n gddb-rac3 -verbose -fixup复制
Oracle11g rac补丁升级
#补丁信息
p27923163_112040_AIX64-5L-OJVM.zip
p27967757_112040_AIX64-5L-gi20180717.zip
p6880880_112000_AIX64-5L-11.2.0.20.zip
p22241601_11204180717_AIX64-5L.zip
# rac
(grid)gddb-rac1:/opt/oracle$/u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp
(oracle)gddb-rac1:/opt/oracle$/u01/app/oracle/product/11.2.0/OPatch/ocm/bin/emocmrsp
(root)gddb-rac1:/opt/oracle#chown -R grid:oinstall 27967757
(root)gddb-rac1:/opt/oracle#chmod -R 777 27967757
(root)gddb-rac1:/opt/oracle#/u01/app/11.2.0/grid/OPatch/opatch auto ./27967757 -oh /u01/app/11.2.0/grid -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
(root)gddb-rac1:/opt/oracle#/u01/app/oracle/product/11.2.0/OPatch/opatch auto ./27967757 -oh /u01/app/oracle/product/11.2.0 -ocmrf /u01/app/oracle/product/11.2.0/OPatch/ocm/bin/ocm.rsp
(grid)gddb-rac1:/opt/oracle$/u01/app/11.2.0/grid/OPatch/opatch lspatches
(oracle)gddb-rac1:/opt/oracle$/u01/app/oracle/product/11.2.0/OPatch/opatch lspatches
复制# 单实例asm
(grid)gddb-rac3:/opt/oracle$/u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp
(oracle)gddb-rac3:/opt/oracle$/u01/app/oracle/product/11.2.0/OPatch/ocm/bin/emocmrsp
(root)gddb-rac3:/opt/oracle#chown -R grid:oinstall 27967757
(root)gddb-rac3:/opt/oracle#chmod -R 777 27967757
(root)gddb-rac3:/opt/oracle#/u01/app/11.2.0/grid/OPatch/opatch auto ./27967757 -oh /u01/app/11.2.0/grid -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
(root)gddb-rac3:/opt/oracle#/u01/app/oracle/product/11.2.0/OPatch/opatch auto ./27967757 -oh /u01/app/oracle/product/11.2.0 -ocmrf /u01/app/oracle/product/11.2.0/OPatch/ocm/bin/ocm.rsp
(grid)gddb-rac1:/opt/oracle$/u01/app/11.2.0/grid/OPatch/opatch lspatches
(oracle)gddb-rac1:/opt/oracle$/u01/app/oracle/product/11.2.0/OPatch/opatch lspatches
复制Oracle11g Rac to 单实例asm adg配置过程
#rac主库
1、开启归档日志
QL> alter database archivelog;
2、开启强制日志模式
SQL> alter database force logging;
Database altered.
SQL> select NAME,LOG_MODE,FORCE_LOGGING from v$database;
NAME LOG_MODE FORCE_
------------------ ------------------------ ------
NCLOANS_ ARCHIVELOG YES
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 10
Current log sequence 10
SQL> show parameter recover
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest string +RECOVER
db_recovery_file_dest_size big integer 100000M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
3、配置主备库监听
3.1、主库
gddb-rac2:/home/grid#crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.OCR.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ORADATA.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.RECOVER.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.asm
ONLINE ONLINE gddb-rac1 Started
ONLINE ONLINE gddb-rac2 Started
ora.gsd
OFFLINE OFFLINE gddb-rac1
OFFLINE OFFLINE gddb-rac2
ora.net1.network
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ons
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.registry.acfs
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE gddb-rac1
ora.cvu
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac1.vip
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac2.vip
1 ONLINE ONLINE gddb-rac2
ora.ncloans_primary.db
1 ONLINE ONLINE gddb-rac1 Open
2 ONLINE ONLINE gddb-rac2 Open
ora.oc4j
1 ONLINE ONLINE gddb-rac1
ora.scan1.vip
1 ONLINE ONLINE gddb-rac1
gddb-rac2:/home/grid#srvctl stop listener -n gddb-rac1
gddb-rac2:/home/grid#srvctl stop listener -n gddb-rac2
gddb-rac2:/home/grid#srvctl stop scan_listener
gddb-rac2:/home/grid#srvctl stop scan
gddb-rac2:/home/grid#crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
OFFLINE OFFLINE gddb-rac1
OFFLINE OFFLINE gddb-rac2
ora.OCR.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ORADATA.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.RECOVER.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.asm
ONLINE ONLINE gddb-rac1 Started
ONLINE ONLINE gddb-rac2 Started
ora.gsd
OFFLINE OFFLINE gddb-rac1
OFFLINE OFFLINE gddb-rac2
ora.net1.network
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ons
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.registry.acfs
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.cvu
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac1.vip
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac2.vip
1 ONLINE ONLINE gddb-rac2
ora.ncloans_primary.db
1 ONLINE ONLINE gddb-rac1 Open
2 ONLINE ONLINE gddb-rac2 Open
ora.oc4j
1 ONLINE ONLINE gddb-rac1
ora.scan1.vip
1 OFFLINE OFFLINE
gddb-rac1:/u01/app/11.2.0/grid/network/admin#vi listener.ora
gddb-rac1:/u01/app/11.2.0/grid/network/admin#cat listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
(SID_NAME = ncloans1)
)
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary_DGMGRL)
(SID_NAME = ncloans1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
SID_LIST_LISTENER_SCAN1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary)
(SID_NAME = ncloans1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
gddb-rac2:/u01/app/11.2.0/grid/network/admin#vi listener.ora
gddb-rac2:/u01/app/11.2.0/grid/network/admin#cat listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
(SID_NAME = ncloans2)
)
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary_DGMGRL)
(SID_NAME = ncloans2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
SID_LIST_LISTENER_SCAN1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_primary)
(SID_NAME = ncloans2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
gddb-rac2:/u01/app/oracle/product/11.2.0/network/admin#vi tnsnames.ora
gddb-rac2:/u01/app/oracle/product/11.2.0/network/admin#cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ncloans_primary =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gddb-primary-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ncloans_primary)
)
)
ncloans_standby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gddb-standby-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ncloans_standby)
)
)
pri_ncloans1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gddb-rac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ncloans1)
)
)
pri_ncloans2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gddb-rac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ncloans2)
)
)
stb_ncloans1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gddb-rac3-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ncloans1)
)
)
gddb-rac2:/u01/app/oracle/product/11.2.0/network/admin#scp tnsnames.ora oracle@gddb-rac1:/u01/app/oracle/product/11.2.0/network/admin
tnsnames.ora 100% 1096 1.1KB/s 00:00
gddb-rac2:/u01/app/oracle/product/11.2.0/network/admin#scp tnsnames.ora oracle@gddb-rac3:/u01/app/oracle/product/11.2.0/network/admin
tnsnames.ora 100% 1096 1.1KB/s 00:00
3.2、备库
gddb-rac3:/home/grid#srvctl stop listener -n gddb-rac3
gddb-rac3:/home/grid#srvctl stop scan_listener
gddb-rac3:/home/grid#srvctl stop scan
gddb-rac3:/u01/app/11.2.0/grid/network/admin#vi listener.ora
gddb-rac3:/u01/app/11.2.0/grid/network/admin#cat listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_standby)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
(SID_NAME = ncloans1)
)
(SID_DESC =
(GLOBAL_DBNAME = ncloans_standby_DGMGRL)
(SID_NAME = ncloans1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
SID_LIST_LISTENER_SCAN1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ncloans_standby)
(SID_NAME = ncloans1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0)
)
)
gddb-rac2:/home/grid#srvctl start listener -n gddb-rac1
gddb-rac2:/home/grid#srvctl start listener -n gddb-rac2
gddb-rac2:/home/grid#srvctl start scan_listener
gddb-rac2:/home/grid#crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.OCR.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ORADATA.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.RECOVER.dg
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.asm
ONLINE ONLINE gddb-rac1 Started
ONLINE ONLINE gddb-rac2 Started
ora.gsd
OFFLINE OFFLINE gddb-rac1
OFFLINE OFFLINE gddb-rac2
ora.net1.network
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.ons
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
ora.registry.acfs
ONLINE ONLINE gddb-rac1
ONLINE ONLINE gddb-rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE gddb-rac2
ora.cvu
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac1.vip
1 ONLINE ONLINE gddb-rac1
ora.gddb-rac2.vip
1 ONLINE ONLINE gddb-rac2
ora.ncloans_primary.db
1 ONLINE ONLINE gddb-rac1 Open
2 ONLINE ONLINE gddb-rac2 Open
ora.oc4j
1 ONLINE ONLINE gddb-rac1
ora.scan1.vip
1 ONLINE ONLINE gddb-rac2
gddb-rac3:/u01/app/11.2.0/grid/network/admin#srvctl start listener -n gddb-rac3
gddb-rac3:/u01/app/11.2.0/grid/network/admin#srvctl start scan_listener
gddb-rac3:/u01/app/11.2.0/grid/network/admin#crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE gddb-rac3
ora.OCR.dg
ONLINE ONLINE gddb-rac3
ora.ORADATA.dg
ONLINE ONLINE gddb-rac3
ora.RECOVER.dg
ONLINE ONLINE gddb-rac3
ora.asm
ONLINE ONLINE gddb-rac3 Started
ora.gsd
OFFLINE OFFLINE gddb-rac3
ora.net1.network
ONLINE ONLINE gddb-rac3
ora.ons
ONLINE ONLINE gddb-rac3
ora.registry.acfs
ONLINE ONLINE gddb-rac3
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE gddb-rac3
ora.cvu
1 ONLINE ONLINE gddb-rac3
ora.gddb-rac3.vip
1 ONLINE ONLINE gddb-rac3
ora.oc4j
1 ONLINE ONLINE gddb-rac3
ora.scan1.vip
1 ONLINE ONLINE gddb-rac3
4、同步密码文件
gddb-rac1:/u01/app/oracle/product/11.2.0/dbs#scp orapwncloans1 oracle@gddb-rac3:/u01/app/oracle/product/11.2.0/dbs
orapwncloans1 100% 1536 1.5KB/s 00:00
5、配置备库Oracle文件执行权限
gddb-rac3:/u01/app/11.2.0/grid/network/admin#ls -la /u01/app/oracle/product/11.2.0/bin/oracle
-rwsr-s--x 1 oracle oinstall 310189256 Jun 11 17:48 /u01/app/oracle/product/11.2.0/bin/oracle
gddb-rac3:/u01/app/11.2.0/grid/network/admin#ls -la /u01/app/11.2.0/grid/bin/oracle
-rwsr-s--x 1 grid oinstall 272660624 Jun 11 17:33 /u01/app/11.2.0/grid/bin/oracle
gddb-rac3:/u01/app/11.2.0/grid/network/admin#/u01/app/11.2.0/grid/bin/setasmgidwrap -o /u01/app/oracle/product/11.2.0/bin/oracle
gddb-rac3:/u01/app/11.2.0/grid/network/admin#ls -la /u01/app/oracle/product/11.2.0/bin/oracle
-rwsr-s--x 1 oracle asmadmin 310189256 Jun 11 17:48 /u01/app/oracle/product/11.2.0/bin/oracle
gddb-rac3:/u01/app/11.2.0/grid/network/admin#
6、创建standby log
#主库创建
alter database add standby logfile thread 1 group 101 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 102 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 103 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 104 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 105 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 106 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 107 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 108 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 109 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 110 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 111 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 112 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 113 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 114 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 115 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 116 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 117 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 118 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 119 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 1 group 120 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 121 ('+RECOVER','+ORADATA') size 1024m;
alter database add standby logfile thread 2 group 122 ('+RECOVER','+ORADATA') size 1024m;
7、配置主备库参数文件
7.1、配置主库参数
#ncloans_primary
#alter system set db_name='ncloans_' scope=spfile;
alter system set db_unique_name='ncloans_primary' scope=spfile sid='*';
alter system set fal_client='ncloans_primary' scope=both sid='*';
alter system set fal_server='ncloans_standby' scope=both sid='*';
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ncloans_primary,ncloans_standby)' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ncloans_primary' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=ncloans_standby lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ncloans_standby' scope=both sid='*';
alter system set log_archive_dest_state_2='ENABLE' sid='*';
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
alter system set log_archive_max_processes=8 scope=both sid='*';
alter system set db_file_name_convert='+ORADATA/ncloans_standby','+ORADATA/ncloans_primary' scope=spfile sid='*';
alter system set log_file_name_convert='+ORADATA/ncloans_standby','+ORADATA/ncloans_primary','+RECOVER/ncloans_primary','+RECOVER/ncloans_standby' scope=spfile sid='*';
alter system set standby_file_management=AUTO scope=both sid='*';
7.2、配置备库参数
#从主库创建pfile文件后传输到备库修改相关参数
gddb-rac3:/home/oracle#mkdir -p /u01/app/oracle/admin/ncloans_standby/adump
gddb-rac3:/home/oracle#sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 11 18:20:54 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='/home/oracle/standby.ora';
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5144301568 bytes
Fixed Size 2255296 bytes
Variable Size 1090520640 bytes
Database Buffers 4043309056 bytes
Redo Buffers 8216576 bytes
SQL>
#ncloans_standby
#alter system set db_name='ncloans_' scope=spfile;
alter system set db_unique_name='ncloans_standby' scope=spfile sid='*';
alter system set fal_client='ncloans_standby' scope=both sid='*';
alter system set fal_server='ncloans_primary' scope=both sid='*';
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ncloans_primary,ncloans_standby)' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ncloans_standby' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=ncloans_primary lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ncloans_primary' scope=both sid='*';
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
alter system set log_archive_dest_state_2='ENABLE' sid='*';
alter system set log_archive_max_processes=8 scope=both sid='*';
alter system set db_file_name_convert='+ORADATA/ncloans_primary','+ORADATA/ncloans_standby' scope=spfile;
alter system set log_file_name_convert='+ORADATA/ncloans_primary','+ORADATA/ncloans_standby','+RECOVER/ncloans_primary','+RECOVER/ncloans_standby' scope=spfile sid='*';
alter system set standby_file_management=AUTO scope=both sid='*';
# 参数查询
set linesize 500 pages 0
col value for a90
col name for a50
select name, value
from v$parameter
where name in ('db_name','db_unique_name','log_archive_config', 'log_archive_dest_1','log_archive_dest_2',
'log_archive_dest_state_1','log_archive_dest_state_2', 'remote_login_passwordfile',
'log_archive_format','log_archive_max_processes','fal_server','db_file_name_convert',
'log_file_name_convert', 'standby_file_management')
复制8、开始进行备库恢复操作
rman target sys/oracle@pri_ncloans1 auxiliary sys/oracle@stb_ncloans1
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate auxiliary channel ch11 device type disk;
allocate auxiliary channel ch12 device type disk;
allocate auxiliary channel ch13 device type disk;
allocate auxiliary channel ch14 device type disk;
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch11;
release channel ch12;
release channel ch13;
release channel ch14;
}
恢复完成后打开备库以及开启应用日志进程
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
复制9、备库注册实例
备注：修改控制文件信息
可能会导致控制文件问题，建议先行使用show parameter contorlfile 查看空间信息，然后修改spfile文件
#alter system set control_files='+RECOVER/ncloans_standby/controlfile/Current.257.1074968871','+ORADATA/ncloans_standby/controlfile/current.256.1074971693' scope=spfile;
SQL> create pfile='/home/oracle/3.ora' from spfile;
关闭实例创建spfile
SQL> create spfile='+ORADATA/ncloans_standby/spfilencloans_standby.ora' from pfile='/home/oracle/3.ora';
gddb-rac3:/u01/app/oracle/product/11.2.0/dbs#mv spfilencloans1.ora spfilencloans1.ora.bak
gddb-rac3:/u01/app/oracle/product/11.2.0/dbs#echo "SPFILE='+ORADATA/ncloans_standby/spfilencloans_standby.ora'" > initncloans1.ora
gddb-rac3:/u01/app/oracle/product/11.2.0/dbs#sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 15 09:50:30 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5144301568 bytes
Fixed Size 2255296 bytes
Variable Size 1090520640 bytes
Database Buffers 4043309056 bytes
Redo Buffers 8216576 bytes
Database mounted.
SQL> show parameter control
NAME TYPE VALUE
control_file_record_keep_time integer 7
control_files string +ORADATA/ncloans_standby/controlfile/current.306.1075282371,+RECOVER/ncloans_standby/controlfile/current.256.1075282373
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter database open;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
----------------------------------------
READ ONLY
SQL>
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
----------------------------------------
READ ONLY WITH APPLY
SQL> shutdown immediate
gddb-rac3:/home/oracle#srvctl add database -d ncloans_standby -o /u01/app/oracle/product/11.2.0
gddb-rac3:/home/oracle#srvctl config database -d ncloans_standby
Database unique name: ncloans_standby
Database name: ncloans
Oracle home: /u01/app/oracle/product/11.2.0
Oracle user: oracle
Spfile: +ORADATA/ncloans_standby/spfilencloans_standby.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ncloans_standby
Database instances:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed
gddb-rac3:/home/oracle#
gddb-rac3:/home/oracle#srvctl modify database -d ncloans_standby -a "ORADATA,RECOVER"
gddb-rac3:/home/oracle#srvctl add instance -d ncloans_standby -i ncloans1 -n gddb-rac3
gddb-rac3:/home/oracle#srvctl config database -d ncloans_standby
Database unique name: ncloans_standby
Database name: ncloans
Oracle home: /u01/app/oracle/product/11.2.0
Oracle user: oracle
Spfile: +ORADATA/ncloans_standby/spfilencloans_standby.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ncloans_standby
Database instances: ncloans1
Disk Groups: ORADATA,RECOVER
Mount point paths:
Services:
Type: RAC
Database is administrator managed
gddb-rac3:/home/oracle#
复制10、配置adg broker
主库：
alter system set dg_broker_config_file1='+RECOVER/dr1ncloans_primary.dat' scope=both;
alter system set dg_broker_config_file2='+ORADATA/dr2ncloans_primary.dat' scope=both;
alter system set dg_broker_start=TRUE scope=both;
备库：
alter system set dg_broker_config_file1='+RECOVER/dr1ncloans_standby.dat' scope=both;
alter system set dg_broker_config_file2='+ORADATA/dr2ncloans_standby.dat' scope=both;
alter system set dg_broker_start=TRUE scope=both;
gddb-rac1:/home/oracle#dgmgrl sys/oracle
DGMGRL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
DGMGRL> create configuration 'DG_ConFig' as primary database is 'ncloans_primary' connect identifier is 'ncloans_primary';
Configuration "DG_ConFig" created with primary database "ncloans_primary"
DGMGRL> add database 'ncloans_standby' as connect identifier is 'ncloans_standby';
Database "ncloans_standby" added
DGMGRL>
DGMGRL> shwo configuration
Unrecognized command "shwo", try "help"
DGMGRL> show configuration
Configuration - DG_ConFig
Protection Mode: MaxPerformance
Databases:
ncloans_primary - Primary database
ncloans_standby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL>
DGMGRL> show configuration
Configuration - DG_ConFig
Protection Mode: MaxPerformance
Databases:
ncloans_primary - Primary database
ncloans_standby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> switchover to ncloans_standby
Performing switchover NOW, please wait...
Operation requires a connection to instance "ncloans1" on database "ncloans_standby"
Connecting to instance "ncloans1"...
Connected.
New primary database "ncloans_standby" is opening...
Operation requires startup of instance "ncloans1" on database "ncloans_primary"
Starting instance "ncloans1"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "ncloans_standby"
DGMGRL> show configuration
Configuration - DG_ConFig
Protection Mode: MaxPerformance
Databases:
ncloans_standby - Primary database
ncloans_primary - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
复制【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
目录
