Oracle Dataguard（主库为双节点集群）设置详解（4）：设置备库 ...

锦通  论坛元老 | 2025-1-12 20:06:36 | 显示全部楼层 | 阅读模式
打印 上一主题 下一主题
楼主

主题 1025|帖子 1025|积分 3075

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要 登录 才可以下载或查看，没有账号？立即注册

x
Oracle Dataguard（主库为双节点集群）设置详解（4）：设置备库


  
一、为备库设置静态监听

1、设置 listener.ora 文件

  1. [oracle@racdg admin]$ vi listener.ora
  3. # listener.ora Network Configuration File: /usr/local/oracle/product/11.2.0/db_1/network/admin/listener.ora
  4. # Generated by Oracle configuration tools.
  6. LISTENER =
  7.   (DESCRIPTION_LIST =
  8.     (DESCRIPTION =
  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  10.       (ADDRESS = (PROTOCOL = TCP)(HOST = racdg)(PORT = 1521))
  11.     )
  12.   )
  14. ADR_BASE_LISTENER = /usr/local/oracle
  17. SID_LIST_LISTENER =
  18.   (SID_LIST =
  19.     (SID_DESC =
  20.      (GLOBAL_DBNAME = hisdbdg)
  21.      (ORACLE_HOME = /usr/local/oracle/product/11.2.0/db_1)
  22.      (SID_NAME = hisdg)
  23.     )
复制代码
2、重启监听、查看监听状态

  1. [oracle@racdg admin]$ lsnrctl start
  3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-JAN-2025 15:14:59
  5. Copyright (c) 1991, 2013, Oracle.  All rights reserved.
  7. Starting /usr/local/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
  9. TNSLSNR for Linux: Version 11.2.0.4.0 - Production
  10. System parameter file is /usr/local/oracle/product/11.2.0/db_1/network/admin/listener.ora
  11. Log messages written to /usr/local/oracle/diag/tnslsnr/racdg/listener/alert/log.xml
  12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdg)(PORT=1521)))
  15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  16. STATUS of the LISTENER
  17. ------------------------
  18. Alias                     LISTENER
  19. Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
  20. Start Date                10-JAN-2025 15:14:59
  21. Uptime                    0 days 0 hr. 0 min. 0 sec
  22. Trace Level               off
  23. Security                  ON: Local OS Authentication
  24. SNMP                      OFF
  25. Listener Parameter File   /usr/local/oracle/product/11.2.0/db_1/network/admin/listener.ora
  26. Listener Log File         /usr/local/oracle/diag/tnslsnr/racdg/listener/alert/log.xml
  27. Listening Endpoints Summary...
  28.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  29.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdg)(PORT=1521)))
  30. Services Summary...
  31. Service "hisdbdg" has 1 instance(s).
  32.   Instance "hisdg", status UNKNOWN, has 1 handler(s) for this service...
  33. The command completed successfully
复制代码
3、设置 tnsnames

备库的tnsnames文件设置内容与主库相同。
  1. [oracle@racdg dbs]$ vi tnsnames.ora
  3. hisdb =
  4.   (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
  6.     (CONNECT_DATA =
  7.       (SERVER = DEDICATED)
  8.       (SERVICE_NAME = hisdb)
  9.     )
  10.   )
  12. hisdb1 =
  13.   (DESCRIPTION =
  14.     (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.101)(PORT = 1521))
  15.     (CONNECT_DATA =
  16.       (SERVER = DEDICATED)
  17.       (SERVICE_NAME = hisdb)
  18.         (SID = his1)
  19.     )
  20.   )
  22. hisdb2 =
  23.   (DESCRIPTION =
  24.     (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.102)(PORT = 1521))
  25.     (CONNECT_DATA =
  26.       (SERVER = DEDICATED)
  27.       (SERVICE_NAME = hisdb)
  28.         (SID = his2)
  29.     )
  30.   )
  33. dghisdb =
  34.   (DESCRIPTION =
  35.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
  36.     (CONNECT_DATA =
  37.       (SERVER = DEDICATED)
  38.       (SERVICE_NAME = hisdbdg)
  39.     )
  40.   )
