ORACLE19.8 RAC搭建ADG-主备都在原主机上 静态监听

最新推荐文章于 2024-05-04 00:46:47 发布
最新推荐文章于 2024-05-04 00:46:47 发布
阅读量915 收藏
点赞数
文章标签： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/132184860
版权

ORACLE19.8 RAC搭建ADG-主备都在原主机上配置关于PDB连接

标签： oracle19c

我们知道多租户环境下，pdb中建立的普通用户连接pdb需要通过tnsnames.ora或ezconnect的方式连接。而pdb的连接需要通过IP、端口和PDB服务名来连接，那么相同主机adg的情况下，备库的IP和PDB和主库是完全相同的。所以我们只能考虑通过区分端口来进行主备pdb的连接。

配置需要考虑如下步骤:

1.grid通过netca创建新的监听服务比如DGLISTENER,端口为2521（不能使用主机已经占用的端口）

2.grid用户创建好新的监听后，修改监听文件添加静态注册参数:

节点1添加实例1的名称：

 

  1.  
    DGLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=DGLISTENER)))) # line added by Agent
     
  2.  
    LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
     
  3.  
    LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
     
  4.  
    ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent
     
  5.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent
     
  6.  
    VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent
     
  7.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
     
  8.  
    VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
     
  9.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
     
  10.  
    VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
     
  11.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_DGLISTENER=ON # line added by Agent
     
  12.  
    VALID_NODE_CHECKING_REGISTRATION_DGLISTENER=SUBNET # line added by Agent
     
  13.  
    SID_LIST_LISTENER =
     
  14.  
    (SID_LIST =
     
  15.  
    (SID_DESC =
     
  16.  
    (GLOBAL_DBNAME = orcl)
     
  17.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  18.  
    (SID_NAME = orcl1)
     
  19.  
    )
     
  20.  
    (SID_DESC =
     
  21.  
    (GLOBAL_DBNAME = orcl_DGMGRL)
     
  22.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  23.  
    (SID_NAME = orcl1)
     
  24.  
    )
     
  25.  
    )
     
  26.  
    SID_LIST_DGLISTENER =
     
  27.  
    (SID_LIST =
     
  28.  
    (SID_DESC =
     
  29.  
    (GLOBAL_DBNAME = dgorcl)
     
  30.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  31.  
    (SID_NAME = dgorcl1)
     
  32.  
    )
     
  33.  
    (SID_DESC =
     
  34.  
    (GLOBAL_DBNAME = dgorcl_DGMGRL)
     
  35.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  36.  
    (SID_NAME = dgorcl1)
     
  37.  
    )
     
  38.  
    )
     
 

节点2添加实例2的名称：
 

 

  1.  
    DGLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=DGLISTENER)))) # line added by Agent
     
  2.  
    LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
     
  3.  
    LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
     
  4.  
    ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent
     
  5.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent
     
  6.  
    VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent
     
  7.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
     
  8.  
    VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
     
  9.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
     
  10.  
    VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
     
  11.  
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_DGLISTENER=ON # line added by Agent
     
  12.  
    VALID_NODE_CHECKING_REGISTRATION_DGLISTENER=SUBNET # line added by Agent
     
  13.  
    SID_LIST_LISTENER =
     
  14.  
    (SID_LIST =
     
  15.  
    (SID_DESC =
     
  16.  
    (GLOBAL_DBNAME = orcl)
     
  17.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  18.  
    (SID_NAME = orcl2)
     
  19.  
    )
     
  20.  
    (SID_DESC =
     
  21.  
    (GLOBAL_DBNAME = orcl_DGMGRL)
     
  22.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  23.  
    (SID_NAME = orcl2)
     
  24.  
    )
     
  25.  
    ) 
     
  26.  
    SID_LIST_DGLISTENER =
     
  27.  
    (SID_LIST =
     
  28.  
    (SID_DESC =
     
  29.  
    (GLOBAL_DBNAME = dgorcl)
     
  30.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  31.  
    (SID_NAME = dgorcl2)
     
  32.  
    )
     
  33.  
    (SID_DESC =
     
  34.  
    (GLOBAL_DBNAME = dgorcl_DGMGRL)
     
  35.  
    (ORACLE_HOME = /oracle/app/oracle/product/19c/dbhome_1)
     
  36.  
    (SID_NAME = dgorcl2)
     
  37.  
    )
     
  38.  
    )
     
 

