ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > OGG搭建(rac到-->单实例)

OGG搭建(rac到-->单实例)

Oracle 作者：quanshengaa 时间：2016-06-17 10:19:29 0 删除 编辑
开启归档。
在两个节点分别创建本地目录/arch1

点击(此处)折叠或打开

  1. SQL> alter system set log_archive_dest_1 ='location=/arch1' scope=both sid='*';

  3. System altered.

  5. SQL> archive log lsit
  6. SP2-0718: illegal ARCHIVE LOG option
  7. SQL> archive log list
  8. Database log mode     No Archive Mode
  9. Automatic archival     Disabled
  10. Archive destination     /arch1
  11. Oldest online log sequence 32
  12. Current log sequence     34
两个节点都启动到mount状态然后，alter database archivelog; 执行完之后两个节点再open，你懂得否则报错：

点击(此处)折叠或打开

  1. SQL> alter database archivelog;
  2. alter database archivelog
  3. *
  4. ERROR at line 1:
  5. ORA-01126: database must be mounted in this instance and not open in any
  6. instance
因为我们在节点1配置ogg所以得配置NFS，让节点1看到节点2的归档。
在节点2上 /etc/exports添加如下内容：

点击(此处)折叠或打开

  1. /arch1 *(ro)
然后启动NFS

点击(此处)折叠或打开

  1. [root@rac2 ~]# service nfs start
  2. Starting NFS services:           [ OK ]
  3. Starting NFS quotas:             [ OK ]
  4. Starting NFS daemon:             [ OK ]
  5. Starting NFS mountd:             [ OK ]
在节点1上

点击(此处)折叠或打开

  1. [root@rac1 ~]# mkdir /arch2
  2. [root@rac1 ~]# chown -R oracle:oinstall /arch2
  3. [root@rac1 ~]# mount -t nfs 10.10.10.2:/arch1 /arch2 -o nolock
  4. [root@rac1 ~]# cd /arch2
  5. [root@rac1 arch2]# ls
  6. 1_34_876782166.dbf
添加NFS自启


配置ASM动态注册
Oracle 11g RAC的监听是用grid用户来管理的，所以用grid用户来操作。

点击(此处)折叠或打开

  1. [root@rac1 ~]# su - grid
  2. [grid@rac1 ~]$ srvctl status listener
  3. Listener LISTENER is enabled
  4. Listener LISTENER is running on node(s): rac2,rac1
  5. [grid@rac1 ~]$ lsnrctl status

  7. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-SEP-2015 17:07:10

  9. Copyright (c) 1991, 2011, Oracle. All rights reserved.

  11. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  12. STATUS of the LISTENER
  13. ------------------------
  14. Alias LISTENER
  15. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  16. Start Date 28-SEP-2015 16:30:33
  17. Uptime 0 days 0 hr. 36 min. 36 sec
  18. Trace Level off
  19. Security ON: Local OS Authentication
  20. SNMP OFF
  21. Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
  22. Listener Log File /u01/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xml
  23. Listening Endpoints Summary...
  24.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  25.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.101)(PORT=1521)))
  26.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.103)(PORT=1521)))
  27. Services Summary...
  28. Service "+ASM" has 1 instance(s).
  29.   Instance "+ASM1", status READY, has 1 handler(s) for this service...
  30. Service "prod" has 2 instance(s).
  31.   Instance "prod1", status READY, has 2 handler(s) for this service...
  32.   Instance "prod2", status READY, has 1 handler(s) for this service...
  33. Service "prodXDB" has 2 instance(s).
  34.   Instance "prod1", status READY, has 1 handler(s) for this service...
  35.   Instance "prod2", status READY, has 1 handler(s) for this service...
  36. The command completed successfully


点击(此处)折叠或打开

  1. SID_LIST_LISTENER =
  2.   (SID_LIST =
  3.     (SID_DESC =
  4.       (GLOBAL_DBNAME = ASM)
  5.       (ORACLE_HOME = /u01/11.2.0/grid)
  6.       (SID_NAME = +ASM1)
  7.     )
  8.   )

