主库、备库的初始化参数文件--阿里云环境

主库初始化参数文件-initfpyj.ora

fpyj.__db_cache_size=5200936960
fpyj.__java_pool_size=67108864
fpyj.__large_pool_size=83886080
fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
fpyj.__pga_aggregate_target=2147483648
fpyj.__sga_target=6442450944
fpyj.__shared_io_pool_size=0
fpyj.__shared_pool_size=1040187392
fpyj.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/fpyj/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/oradata/fpyj/controlfile/control01.ctl','/oradata/fpyj/controlfile/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oradata/fpyj/datafile','/oradata/fpyj/datafile'
*.db_name='fpyj'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=fpyjXDB)'
*.fal_client='FPYJ'
*.fal_server='FPYJBAK'
*.log_archive_config='DG_CONFIG=(fpyj,fpyjbak)'
*.log_archive_dest_1='LOCATION=/oradata/fpyj/arch_dir VALID_FOR=(all_logfiles,all_roles) db_unique_name=fpyj'
*.log_archive_dest_2='service=fpyjbak sync lgwr valid_for=(online_logfiles,primary_role) db_unique_name=fpyjbak'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_max_processes=10
*.log_file_name_convert='/oradata/fpyj/logfile','/oradata/fpyj/logfile'
*.open_cursors=300
*.pga_aggregate_target=2147483648
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=6442450944
*.undo_tablespace='UNDOTBS1'

 

备库初始化参数文件-initfpyjora

fpyj.__db_cache_size=5200936960
fpyj.__java_pool_size=67108864
fpyj.__large_pool_size=83886080
fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
fpyj.__pga_aggregate_target=2147483648
fpyj.__sga_target=6442450944
fpyj.__shared_io_pool_size=0
fpyj.__shared_pool_size=1040187392
fpyj.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/fpyj/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/oradata/fpyj/controlfile/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oradata/fpyj/datafile','/oradata/fpyj/datafile'
*.db_name='fpyj'
*.db_unique_name='FPYJBAK'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=fpyjXDB)'
*.fal_client='FPYJBAK'
*.fal_server='FPYJ'
*.log_archive_config='DG_CONFIG=(fpyj,fpyjbak)'
*.log_archive_dest_1='location=/oradata/fpyj/logfile valid_for=(all_logfiles,all_roles) db_unique_name=fpyjbak'
*.log_archive_dest_2='service=fpyj   sync lgwr valid_for=(online_logfiles,primary_role) db_unique_name=fpyj'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_max_processes=10
*.log_file_name_convert='/oradata/fpyj/logfile','/oradata/fpyj/logfile'
*.open_cursors=300
*.pga_aggregate_target=2147483648
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.service_names='FPYJ'
*.sga_max_size=8053063680
*.sga_target=6442450944
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'

 留做记录