主库、备库的初始化参数文件
2017年8月25日
11:02
主库初始化参数文件-initfpyj.ora
|
fpyj.__db_cache_size=92274688 fpyj.__java_pool_size=4194304 fpyj.__large_pool_size=4194304 fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment fpyj.__pga_aggregate_target=209715200 fpyj.__sga_target=314572800 fpyj.__shared_io_pool_size=0 fpyj.__shared_pool_size=201326592 fpyj.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/fpyj/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/oradata02/fpyj/1107/control01.ctl','/oradata02/fpyj/1107/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_file_name_convert='/oradata02/fpyjbak/1107/','/oradata02/fpyj/1107' *.db_name='fpyj' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=fpyjXDB)' *.log_archive_config='DG_CONFIG=(fpyj,fpyj123)' *.log_archive_dest_1='LOCATION=/home/oracle/arch_dir/fpyj VALID_FOR=(all_logfiles,all_roles) db_unique_name=fpyj' *.log_archive_dest_2='SERVICE=fpyj123 LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=fpyj123' *.log_archive_dest_state_2='enable' *.log_file_name_convert='/oradata02/fpyjbak/1107/','/oradata02/fpyj/1107' *.memory_target=524288000 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1' |
备库初始化参数文件-initfpyj123.ora
|
fpyj.__db_cache_size=92274688 fpyj123.__db_cache_size=352321536 fpyj.__java_pool_size=4194304 fpyj123.__java_pool_size=4194304 fpyj.__large_pool_size=4194304 fpyj123.__large_pool_size=4194304 fpyj.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment fpyj123.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment fpyj.__pga_aggregate_target=209715200 fpyj123.__pga_aggregate_target=524288000 fpyj.__sga_target=314572800 fpyj123.__sga_target=524288000 fpyj.__shared_io_pool_size=0 fpyj123.__shared_io_pool_size=0 fpyj.__shared_pool_size=201326592 fpyj123.__shared_pool_size=150994944 fpyj.__streams_pool_size=0 fpyj123.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/fpyj123/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/oradata02/fpyj123/control01.ctl' *.db_block_size=8192 *.db_domain='' *.db_file_name_convert='/oradata02/fpyj','/oradata02/fpyj123' *.db_name='fpyj' *.db_unique_name='fpyj123' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=fpyjXDB)' *.fal_client='fpyj123' *.fal_server='fpyj' *.log_archive_config='DG_CONFIG=(fpyj,fpyj123)' *.log_archive_dest_1='location=/home/oracle/arch_dir/fpyj123 valid_for=(all_logfiles,all_roles) db_unique_name=fpyj123' *.log_archive_dest_2='SERVICE=FPYJ SYNC VALID_FOR=( ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=fpyj' *.log_archive_dest_2='SERVICE=fpyj LGWR SYNC VALID_FOR=(all_logfiles,all_roles) db_unique_name=fpyj' *.log_archive_dest_state_2='enable' *.log_file_name_convert='/oradata02/fpyj','/oradata02/fpyj123' *.memory_target=1048576000 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_max_size=524288000 *.standby_file_management='auto' *.undo_tablespace='UNDOTBS1' |