《oracle11gadg搭建手册(rman+目录异构)》由会员分享，可在线阅读，更多相关《oracle11gadg搭建手册(rman+目录异构)（11页珍藏版）》请在金锄头文库上搜索。
1、#规划时注意的事项db_name必须保持一致，db_unique_name必须保持不一致主库安装软件、数据库、监听，备库只安装软件、监听，不安装数据库#操作系统层面的操作#安装32位依赖包rpm -ivh compat-libstdc+-33-3.2.3-69.el6.i686.rpmrpm -ivh glibc-devel-2.12-1.132.el6.i686.rpmrpm -ivh libaio-0.3.107-10.el6.i686.rpmrpm -ivh libstdc+-4.4.7-4.el6.i686.rpmrpm -ivh libstdc+-devel-4.4.7-4.el6.
2、i686.rpmrpm -ivh libtool-ltdl-2.2.6-15.5.el6.i686.rpmrpm -ivh libtool-ltdl-devel-2.2.6-15.5.el6.i686.rpmrpm -ivh ncurses-libs-5.7-3.20090208.el6.i686.rpmrpm -ivh ncurses-devel-5.7-3.20090208.el6.i686.rpmrpm -ivh readline-6.0-4.el6.i686.rpmrpm -ivh readline-devel-6.0-4.el6.i686.rpmrpm -ivh unixODBC-2
3、.2.14-12.el6_3.i686.rpmrpm -ivh unixODBC-devel-2.2.14-12.el6_3.i686.rpm#建立目录mkdir -p /data/pri/mkdir -p /data/pri/oradatamkdir -p /data/pri/archmkdir -p /data/pri/redomkdir -p /data/pri/oradata_bakmkdir -p /data/pri/product/11.2.0/db_1mkdir -p /data/pri/fast_recovery_areamkdir -p /data/pri/oraInvent
4、orymkdir -p /data/std/mkdir -p /data/std/oradatamkdir -p /data/std/archmkdir -p /data/std/redomkdir -p /data/std/oradata_bakmkdir -p /data/std/product/11.2.0/db_1mkdir -p /data/std/fast_recovery_areamkdir -p /data/std/oraInventory#创建Oracle账户groupadd oinstallgroupadd dbauseradd -g oinstall -G dba -m
5、oraclepasswd oracle#修改主库操作系统Oracle用户环境变量vi /.bash_profileLANG=enORACLE_BASE=/data/pri/oracleORACLE_SID=priORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1PATH=$ORACLE_HOME/bin:$PATH:$HOME/binLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libCLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jli
6、bexport PATH LANG DISPLAY ORACLE_BASE ORACLE_SID ORACLE_HOME LD_LIBRARY_PATH CLASSPATHvi /.bash_profileLANG=enORACLE_BASE=/data/std/oracleORACLE_SID=stdORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1PATH=$ORACLE_HOME/bin:$PATH:$HOME/binLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libCLASSPATH=$ORACLE_HOM
7、E/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport PATH LANG DISPLAY ORACLE_BASE ORACLE_SID ORACLE_HOME LD_LIBRARY_PATH CLASSPATH#修改系统参数vi /etc/pam.d/loginsession required /lib64/security/pam_limits.sovi /etc/security/limits.conforacle soft nproc 65536oracle hard nproc 65536oracle soft nofile 655
8、36oracle hard nofile 65536oracle soft stack 102405vi /etc/sysctl.conf# Controls the maximum shared segment size, in bytes# 定义单个共享内存段的最大值kernel.shmmax = 68719476736# Controls the maximum number of shared memory segments, in pages# 参数是控制共享内存页数,每页大小为4KBkernel.shmall = 4294967296# 共享内存段的最大数量kernel.shmmn
9、i = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576sysctl -pvi /etc/security/limits.d/90-nproc.conf* soft nproc 65536#修改目录权限chown -R oracle:oinstall /data/chm
10、od -R 755 /data/chown -R oracle:oinstall /opt/database/#在两台服务器数据库层面上都做的操作- 查看是否安装了DG功能select * from v$option where parameter = Oracle Data Guard;#开启归档和设置DG模式(pri主库上操作)shutdown immediate;startup mount;alter database archivelog; #开启归档模式alter system set db_recovery_file_dest=; #更改oracl系统，禁止往闪回恢复区放归档日志a
11、lter system set log_archive_format=%t_%s_%r.arc scope=spfile; #修改归档日志格式alter system set log_archive_dest_1=location=/data/pri/arch scope=both; #设置归档路径位置select log_mode from v$database;archive log list; #确认归档结果#设置DG模式，默认是最高性能，maximize后可跟PROTECTION | AVAILABILITY | PERFORMANCE，分别对应最大保护，最高可用性及最高性能。#新建D
12、G的时候，只能用最高性能，用最大保护和最高可用会报错，无法启动数据库。#alter database set standby database to maximize availability; #select protection_mode,protection_level from v$database; #查看DG模式# select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;#开启强制归档alter database force logging;#设置、查看、打开闪回恢复区alter system se
13、t db_recovery_file_dest=/data/pri/fast_recovery_area; #设置主库alter system set db_recovery_file_dest=/data/std/fast_recovery_area; #设置从库alter system set db_recovery_file_dest_size=500M;alter database flashback on;select flashback_on from v$database;#开启global_namesalter system set global_names=true;show
14、 parameter global_names;select * from global_name;#在pri主库上执行的操作#pri主库修改参数控制文件#在pri主库上手动执行添加参数的命令alter system set log_archive_config=dg_config=(pri,std) scope=both;alter system set log_archive_dest_1=location=/data/pri/arch valid_for=(all_logfiles,all_roles) db_unique_name=pri scope=both;alter system
15、 set log_archive_dest_2=service=std reopen=120 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=std scope=both;alter system set standby_file_management=auto scope=both;alter system set fal_server=std scope=both;alter system set db_file_name_convert=/data/std/oradata/std/,/data/pri/oradata/pri/ scope=spfile;alter system set log_file_name_convert=/data/std/arch/,/data/pri/arch/ scope=spfile;show parameter convert;
