主库、备库的初始化参数文件
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'
转载于:https://www.cnblogs.com/iyoume2008/p/7449099.html
相关资源：JAVA上百实例源码以及开源项目