重启监听：
 

srvctl stop listener -l LISTENER
 srvctl stop listener -l DGLISTENER
 srvctl start listener -l LISTENER
 srvctl start listener -l DGLISTENER
 

检查服务：
 

lsnrctl status LISTENER
 lsnrctl status DGLISTENER
 

 

3.oracle用户添加tnsnames.ora
 

两个节点内容一致，设置如下：
 

 

  1.  
    [oracle@rac1 admin]$ cat tnsnames.ora
     
  2.  
    # tnsnames.ora Network Configuration File: /oracle/app/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora
     
  3.  
    # Generated by Oracle configuration tools.
     
  4.  
    scan-orcl =
     
  5.  
    (DESCRIPTION =
     
  6.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
     
  7.  
    (CONNECT_DATA =
     
  8.  
    (SERVER = DEDICATED)
     
  9.  
    (SERVICE_NAME = orcl)
     
  10.  
    )
     
  11.  
    )
     
  12.  
    scan-dgorcl =
     
  13.  
    (DESCRIPTION =
     
  14.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 2521))
     
  15.  
    (CONNECT_DATA =
     
  16.  
    (SERVER = DEDICATED)
     
  17.  
    (SERVICE_NAME = dgorcl)
     
  18.  
    )
     
  19.  
    )
     
  20.  
    scan_orcl_pdb =
     
  21.  
    (DESCRIPTION =
     
  22.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
     
  23.  
    (CONNECT_DATA =
     
  24.  
    (SERVER = DEDICATED)
     
  25.  
    (SERVICE_NAME = pdb)
     
  26.  
    )
     
  27.  
    )
     
  28.  
    scan_dgorcl_pdb =
     
  29.  
    (DESCRIPTION =
     
  30.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 2521))
     
  31.  
    (CONNECT_DATA =
     
  32.  
    (SERVER = DEDICATED)
     
  33.  
    (SERVICE_NAME = pdb)
     
  34.  
    )
     
  35.  
    )
     
  36.  
    scan_orcl_jyc =
     
  37.  
    (DESCRIPTION =
     
  38.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
     
  39.  
    (CONNECT_DATA =
     
  40.  
    (SERVER = DEDICATED)
     
  41.  
    (SERVICE_NAME = jyc)
     
  42.  
    )
     
  43.  
    )
     
  44.  
    scan_dgorcl_jyc =
     
  45.  
    (DESCRIPTION =
     
  46.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 2521))
     
  47.  
    (CONNECT_DATA =
     
  48.  
    (SERVER = DEDICATED)
     
  49.  
    (SERVICE_NAME = jyc)
     
  50.  
    )
     
  51.  
    )
     
  52.  
    orcl =
     
  53.  
    (DESCRIPTION =
     
  54.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 1521))
     
  55.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 1521))
     
  56.  
    (CONNECT_DATA =
     
  57.  
    (SERVER = DEDICATED)
     
  58.  
    (SERVICE_NAME = orcl)
     
  59.  
    )
     
  60.  
    )
     
  62.  
    dgorcl =
     
  63.  
    (DESCRIPTION =
     
  64.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 2521))
     
  65.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 2521))
     
  66.  
    (CONNECT_DATA =
     
  67.  
    (SERVER = DEDICATED)
     
  68.  
    (SERVICE_NAME = dgorcl)
     
  69.  
    )
     
  70.  
    )
     
  71.  
    tns_orcl =
     
  72.  
    (DESCRIPTION =
     
  73.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 1521))
     
  74.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 1521))
     
  75.  
    (CONNECT_DATA =
     
  76.  
    (SERVER = DEDICATED)
     
  77.  
    (SERVICE_NAME = orcl)
     
  78.  
    )
     
  79.  
    )
     
  81.  
    tns_dgorcl =
     
  82.  
    (DESCRIPTION =
     
  83.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 2521))
     
  84.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 2521))
     
  85.  
    (CONNECT_DATA =
     
  86.  
    (SERVER = DEDICATED)
     
  87.  
    (SERVICE_NAME = dgorcl)
     
  88.  
    )
     
  89.  
    )
     
  90.  
    orcl_pdb =
     
  91.  
    (DESCRIPTION =
     
  92.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 1521))
     
  93.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 1521))
     
  94.  
    (CONNECT_DATA =
     
  95.  
    (SERVER = DEDICATED)
     
  96.  
    (SERVICE_NAME = pdb)
     
  97.  
    )
     
  98.  
    ) 
     
  99.  
    dgorcl_pdb =
     
  100.  
    (DESCRIPTION =
     
  101.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 2521))
     
  102.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 2521))
     
  103.  
    (CONNECT_DATA =
     
  104.  
    (SERVER = DEDICATED)
     
  105.  
    (SERVICE_NAME = pdb)
     
  106.  
    )
     
  107.  
    )
     
  108.  
    orcl_jyc =
     
  109.  
    (DESCRIPTION =
     
  110.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 1521))
     
  111.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 1521))
     
  112.  
    (CONNECT_DATA =
     
  113.  
    (SERVER = DEDICATED)
     
  114.  
    (SERVICE_NAME = jyc)
     
  115.  
    )
     
  116.  
    )
     
  117.  
    dgorcl_jyc =
     
  118.  
    (DESCRIPTION =
     
  119.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 2521))
     
  120.  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 2521))
     
  121.  
    (CONNECT_DATA =
     
  122.  
    (SERVER = DEDICATED)
     
  123.  
    (SERVICE_NAME = jyc)
     
  124.  
    )
     
  125.  
    )
     
 