复制代码
4、测试毗连

  1. [oracle@rac02 admin]$ tnsping hisdb
  3. TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 10-JAN-2025 18:55:14
  5. Copyright (c) 1997, 2013, Oracle.  All rights reserved.
  7. Used parameter files:
  10. Used TNSNAMES adapter to resolve the alias
  11. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hisdb)))
  12. OK (0 msec)
  14. [oracle@rac02 admin]$ tnsping hisdb1
  16. TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 10-JAN-2025 18:55:17
  18. Copyright (c) 1997, 2013, Oracle.  All rights reserved.
  20. Used parameter files:
  23. Used TNSNAMES adapter to resolve the alias
  24. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.101)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hisdb) (SID = his1)
  25. ))OK (0 msec)
  27. [oracle@rac02 admin]$ tnsping hisdb2
  29. TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 10-JAN-2025 18:55:19
  31. Copyright (c) 1997, 2013, Oracle.  All rights reserved.
  33. Used parameter files:
  36. Used TNSNAMES adapter to resolve the alias
  37. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hisdb) (SID = his2)
  38. ))OK (0 msec)
  41. [oracle@rac02 admin]$ tnsping hisdbdg
  43. TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 10-JAN-2025 18:55:21
  45. Copyright (c) 1997, 2013, Oracle.  All rights reserved.
  47. Used parameter files:
  50. Used TNSNAMES adapter to resolve the alias
  51. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hisdbdg)))
  52. OK (0 msec)
复制代码
二、创建备库的 pfile 文件

1、在主库创建 pfile 文件并复制至备库

（1）在主库创建pfile文件
  1. SQL> create pfile='/home/oracle/inithisdg.ora' from spfile;
  3. File created.
复制代码
（2）把初始化参数文件复制到备库的$ORACLE_HOME/dbs目次
  1. [oracle@rac01 ~]$ pwd
  2. /home/oracle
  4. [oracle@rac01 ~]$ ll
  5. total 2487208
  6. drwxr-xr-x 7 oracle oinstall        136 Aug 27  2013 database
  7. -rw-r--r-- 1 oracle asmadmin       2021 Jan 11 10:37 inithisdg.ora
  8. -rw-r--r-- 1 oracle asmadmin       2020 Jan 10 14:13 inithis.ora
  9. -rw-r--r-- 1 oracle oinstall 1395582860 Jan  7  2020 p13390677_112040_Linux-x86-64_1of7.zip
  10. -rw-r--r-- 1 oracle oinstall 1151304589 Jan  7  2020 p13390677_112040_Linux-x86-64_2of7.zip
  12. [oracle@rac01 ~]$ scp inithisdg.ora oracle@racdg:/usr/local/oracle/product/11.2.0/db_1/dbs
  13. oracle@racdg's password:
  14. inithisdg.ora                        100% 2021     2.0KB/s   00:00   
复制代码
2、修改备库的初始化参数文件

