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

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

fpyj.__db_cache_size=5200936960fpyj.__java_pool_size=67108864fpyj.__large_pool_size=83886080fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentfpyj.__pga_aggregate_target=2147483648fpyj.__sga_target=6442450944fpyj.__shared_io_pool_size=0fpyj.__shared_pool_size=1040187392fpyj.__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=5200936960fpyj.__java_pool_size=67108864fpyj.__large_pool_size=83886080fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentfpyj.__pga_aggregate_target=2147483648fpyj.__sga_target=6442450944fpyj.__shared_io_pool_size=0fpyj.__shared_pool_size=1040187392fpyj.__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'

 留做记录

转载于:https://www.cnblogs.com/iyoume2008/p/7493236.html