Oracle11GR2DataGuard+DataGuardbroker+fast_startfailover

1、Oracle 11G R2 Data Guard+ Data Guard broker+fast_start failover第一部分 基本环境设置两台主机，dg1和dg2.系统采用oracle linux 5.7 x64dg1作为primary - 安装oracle软件并创建数据库dg2作为standby - 只安装oracle软件1.1- 编辑/etc/hosts文件10.0.2.151 dg110.0.2.152 dg21.2- 安装oracle validated包mkdir /media/diskmount /dev/cdrom /media/diskvi /etc/yum.repo

2、s.d/public-yum-el5.repooel5name = ole5.7baseurl=file:/media/disk/Server/gpgcheck=0enabled=1yum install oracle-validatedoracle-validated包会安装oracle所需的rpm包，创建oracle用户和oinstall，dba组，并自动修改内核参数等信息。这一切都是自动完成。设置oracle用户密码passwd oracle设置oracle用户的环境变量ORACLE_SID=dg1; export ORACLE_SIDORACLE_UNQNAME=dg1; export

3、 ORACLE_UNQNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOMENLS_DATE_FORMAT="YYYY-DD-MON HH24:MI:SS" export NLS_DATE_FORMATTNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMINPATH=.:$JAVA_HOME/bin:$PATH:$HOME/bin:$ORAC

4、LE_HOME/binPATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATHLD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/libexport LD_LIBRARY_PATH1.3- 创建oracle安装目录mkdir -p /u01/app/oraclechown oracle:oi

5、nstall /u01/app/oraclechmod -R 775 /u011.4- 在dg1上安装oracle软件并创建数据库1.5- 在dg2上安装oracle软件第二部分 Oracle Datagurad 设置2.1- dg1上开启数据库强制日志alter database force logging;select force_logging from v$database;2.2- dg1上添加standby logfilestandby logfile的大小要和redo log保持一致，并且要比redo log多一组。alter database add standby logfi

6、le ('/u01/app/oracle/oradata/dg1/standby_redo01.log') size 50m;alter database add standby logfile ('/u01/app/oracle/oradata/dg1/standby_redo02.log') size 50m;alter database add standby logfile ('/u01/app/oracle/oradata/dg1/standby_redo03.log') size 50m;alter database add stan

7、dby logfile ('/u01/app/oracle/oradata/dg1/standby_redo04.log') size 50m;select * from v$logfile;2.3- dg1上设置数据库归档相关参数alter system set log_archive_config='dg_config=(dg1,dg2)'alter system set log_archive_dest_2='service=dg2 async valid_for=(online_logfiles,primary_role) db_unique_n

8、ame=dg2'alter system set fal_server=dg2 scope=spfile;alter system set fal_client=dg1 scope=spfile;alter system set standby_file_management=auto;2.4- dg1上开启数据库归档并打开flashback功能shutdown immediate;startup mount;alter database archivelog;alter database flashback on;alter database open;select log_mode

9、 from v$database;2.5- 编辑dg1和dg2上tnsnames.oradg1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dg1) ) )dg2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N

10、AME = dg2) ) )2.6- dg2上配置静态注册监听LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dg2) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

11、) (SID_NAME = dg2) ) )ADR_BASE_LISTENER = /u01/app/oraclelsnrctl start2.7- dg2上创建oracle数据库的路径mkdir -p $ORACLE_BASE/oradata/dg2mkdir -p $ORACLE_BASE/admin/dg2/adumpmkdir -p $ORACLE_BASE/fast_recovery_area/dg2mkdir -p $ORACLE_BASE/fast_recovery_area/DG22.8- dg2上创建pfileecho DB_NAME=dg2 > initdg2.ora

12、2.9- 复制dg1上的密码文件到dg2scp orapwdg1 dg2:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdg2第三部分 利用RMAN复制dg1数据库3.1- 启动dg2到nomount状态SQL>startup nomount pfile=initdg2.ora3.2- 使用RMAN进行duplicate 数据库在dg1上创建duplicate_db.sql文件，包含以下内容run allocate channel c1 type disk; allocate channel c2 type disk; allocate

13、 channel c3 type disk;allocate channel c4 type disk; allocate auxiliary channel stb type disk; duplicate target database for standby from active database spfile parameter_value_convert 'dg1','dg2' SET db_unique_name='dg2' set log_archive_max_processes='8' set fal_clie

14、nt='dg2' set fal_server='dg1' set standby_file_management='AUTO' set log_archive_config='dg_config=(dg1,dg2)' set log_archive_dest_2='service=dg1 async valid_for=(online_logfiles,primary_role) db_unique_name=dg1' db_file_name_convert=('/u01/app/oracle/orad

15、ata/dg1','/u01/app/oracle/oradata/dg2') ; rmanconnect target sysconnect auxiliary sysdg2duplicate_db.sql3.3- 在dg1上查询log的信息select thread#, sequence#, first_change#,next_change# from v$archived_log order by sequence#;3.4- 在dg2上应用logSQL> select open_mode from v$database;默认是mount状态查询dg2上日

16、志接收情况，select sequence#, first_time, next_time, applied from v$archived_log order by sequence#;应用log，alter database recover managed standby database using current logfile disconnect from session;查询dg2上日志应用情况，select sequence#, first_time, next_time, applied from v$archived_log order by sequence#;3.5-

17、开启Active dataguardalter database recover managed standby database cancel;alter database open read only;alter database recover managed standby database using current logfile disconnect;第四部分 配置dataguard broker4.1- 在dg1和dg2上设置broker参数alter system set dg_broker_start = TRUE;4.2- 在dg1和dg2上编辑listener.ora文

18、件添加broker信息dg1->LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dg1) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME

19、= dg1) ) (SID_DESC = (GLOBAL_DBNAME = dg1_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dg1) ) )dg2->LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521) ) )SID_LIST_LISTENER

20、 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dg2) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dg2) ) (SID_DESC = (GLOBAL_DBNAME = dg2_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dg2) ) )修改完成后，在dg1和dg2上重新启动监听。lsnrctl stoplsnrctl start4.3- 配置dg br

21、oker在dg1上dgmgrlconnect syscreate configuration 'my_dg_broker' as primary database is 'dg1' connect identifier is dg1;add database 'dg2' as connect identifier is dg2 maintained as physical;enable configurationshow configuration4.4- 手动切换dg2为primary roleswitchover to dg2;show database verbose dg2;switchover to dg1;4.5- 配置fast_start failover打开dg2上flashback功能shutdown immediate; startup mount; alter database flashback on;dg