主库初始化参数文件-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' |
留做记录