tnsping 服务名测试，确认OK：
 

[oracle@rac1 admin]$ tnsping orcl
 

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 31-JUL-2020 11:22:18
 

Copyright (c) 1997, 2020, Oracle.  All rights reserved.
 

Used parameter files:
 


Used TNSNAMES adapter to resolve the alias
 Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
 OK (0 msec)
 [oracle@rac1 admin]$ tnsping dgorcl
 

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 31-JUL-2020 11:22:21
 

Copyright (c) 1997, 2020, Oracle.  All rights reserved.
 

Used parameter files:
 


Used TNSNAMES adapter to resolve the alias
 Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.183)(PORT = 2521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.52.184)(PORT = 2521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dgorcl)))
 OK (0 msec)
 

4.修改LOCAL_LISTENER、remote_listener
 

增加scan listener端口
 

srvctl modify scan_listener -endpoints "TCP:1521/TCP:2521"
 

节点1：
 export ORACLE_SID=orcl1
 sqlplus / as sysdba
 alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.52.183)(PORT=1521))' scope=both sid='orcl1';
 alter system set remote_listener ='rac-scan:1521' scope=both sid='orcl1';
 export ORACLE_SID=dgorcl1
 sqlplus / as sysdba
 alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.52.183)(PORT=2521))' scope=both sid='dgorcl1';
 alter system set remote_listener ='rac-scan:2521' scope=both sid='dgorcl1';
 

节点2：
 export ORACLE_SID=orcl2
 sqlplus / as sysdba
 alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.52.184)(PORT=1521))' scope=both sid='orcl2';
 alter system set remote_listener ='rac-scan:1521' scope=both sid='orcl2';
 export ORACLE_SID=dgorcl2
 sqlplus / as sysdba
 alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.52.184)(PORT=2521))' scope=both sid='dgorcl2';
 alter system set remote_listener ='rac-scan:2521' scope=both sid='dgorcl2';
 

 

 

 

 

 

 

 

 

 

 

重启监听：
 

srvctl stop listener -l LISTENER
 srvctl stop listener -l DGLISTENER
 srvctl start listener -l LISTENER
 srvctl start listener -l DGLISTENER
 

检查服务,确认端口1521只监听主库的服务，2521只监听备库的服务，基本就没问题了。一般测试过程结合数据库后台日志alert查看是否有异常，根据问题再排查处理即可。
 

lsnrctl status LISTENER
 lsnrctl status DGLISTENER
 

 

 

 

5.测试连接：
 

sqlplus sys/oracle@orcl as sysdba
 sqlplus sys/oracle@dgorcl as sysdba
 sqlplus jyc/jyc@dgorcl_pdb
 sqlplus jyc/jyc@dgorcl_jyc
 

 

 

 

[oracle@rac1 ~]$ sqlplus sys/oracle@dgorcl as sysdba
 

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 31 11:27:13 2020
 Version 19.8.0.0.0
 

Copyright (c) 1982, 2020, Oracle.  All rights reserved.
 


Connected to:
 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
 Version 19.8.0.0.0
 

SQL> show parameter name;
 

