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'