OGG搭建(rac到-->單例項)

quanshengaa發表於2016-06-17
原文網址 : http://blog.itpub.net/15797451/viewspace-2120333/
單例
開啟歸檔。
在兩個節點分別建立本地目錄/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部落格 ” ，連結：http://blog.itpub.net/15797451/viewspace-2120333/，如需轉載，請註明出處，否則將追究法律責任。

相關文章