NAME                                 TYPE        VALUE
 ------------------------------------ ----------- ------------------------------
 cdb_cluster_name                     string
 cell_offloadgroup_name               string
 db_file_name_convert                 string      +DATA, +DATA
 db_name                              string      orcl
 db_unique_name                       string      dgorcl
 global_names                         boolean     FALSE
 instance_name                        string      dgorcl1
 lock_name_space                      string
 log_file_name_convert                string      +DATA, +DATA
 pdb_file_name_convert                string
 processor_group_name                 string
 

NAME                                 TYPE        VALUE
 ------------------------------------ ----------- ------------------------------
 service_names                        string      dgorcl
 SQL> select INSTANCE_NUMBER from v$instance;
 

INSTANCE_NUMBER
 ---------------
               1
 

SQL> conn jyc/jyc@dgorcl_pdb
 ERROR:
 ORA-01109: database not open
 


Warning: You are no longer connected to ORACLE.
 SQL> conn jyc/jyc@dgorcl_pdb
 ERROR:
 ORA-01109: database not open
 


SQL> conn jyc/jyc@dgorcl_jyc
 ERROR:
 ORA-01109: database not open
 


SQL> conn sys/oracle@dgorcl as sysdba
 Connected.
 SQL> show pdbs;
 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
 ---------- ------------------------------ ---------- ----------
          2 PDB$SEED                       READ ONLY  NO
          3 PDB                            MOUNTED
          4 JYC                            MOUNTED
 SQL> alter pluggable database all open instances=all;
 

Pluggable database altered.
 

SQL> show pdbs;
 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
 ---------- ------------------------------ ---------- ----------
          2 PDB$SEED                       READ ONLY  NO
          3 PDB                            READ ONLY  NO
          4 JYC                            READ ONLY  NO
 SQL> alter database recover managed standby database using current logfile disconnect;
 

Database altered.
 

SQL> set line 160
 SQL> set wrap off
 SQL> col inst_id for 99
 SQL> col FORCE_LOGGING for a4
 SQL> select INST_ID, dbid,name,DB_UNIQUE_NAME,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from gv$database
 

INST_ID       DBID NAME      DB_UNIQUE_NAME                 CURRENT_SCN PROTECTION_MODE      DATABASE_ROLE    FORC OPEN_MODE            SWITCHOVER_STATUS
 ------- ---------- --------- ------------------------------ ----------- -------------------- ---------------- ---- -------------------- --------------------
       1 1574560670 ORCL      dgorcl                             4477548 MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES  READ ONLY WITH APPLY NOT ALLOWED
       2 1574560670 ORCL      dgorcl                             4477548 MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES  READ ONLY WITH APPLY NOT ALLOWED
 

SQL> conn sys/oracle@orcl as sysdba
 Connected.
 SQL> select INST_ID, dbid,name,DB_UNIQUE_NAME,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from gv$database;
 

INST_ID       DBID NAME      DB_UNIQUE_NAME                 CURRENT_SCN PROTECTION_MODE      DATABASE_ROLE    FORC OPEN_MODE            SWITCHOVER_STATUS
 ------- ---------- --------- ------------------------------ ----------- -------------------- ---------------- ---- -------------------- --------------------
       2 1574560670 ORCL      orcl                               4477580 MAXIMUM PERFORMANCE  PRIMARY          YES  READ WRITE           TO STANDBY
       1 1574560670 ORCL      orcl                               4477580 MAXIMUM PERFORMANCE  PRIMARY          YES  READ WRITE           TO STANDBY
 

SQL> conn jyc/jyc@dgorcl_pdb
 Connected.
 SQL> conn jyc/jyc@dgorcl_jyc
 Connected.
 SQL> 
 

版权声明：本文为jycjyc原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
 

本文链接：oracle19.8 rac搭建adg-主备都在原主机上配置关于pdb连接_adg 备库pdb连接_好记忆不如烂笔头abc的博客-CSDN博客

                

        

        

    




    

      

        

            

              
                
                  jnrjian
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                      0
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    0
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      










                



	

		

			

				
					
Oracle 19c rac+adg.docx

				
			

			

				

					12-21
				

			

		

		

			
				
Oracle 19c rac+adg.docx

			
		

	



                

              
                



	

		

			

				
					
记一次el8 Oracle 21c 单机adg搭建过程

				
			

			

				

					qq_43149689的博客
				

				

					09-27
					
					569
					
				

			

		

		

			
				
el8 Oracle 21c 单机adg环境完整搭建过程

			
		

	



                


  
              

                


	

		

			

				
					