点击(此处)折叠或打开

  1. [grid@rac1 ~]$ lsnrctl status

  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-SEP-2015 17:07:10

  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.

  7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  8. STATUS of the LISTENER
  9. ------------------------
  10. Alias LISTENER
  11. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  12. Start Date 28-SEP-2015 16:30:33
  13. Uptime 0 days 0 hr. 36 min. 36 sec
  14. Trace Level off
  15. Security ON: Local OS Authentication
  16. SNMP OFF
  17. Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
  18. Listener Log File /u01/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xml
  19. Listening Endpoints Summary...
  20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  21.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.101)(PORT=1521)))
  22.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.103)(PORT=1521)))
  23. Services Summary...
  24. Service "+ASM" has 1 instance(s).
  25.   Instance "+ASM1", status READY, has 1 handler(s) for this service...
  26. Service "prod" has 2 instance(s).
  27.   Instance "prod1", status READY, has 2 handler(s) for this service...
  28.   Instance "prod2", status READY, has 1 handler(s) for this service...
  29. Service "prodXDB" has 2 instance(s).
  30.   Instance "prod1", status READY, has 1 handler(s) for this service...
  31.   Instance "prod2", status READY, has 1 handler(s) for this service...
  32. The command completed successfully
  33. [grid@rac1 ~]$ echo $ORACLE_HOME
  34. /u01/11.2.0/grid
  35. [grid@rac1 home]$ cd $ORACLE_HOME
  36. [grid@rac1 grid]$ ls
  37. assistants crf dbs evm install jlib mdns ologgerd osysmond racg slax wwg
  38. auth crs dc_ocm gipc instantclient JRE mesg OPatch oui rdbms sqlplus xdk
  39. bin csmig deinstall gns inventory ldap network opmn owm relnotes srvm
  40. cdata css demo gpnp javavm lib nls oracore perl root.sh sysman
  41. cfgtoollogs ctss diagnostics has jdbc log oc4j oraInst.loc plsql rootupgrade.sh usm
  42. clone cv eons hs jdk md ohasd ord precomp scheduler utl
  43. [grid@rac1 grid]$ pwd
  44. /u01/11.2.0/grid
  45. [grid@rac1 grid]$ cd network/admin
  46. [grid@rac1 admin]$ ll
  47. total 72
  48. -rw-r--r-- 1 grid oinstall 182 Apr 8 19:34 endpoints_listener.ora
  49. -rw-r--r-- 1 grid oinstall 184 Apr 8 19:34 listener1504087PM3409.bak
  50. -rw-r--r-- 1 grid oinstall 350 May 20 12:04 listener15052012PM0404.bak
  51. -rw-r--r-- 1 grid oinstall 350 Apr 8 19:34 listener.ora
  52. -rw-r--r-- 1 grid oinstall 184 Apr 8 19:20 listener.ora.bak.rac1
  53. drwxr-xr-x 2 grid oinstall 4096 Apr 8 18:44 samples
  54. -rw-r--r-- 1 grid oinstall 205 May 11 2011 shrept.lst
  55. -rw-r--r-- 1 grid oinstall 210 May 20 12:04 sqlnet15052012PM0404.bak
  56. -rw-r--r-- 1 grid oinstall 210 Apr 8 19:34 sqlnet.ora
  57. [grid@rac1 admin]$ cat listener.ora
  58. LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))        # line added by Agent
  59. LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))        # line added by Agent
  60. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON        # line added by Agent
  61. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON        # line added by Agent
  62. [grid@rac1 admin]$ vim listener.ora
  63. [grid@rac1 admin]$
  64. [grid@rac1 admin]$ lsnrctl reload

  66. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-SEP-2015 17:25:09

  68. Copyright (c) 1991, 2011, Oracle. All rights reserved.

  70. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  71. The command completed successfully
  72. [grid@rac1 admin]$ lsnrctl status

  74. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-SEP-2015 17:25:12

  76. Copyright (c) 1991, 2011, Oracle. All rights reserved.

  78. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  79. STATUS of the LISTENER
  80. ------------------------
  81. Alias LISTENER
  82. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
  83. Start Date 28-SEP-2015 16:30:33
  84. Uptime 0 days 0 hr. 54 min. 39 sec
  85. Trace Level off
  86. Security ON: Local OS Authentication
  87. SNMP OFF
  88. Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
  89. Listener Log File /u01/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xml
  90. Listening Endpoints Summary...
  91.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  92. Services Summary...
  93. Service "ASM" has 1 instance(s).
  94.   Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
  95. The command completed successfully
节点而一样

点击(此处)折叠或打开

  1. SID_LIST_LISTENER =
  2.   (SID_LIST =
  3.     (SID_DESC =
  4.       (GLOBAL_DBNAME = ASM)
  5.       (ORACLE_HOME = /u01/11.2.0/grid)
  6.       (SID_NAME = +ASM2)
  7.     )
  8.   )




配置TNS文件

点击(此处)折叠或打开

  1. RAC_11G =
  2.    (DESCRIPTION =
  3.      (ADDRESS_LIST =
  4.        (LOAD_BALANCE = yes)
  5.        (FAILOVER = ON)
  6.        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.103)(PORT = 1521))
  7.        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.104)(PORT = 1521))
  8.      )
  9.      (CONNECT_DATA =
  10.       (SERVICE_NAME = prod)
  11.       (failover_mode=(type=select)(mothod=basic))
  12.      )
  13.    )

  15. ASM =
  16.    (DESCRIPTION =
  17.      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.103)(PORT = 1521))
  18.      (CONNECT_DATA =
  19.       (SERVCE = DEDICATED)
  20.       (SERVICE_NAME = ASM)
  21.       (INSTANCE_NAME = +ASM1)
  22.       (UR = A)
  23.      )
  24.    )
注意这里连接ASM的配置中必须添加（UR = A），该参数表示允许远程调用，这个必须有，否则ASM实例不能连接。





安装ogg软件




继续... ...

安装完成后将数据库配置成归档，强制日志，附加日志。

点击(此处)折叠或打开

  1. SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;

  3. LOG_MODE SUPPLEME FOR
  4. ------------ -------- ---
  5. ARCHIVELOG NO NO

  7. SQL> alter database force logging;

  9. Database altered.

  11. SQL> alter database add supplemental log data;

  13. Database altered.

  15. SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;

  17. LOG_MODE SUPPLEME FOR
  18. ------------ -------- ---
  19. ARCHIVELOG YES YES
创建ogg单独的表空间及用户这是12c必须做的。

点击(此处)折叠或打开

  1. SQL> create tablespace ggs datafile '+DATA_MORMAL' size 100M autoextend on;

  3. Tablespace created.

  5. SQL> create user ggs identified by ggs default tablespace ggs temporary tablespace temp;

  7. User created.

  9. SQL> grant connect ,resource to ggs;

  11. Grant succeeded.

  13. SQL> grant execute on utl_file to ggs;

  15. Grant succeeded.



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

0
0
上一篇： 【故障解决】OGG-00446 错误解决
下一篇： 实战goldengate:安装配置+数据初始化+单向DML复制
请登录后发表评论 登录
全部评论
quanshengaa

注册时间：2013-11-08

  • 博文量
    51
  • 访问量
    125608

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593