在主库的参数文件底子上举行修改，内容如下：
  1. [oracle@racdg dbs]$ pwd
  2. /usr/local/oracle/product/11.2.0/db_1/dbs
  3. [oracle@racdg dbs]$ ll
  4. 总用量 16
  5. -rw-r--r--  1 oracle oinstall 2021 1月  11 10:41 inithisdg.ora
  6. -rw-r--r--. 1 oracle oinstall 2851 5月  15 2009 init.ora
  7. -rw-r-----  1 oracle oinstall 1536 1月  10 14:57 orapwhisdg
  8. -rw-r-----  1 oracle oinstall  914 1月  10 15:21 tnsnames.ora
  10. [oracle@rac11gstd dbs]$ vi inithisdg.ora
  11. *.__db_cache_size=385875968
  12. *.__java_pool_size=4194304
  13. *.__large_pool_size=8388608
  14. *.__oracle_base='/usr/local/oracle' #ORACLE_BASE set from environment
  15. *.__pga_aggregate_target=209715200
  16. *.__sga_target=629145600
  17. *.__shared_io_pool_size=0
  18. *.__shared_pool_size=222298112
  19. *.__streams_pool_size=0
  20. *.audit_file_dest='/usr/local/oracle/admin/hisdbdg/adump'
  21. *.audit_trail='db'
  22. *.compatible='11.2.0.4.0'
  23. *.control_files='/usr/local/oradata/hisdbdg/control01.ctl','/usr/local/oracle/fast_recovery_area/hisdbdg/control02.ctl'
  24. *.db_block_size=8192
  25. *.db_create_file_dest='/usr/local/oracle'
  26. *.db_domain=''
  27. *.db_file_name_convert='+DATA/hisdb/datafile/','/usr/local/oradata/hisdbdg/'
  28. *.db_file_name_convert='+DATA/hisdb/tempfile/','/usr/local/oradata/hisdbdg/'
  29. *.log_file_name_convert='+DATA/hisdb/onlinelog/','/usr/local/oradata/hisdbdg/'
  30. *.db_name='hisdb'
  31. *.db_unique_name='hisdbdg'
  32. *.db_recovery_file_dest='/usr/local/oracle/fast_recovery_area'
  33. *.db_recovery_file_dest_size=4621074432
  34. *.diagnostic_dest='/usr/local/oracle'
  35. *.dispatchers='(PROTOCOL=TCP) (SERVICE=hisdbXDB)'
  36. *.fal_client='hisdbdg'
  37. *.fal_server='hisdb'
  38. *.log_archive_config='dg_config=(hisdbdg,hisdb)'
  39. *.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=hisdbdg'
  40. *.log_archive_dest_2='service=hisdbdg lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=hisdb'
  41. *.log_archive_dest_state_1='enable'
  42. *.log_archive_dest_state_2='enable'
  43. *.open_cursors=300
  44. *.pga_aggregate_target=209715200
  45. *.processes=150
  46. *.remote_login_passwordfile='exclusive'
  47. *.sga_target=629145600
  48. *.standby_file_management='auto'
  49. *.undo_tablespace='UNDOTBS1'
复制代码
三、创建参数文件中涉及到的目次并启动数据库到nomount

1、创建目次

  1. # 要创建的目录如下：
  2. mkdir -p /usr/local/oracle/admin/hisdbdg/adump
  3. mkdir -p /usr/local/oracle/fast_recovery_area/hisdbdg
  4. mkdir -p /usr/local/oradata/hisdbdg/
  6. [oracle@racdg dbs]$ mkdir -p /usr/local/oracle/admin/hisdbdg/adump
  7. [oracle@racdg dbs]$ mkdir -p /usr/local/oracle/fast_recovery_area/hisdbdg
  8. [oracle@racdg dbs]$ mkdir -p /usr/local/oradata/hisdbdg/
复制代码
2、启动备库到 nomount

  1. -- 使用修改后的 pfile 文件启动备库到 nomount
  2. SQL> startup nomount pfile='$ORACLE_HOME/dbs/inithisdg.ora';
  3. ORACLE instance started.
  5. Total System Global Area  626327552 bytes
  6. Fixed Size                    2255832 bytes
  7. Variable Size                  234882088 bytes
  8. Database Buffers          385875968 bytes
  9. Redo Buffers                    3313664 bytes
  11. -- 查看备库的 db_unique_name
  12. SQL> show parameter db_unique_name
  14. NAME                                     TYPE         VALUE
  15. ------------------------------------ ----------- ------------------------------
  16. db_unique_name                             string         hisdbdg
  18. -- 生成 spfile 文件
  19. SQL> create spfile from pfile='$ORACLE_HOME/dbs/inithisdg.ora';
  21. File created.
复制代码
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
回复

使用道具 举报

0 个回复

倒序浏览
返回列表

快速回复

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 or 立即注册

本版积分规则

锦通

论坛元老
这个人很懒什么都没写!

楼主热帖

标签云

AI 运维 CIO 存储 服务器
微信订阅号
微信服务号
微信客服
小程序
H5
关于我们 商务合作 网站地图
©Copyright 2022-2024 杭州祥升科技有限公司 版权所有 浙ICP备20004199号
快速回复 返回顶部 返回列表