在linux as5上安装oracle11g data guard.doc

在LINUX AS5.5上安装配置ORACLE 11g DATA GUARD 安装linux as5.5操作系统 在安装操作系统的时候，建议选择安装全部软件包。 检查如下软件包是否安装，如没有安装，需要手工安装。 -Libaio-devel-*-rpm -Sysstat-*-rpm -UnixODBC-devel-*-rpm 采用如下的安装方法： #rpm –ivh libaio-devel-*-rpm 软件包所在的位置： 光盘目录/server/ 设置ORACLE用户环境变量 oracle用户的.bash_profile文件如下： PATH=$PATH:$HOME/bin export PATH export ORACLE_BASE=/oracle/app/oracle export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=ora11g export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export ORA_NLS33=$ORACLE_HOME/nls/admin/data 设置主库为force logging模式 SQL alter database force logging; 设置主库为归档模式 SQL archive log listSQL shutdown immediateSQL startup mountSQL alter database archivelog;SQL archive log list 为主库添加“备用联机日志文件” SQL alter database add standby logfile group 4(/opt/oracle/oradata/lottery/redo04.log) size 50m;?SQL alter database add standby logfile group 5 (/opt/oracle/oradata/lottery/redo05.log) size 50m;?SQL alter database add standby logfile group 6(/opt/oracle/oradata/lottery/redo06.log) size 50m; 修改主库参数pfile文件如下： ora11g.__db_cache_size=7784628224 ora11g.__java_pool_size=268435456 ora11g.__large_pool_size=268435456 ora11g.__oracle_base=/home/oracle/app#ORACLE_BASE set from environment ora11g.__pga_aggregate_target=11005853696 ora11g.__sga_target=16106127360 ora11g.__shared_io_pool_size=0 ora11g.__shared_pool_size=7516192768 ora11g.__streams_pool_size=0 *.audit_file_dest=/home/oracle/app/admin/ora11g/adump *.audit_trail=db *.compatible=.0 *.control_files=/oradata/ora11g/control01.ctl,/oradata/ora11g/control02.ctl *.db_block_size=8192 *.db_domain= *.db_name=ora11g *.diagnostic_dest=/home/oracle/app *.dispatchers=(PROTOCOL=TCP) (SERVICE=ora11gXDB) *.memory_target=27029143552 *.nls_language=SIMPLIFIED CHINESE *.nls_territory=CHINA *.open_cursors=300 *.processes=150 *.remote_login_passwordfile=EXCLUSIVE *.sessions=170 *.undo_tablespace=UNDOTBS1 *.db_unique