Oracle DataGuard一主多备配置
这里我们将介绍oracle 一主2备的配置过程(红色部分尤其注意) orcle 主库配置:pfile
cebpm.__db_cache_size=47085256704
cebpm.__java_pool_size=29360128
cebpm.__large_pool_size=33554432
cebpm.__oracle_base='/u01/app/oracle'#oracle_base set from environment
cebpm.__pga_aggregate_target=34359738368
cebpm.__sga_target=51539607552
cebpm.__shared_io_pool_size=0
cebpm.__shared_pool_size=4093640704
cebpm.__streams_pool_size=8388608
*.audit_file_dest='/u01/app/oracle/admin/cebpm/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data1/oradata/cebpm/controlfile/control01.ctl','/data2/oradata/cebpm/controlfile/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/data/oradata/cebpmxc/datafile','/data1/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data2/oradata/cebpm/datafile'
*.db_name='cebpm'
*.db_recovery_file_dest_size=42949672960
*.db_recovery_file_dest='/archivelog'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(protocol=tcp) (service=cebpmxdb)'
*.fal_client='cebpm'
*.fal_server='cebpms,cebpmxc'
*.local_listener='(address = (protocol = tcp)(host = 132.237.0.202)(port = 1550))'
*.log_archive_config='dg_config=(cebpm,cebpms,cebpmxc)'
*.log_archive_dest_1='location=/archivelog/cebpm' *.log_archive_dest_2='service=cebpms valid_for=(online_logfiles,primary_role) db_unique_name=cebpms'
*.log_archive_dest_3='service=cebpmxc valid_for=(online_logfiles,primary_role) db_unique_name=cebpmxc'
*.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable'
*.log_archive_dest_state_3='enable'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='/data/oradata/cebpmxc/redo','/data1/oradata/cebpm/redo'
*.memory_max_target=214748364800
*.memory_target=214748364800
*.open_cursors=300
*.pga_aggregate_target=0
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_max_size=0
*.sga_target=0
*.standby_file_management='auto'
*.undo_tablespace='undotbs1'
oracle 备库1配置:pfile
*.audit_file_dest='/u01/app/oracle/admin/cebpms/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data1/oradata/cebpms/controlfile/control01.ctl','/data2/oradata/cebpms/controlfile/control02.ctl'
*.db_block_size=8192
*.db_cache_size=4g
*.db_domain=''
*.db_file_name_convert='/data1/oradata/cebpm/datafile','/data1/oradata/cebpms/datafile','/data2/oradata/cebpm/datafile','/data2/oradata/cebpms/datafile','/data1/oradata/cebpm/tempfile','/data1/oradata/cebpms/tempfile'
*.db_files=8192
*.db_name='cebpm'
*.db_recovery_file_dest_size=42949672960
*.db_recovery_file_dest='/data1/oradata/cebpms/flashback'
*.db_unique_name='cebpms'
*.db_writer_processes=16
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(protocol=tcp) (service=cebpmsxdb)'
*.fal_client='cebpms'
*.fal_server='cebpm'
*.job_queue_processes=50
*.large_pool_size=2g
*.local_listener='(address = (protocol = tcp)(host = 132.237.0.205)(port = 1550))'
*.log_archive_config='dg_config=(cebpm,cebpms,cebpmxc)'
*.log_archive_dest_1='location=/data1/oradata/cebpms/archivelog'
*.log_archive_dest_2='service=cebpm valid_for=(online_logfiles,primary_role) db_unique_name=cebpm'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_dest_state_3='enable'
*.log_archive_format='%t_%s_%r.arc'
*.log_buffer=268435456
*.log_file_name_convert='/data1/oradata/cebpm/redo','/data1/oradata/cebpms/redo','/data2/oradata/cebpm/redo','/data2/oradata/cebpms/redo'
*.open_cursors=1000
*.optimizer_mode='choose'
*.pga_aggregate_target=6742343680
*.processes=4000
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=200
*.sga_max_size=20229128192
*.sga_target=20229128192
*.standby_file_management='auto'
*.undo_retention=108000
*.undo_tablespace='undotbs1'
oracle 备库2配置:pfile
*.audit_file_dest='/ybs/app/oracle/admin/cebpmxc/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data/oradata/cebpmxc/controlfile/control01.ctl','/data/oradata/cebpmxc/controlfile/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/data1/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data2/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data1/oradata/cebpm/tempfile','/data/oradata/cebpmxc/datafile'
*.db_name='cebpm'
*.db_recovery_file_dest='/data/oradata/cebpmxc/flashback'
*.db_recovery_file_dest_size=42949672960
*.db_unique_name='cebpmxc'
*.diagnostic_dest='/ybs/app/oracle'
*.dispatchers='(protocol=tcp) (service=cebpmxcxdb)'
*.fal_client='cebpmxc'
*.fal_server='cebpm'
*.log_archive_config='dg_config=(cebpmxc,cebpm,cebpms)'
*.log_archive_dest_1='location=/data/oradata/cebpmxc/archivelog'
*.log_archive_dest_3='service=cebpm valid_for=(online_logfiles,primary_role) db_unique_name=cebpm'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='/data1/oradata/cebpm/redo','/data/oradata/cebpmxc/redo','/data2/oradata/cebpm/redo','/data/oradata/cebpmxc/redo'
*.open_cursors=300
*.pga_aggregate_target=6742343680
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=20229128192
*.standby_file_management='auto'
*.undo_tablespace='undotbs1'
上一篇: 常用的git命令
推荐阅读
-
Oracle DataGuard一主多备配置
-
Oracle 11g DataGuard 物理备库配置及Active DataGuard测试
-
oracle 11g dataguard 使用dgbroker管理主备切换以及快速failover方法讲解
-
MySQL8.0.18配置多主一从
-
Centos7 Mysql 5.6 多主一从 解决方案与详细配置
-
linux 安装 MySql 5.7.20 一主多从配置【亲测】
-
Oracle 10g R2 主备自动切换之客户端Failover配置
-
MySQL配置主从服务器(一主多从)
-
Oracle10g多实例配置一例
-
配置Oracle 11g的Dataguard测试,创建物理备库(Physical Standby Database)