【oracle数据库安装篇三】Linux6.8单机环境oracle11g容灾ADG搭建

					
最新发布

				
			

			

				

					qq_34595089的博客
				

				

					05-04
					
					683
					
				

			

		

		

			
				
介绍了Linux6.8单机环境oracle11g容灾ADG搭建的详细过程，包含脚本和许多细节。

			
		

	





	

		

			

				
					
oracle静态监听的配置

				
			

			

				

					lltfjsy的博客
				

				

					11-20
					
					5086
					
				

			

		

		

			
				
说明：

如果没有配置静态监听，默认是动态监听的配置，动态监听的注册需要时间，一般正式环境建议配置静态监听。

配置静态监听，主要是修改listener.ora文件。防止修改出错，建议修改之间备份一下listener.ora文件。

静态静态的listener.ora文件内容如下：



红色和蓝色标注的部分根据实际情况填写。



LISTENER=

 (DESCRIPTION=

  (ADDRESS_LIST=

   (ADDRESS=(PROTOCOL=tcp)(HOST=192.1...

			
		

	



		

			
		



	

		

			

				
					
ORACLE RAC+ADG(主备RAC duplicate)

				
			

			

				

					xielong8866的博客
				

				

					10-09
					
					3395
					
				

			

		

		

			
				
ORACLE RAC+ADG(主备RAC duplicate)

			
		

	





	

		

			

				
					
Oracle搭建rac-adg。详细教程-适合小白

				
			

			

				

					qq_52860141的博客
				

				

					08-21
					
					1498
					
				

			

		

		

			
				
主库、备库、单实例adg存放目录以上便是我虚拟机以及共享磁盘存放目录。

			
		

	





	

		

			

				
					
Oracle 监听的理解、添加静态监听，动态监听

				
			

			

				

					dale
				

				

					12-03
					
					3358
					
				

			

		

		

			
				
Oracle 监听的理解、添加静态监听，动态监听

			
		

	





	

		

			

				
					
ORACLE 12C RAC 主库配置单实例ADG

				
			

			

				

					02-08
				

			

		

		

			
				
ORACLE 12C RAC 主库配置单实例 ADG  Oracle 12C RAC 主库配置单实例 ADG 是一种高可用性和灾难恢复解决方案，旨在提供高可用性和数据保护。下面将详细介绍 ORACLE 12C RAC 主库配置单实例 ADG 的知识点。  一、...

			
		

	





	

		

			

				
					
ORACLE-10gRAC-ASM-FOR-SOLARIS-安装指南.doc

				
			

			

				

					11-29
				

			

		

		

			
				
ORACLE-10gRAC-ASM-FOR-SOLARIS-安装指南  本文档主要介绍了 ORACLE 10.1.0.4 版本的 RAC+ASM 搭建在 Sun Solaris 平台下的安装指南。该文档旨在帮助用户快速搭建 ORACLE RAC+ASM 环境，以满足企业级应用的需求。  ...

			
		

	





	

		

			

				
					
oracle 11g RAC<-->单机 高可用dataguard 主备正确切换步骤

				
			

			

				

					12-07
				

			

		

		

			
				
Oracle 11g RAC高可用Dataguard 主备正确切换步骤  Oracle 11g RAC高可用Dataguard是Oracle公司推出的高可用解决方案，旨在提供高可用性和灾难恢复能力。本文将详细介绍Oracle 11g RAC高可用Dataguard 主备正确切换...

			
		

	





	

		

			

				
					
oracle 12c RAC白皮书 rac-wp-12c-1896129-zhs.pdf

				
			

			

				

					12-13
				

			

		

		

			
				
oracle 12c RAC白皮书 rac-wp-12c

			
		

	





	

		

			

				
					
【DB笔试面试733】在Oracle中，RAC中REMOTE_LISTENER的作用是什么？

				
			

			

				

					小麦苗DBA宝典
				

				

					01-17
					
					2015
					
				

			

		

		

			
				
♣题目部分在Oracle中，RAC中REMOTE_LISTENER的作用是什么？  ♣答案部分REMOTE_LISTENER参数主要用于RAC环境中监听器的远程注册，监听器的远程注...

			
		

	





	

		

			

				
					
Oracle ADG搭建

				
			

			

				

					qq_45420945的博客
				

				

					07-18
					
					443
					
				

			

		

		

			
				
Oracle11g ADG搭建

			
		

	





	

		

			

				
					
ORACLE RAC 监听配置 (listener.ora tnsnames.ora)

					
热门推荐

				
			

			

				

					乐沙弥的世界
				

				

					09-26
					
					5万+
					
				

			

		

		

			
				
Oracle RAC 监听器的配置与单实例稍有不同,但原理和实现方法基本上是相同的。在Oracle中 tns进程用于为指定网络地址上的一个或多个Oracle 实例提供服务注册，并响应来自客户端对该服务提出的连接请求。一旦连接请求到达，并派生出一个服务器进程建立服务器与用户端之间的连接(专有服务器dedicated server)或转发服务请求(共享服务器模式shared server)。如果监听器

			
		

	





	

		

			

				
					
oracle静态监听

				
			

			

				

					cuanli6286的博客
				

				

					03-19
					
					268
					
				

			

		

		

			
				
oracle静态监听和动态监听

一、什么是注册？


　　注册就是将数据库作为一个服务注册到监听程序。客户端不需要知道数据库名和实例名，只需要知道该数据库对外提供的服务名


就可以申请连接到数据库。这个...

			
		

	





	

		

			

				
					
Oracle RAC 创建ADG database

				
			

			

				

					jnrjian的博客
				

				

					01-01
					
					1078
					
				

			

		

		

			
				
beginloopend loop;end;beginloopend loop;end;

			
		

	





	

		

			

				
					
Oracle-ADG部署

				
			

			

				

					huryer的专栏
				

				

					08-15
					
					1590
					
				

			

		

		

			
				
1.  通过查看archive_log_dest_2列是否有error报错，如果有报错，则需要先根据报错内容解决问题。创建standby日志组，数量为redo日志的n+1,大小和redo一样。上面修改的参数有的需要重启数据库才能生效。netmgr,配置tns,监听。利用spfile创建pfile。......

			
		

	





	

		

			

				
					
oracle ADG平台搭建

				
			

			

				

					2301_78992416的博客
				

				

					12-11
					
					1861
					
				

			

		

		

			
				
搭建一套oracle 19C ADG 容灾环境，操作系统oracle linux7.6. oracle软件版本19.3.0.0。

			
		

	





	

		

			

				
					
oracle RAC到单实例 ADG搭建

				
			

			

				

					evil0305的博客
				

				

					09-13
					
					676
					
				

			

		

		

			
				
oracle RAC到单实例的 ADG搭建

			
		

	





	

		

			

				
					
oracle 12c rac 单机 adg 搭建

				
			

			

				

					09-12
				

			

		

		

			
				
Oracle 12c RAC（Real Application Clusters）和单机ADG（Active Data Guard）是两个独立的功能，可以用于提高数据库的可用性和容灾能力。

在Oracle 12c中，RAC允许将多个数据库实例运行在一个共享存储环境中，这些实例可以同时访问共享的数据文件。这样可以实现负载均衡和故障恢复的高可用性。通过RAC的集群架构，可以提供无中断的数据库服务，并且增加了系统的可扩展性。

ADG是Oracle提供的一种容灾解决方案，可以复制RAC集群上的数据库到另外一个地理位置的数据库服务器上，以保证在主数据库发生故障时，可以切换到备用数据库继续提供服务。使用ADG可以实现数据的冗余备份，并且备用数据库可以在物理或逻辑方式上与主数据库保持同步。

要在Oracle 12c中搭建RAC单机ADG，首先需要在RAC集群中部署主数据库和备用数据库实例。然后，在主数据库上启用ADG功能，并配置物理或逻辑数据保护。物理数据保护需要使用Data Guard进行备份和恢复，而逻辑数据保护使用GoldenGate进行数据同步。

配置ADG功能后，可以通过Data Guard Broker来管理主备数据库的切换和监控。当主数据库发生故障时，可以手动或自动执行切换操作，将备用数据库切换为主数据库继续提供服务。

总之，Oracle 12c RAC和单机ADG的搭建是一项复杂的任务，需要了解Oracle集群和容灾技术，并且仔细配置和管理主备数据库。通过合理地使用这两个功能，可以提高数据库的可用性和容灾能力，确保业务的连续性。

			
		

	



              



  
“相关推荐”对你有帮助么？

  

      
    
          
  • 
              
    
                  
                  
              
    
              
    非常没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    一般
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    有帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    非常有帮助
    
          
    • 
      

      

      

          
          提交
      

      

  




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值