11G RAC ADG 配置

 很高兴又来和大家分享技术知识了，本次分享的技术是11G RAC环境如何配置ADG,ADG是Oracle 11G 的新特性。
 1.在主库，备库上配置tnsnames.
 1)在主库上tnsnames.ora文件中添加
 racdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = devdb)
    )
  )

 racdbdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dgnode1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dgnode2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = devdb)
    )
  )

 2)在备库上tnsnames.ora文件中添加
  racdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = devdb)
    )
  )

 racdbdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dgnode1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dgnode2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = devdb)
    )
  )
 2.修改主库的参数配置文件
 SQL>ALTER SYSTEM SET DB_UNIQUE_NAME=devdb scope=spfile;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(devdb,devdb_adg)' scope=both;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+ARCH/DEVDB/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DEVDB' SCOPE=BOTH;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=racdbdg LGWR SYNC AFFIRM  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DEVDB_ADG';
 SQL>ALTER SYSTEM SET SET STANDBY_FILE_MANAGEMNET='AUTO' SID='*' SCOPE=BOTH;
 SQL>ALTER SYSTEM SET FAL_CLIENT='racdb';
 SQL>ALTER SYSTEM SET FAL_SERVER='racdbdg';
 SQL>ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA','+DATA' SCOPE=SPFILE;
 SQL>ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+DATA','+DATA' SCOPE=SPFILE;
 3.修改备库上的参数配置文件
 SQL>ALTER SYSTEM SET DB_UNIQUE_NAME=devdb_adg scope=spfile;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_CONFILE='DG_CONFIG=(devdb,devdb_adg)' scope=both;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+ARCH/DEVDB/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DEVDB_ADG' SCOPE=BOTH;
 SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=racdb LGWR SYNC AFFIRM  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DEVDB';
 SQL>ALTER SYSTEM SET SET STANDBY_FILE_MANAGEMNET='AUTO' SID='*' SCOPE=BOTH;
 SQL>ALTER SYSTEM SET FAL_CLIENT='racdbdg';
 SQL>ALTER SYSTEM SET FAL_SERVER='racdb';
 SQL>ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA','+DATA' SCOPE=SPFILE;
 SQL>ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+DATA','+DATA' SCOPE=SPFILE;
 4.在主库上增加standby redo log
 SQL>alter database add standby logfile thread 1 group 6 '+DATA' SIZE 512M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 7 '+DATA' SIZE 512M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 GROUP 8 '+ADTA' SIZE 512M;
 SQL>ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 GROUP 9 '+DATA' SIZE 512M;
 5.修改主库强制日志模式。
 SQL>ALTER DATABASE FORCE LOGGING;
 6.使用RMAN备份主库
 rman target /
 run{
 configure device type disk;
 backup database format '/backup/devdb_%U';
 BACKUP CURRENT CONTROLFILE FORMAT '/backup/ctl_%U';
 }
 7.在主库上创建standby controlfile
 SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/BACKUP/STB_CTL';
 8.在备库上还原standby controlfile
 ASMCMD>cp /backup/stb_ctl control01.ctl
 ASMCMD>CP /BACKUP/STB_CTL control02.ctl
 9.还原备库
 SQL>STARTUP MOUNT;
 RMAN TARGET / NOCATLOG
 RUN{
 CONFIGURE DEVICE TYPE DISK;
 RESOTRE DATABASE;
 }
 10.修改备库文件名
 RMAN>CATALOG START WITH '+DATA/DEVDB/DATAFILE/'
 RMAN>SWITCH DATABASE TO COPY;
 11.生成备库的 redo file，我们采用清理redo file的方式。
 SQL>SELECT * FROM V$LOG;
 SQL>ALTER DATABASE CLEARL LOGFILE GROUP 1;
 ......
 --清理standby redo
 SQL>SELECT * FROM V$STANDBY_LOG;
 SQL>ALTER DATABASE CLEARL LOGFILE GROUP 6;
 ......
 12.开启备库实时应用模式
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

 13.备库注册DB服务，注意要使用oracle用
 srvctl  add database -d devdb_adg -o $ORACLE_HOME
 srvctl  add instance -d devdb_adg -i devdb1 -n devdbdg1 
 srvctl  add instance -d devdb_adg -i devdb2 -n devdbdg2 
 srvctl  modify database -d devdb_adg -a DATA,ARCH

---

pxboracle@live.com
2014.07.30 13:03
share you knowledge with the world.  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12798004/viewspace-1242303/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12798004/viewspace-1242303/