ORACLE-11G-搭建DATAGUARD步骤.docx

ORACLE 11G 搭建DATAGUARD步骤1 安装环境在主机1上安装数据库软件，并建监听和实例，在主机2上安装数据库软件，并建监听，但不建实例。主机1主机2操作系统redhat6.1 64位redhat6.1 64位主机名dg1db2IP192.168.132.3192.168.132.4数据库软件版本oracle 11.2.0.1.0oracle 11.2.0.1.0ORACLE_BASE/oracle/app/oracle/oracle/app/oracle/ORACLE_HOME$ORACLE_BASE/product/11.2.0/db_1$ORACLE_BASE/product/11.2.0/db_1ORACLE_SIDdbtest闪回区4G归档开启2 主数据库配置2.1 设置数据库强制归档sqlplus / as sysdbaSQL ALTER DATABASE FORCE LOGGING;SQL select force_logging from v$database;FOR-YES2.2 添加STANDBY日志文件SQLalter database add standby logfile group 4 (/oradata/dbtest/redo04.log) size 50m;SQLalter database add standby logfile group 5 (/oradata/dbtest/redo05.log) size 50m;SQLalter database add standby logfile group 6 (/oradata/dbtest/redo06.log) size 50m;SQLalter database add standby logfile group 7 (/oradata/dbtest/redo07.log) size 50m;SQL select * from v$logfile order by 1; 2.3 修改参数文件2.3.1 生成pfileSQLcreate pfile from spfile;SQLshutdown immediate;2.3.2 修改pfilevi $ORACLE_HOME/dbs/initdbtest.ora在最后添加如下内容：*.db_unique_name=dbtest1*.fal_server=dbtest2*.fal_client=dbtest1*.standby_file_management=auto*.db_file_name_convert=/oradata/dbtest/,/oradata/dbtest/*.log_file_name_convert=/oradata/dbtest/,/oradata/dbtest/*.log_archive_config=dg_config=(dbtest1,dbtest2)*.log_archive_dest_2=service=dbtest2 LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=dbtest2*.log_archive_dest_state_2=ENABLE2.3.3 生成spfile SQL shutdown immediateoracledbserver01 $ cd $ORACLE_HOME/dbsoracledbserver01 dbs$ mv spfilejkfwdb.ora spfilejkfwdb.ora.bakSQL startup nomountSQL create spfile from pfile;File created.SQL show parameter uniqSQL shutdown immediate;SQL startupSQL show parameter spfile2.4 修改监听配置文件2.5 修改TNS配置文件oracledg1 admin$ cat tnsnames.ora# tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.DBTEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.132.3)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbtest1) ) )DBTEST1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.132.3)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbtest1) ) )DBTEST2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.132.4)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbtest2) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )2.6 重启监听服务lsnrctl stoplsnrctl start2.7 配置最大可用模式SQL alter database set standby database to maximize availability;Database altered.SQL exit2.8 备份数据库oracledg1 admin$ rman target /RMAN backup database plus archivelog;RMAN backup current controlfile for standby;RMAN exit备份完成后会在闪回区生产备份文件3 备数据库配置3.1 建立相应的文件目录包括dump文件目录，闪回区，数据文件目录，可以通过 show parameter dest命令查看mkdir -p /oracle/app/oracle/admin/dbtest/adumpmkdir -p /oracle/app/oracle/admin/dbtest/dpdumpmkdir -p /oracle/app/oracle/diag/rdbms/dbtest1/dbtest/tracemkdir -p /oracle/app/oracle/diag/rdbms/dbtest1/dbtest/cdumpmkdir -p /oracle/app/oracle/flash_recovery_areamkdir -p /oradata/dbtest3.2 从主数据库服务器上拷贝文件注意：下面命令在主数据库上执行3.2.1 拷贝闪回区内容oracledg1 admin$ cd /oracle/app/oracle/flash_recovery_areascp -r ./* 192.168.132.4:/oracle/app/oracle/flash_recovery_area/3.2.2 拷贝参数文件oracledg1 flash_recovery_area$ cd $ORACLE_HOME/dbsscp ./* 192.168.132.4:/oracle/app/oracle/product/11.2.0/db_1/dbs/3.2.3 拷贝密码文件3.2.4 拷贝监听文件和tns文件oracledg1 dbs$ cd ./network/admin/scp *.ora 192.168.132.4:/oracle/app/oracle/product/11.2.0/db_1/network/admin/3.3 修改监听配置文件修改ip地址3.4 修改TNS配置文件修改ip地址3.5 重启监听服务lsnrctl stoplsnrctl start3.6 修改参数文件并启动数据库到nomountCd $ORACLE_HOME/dbsCp initdbtest.ora initdbtest.ora.bakvi $ORACLE_HOME/dbs/initdbtest.ora去掉 上面添加的部分即：*.db_unique_name=dbtest1*.fal_server=dbtest2*.fal_client=dbtest13.7 恢复数据库oracledg2 admin$ rman target sys/funo1234dbtest1 auxiliary /RMAN duplicate target database for standby nofilenamecheck;RMAN exit3.8 修改参数文件oracledg2 admin$ sqlplus / as sysdbaSQL shutdown immediate;vi $ORACLE_HOME/dbs/initdbtest.ora添加如下内容*.db_unique_name=dbtest2SQL create spfile from pfile;3.9 启动数据库SQL startup nomount;SQL alter database mount standby database;SQL alter database recover managed standby database using current logfile disconnect from session; 3.10 验证主库备库均执行如下命令：SQL archive log list;主库备库如果最后一行数字相同，