Production Oracle RAC prdrac Initialization Parameters
Oracle Far Sync prdfs Initialization Parameters
Disaster Recovery Oracle RAC prddg Initialization Parameters

 

Production Oracle RAC prdrac Initialization Parameters

prdrac01.audit_file_dest='/u01/admin/prdrac01/adump'
prdrac02.audit_file_dest='/u01/admin/prdrac02/adump'
*.audit_sys_operations=TRUE
*.audit_trail='db'
*.awr_pdb_autoflush_enabled=TRUE
*.cluster_database=true
*.compatible='12.2.0.1.0'
*.control_files='+DATA_DG/prdrac/control01.ctl','+DATA_DG/prdrac/control02.ctl','+DATA_DG/prdrac/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='+DATA_DG/prddg/','+DATA_DG/prdrac/'
*.db_name='prdrac'
*.db_recovery_file_dest='+FRA_DG'
*.db_recovery_file_dest_size=80G
*.db_unique_name='prdrac'
prdrac01.diagnostic_dest='/u01/admin/prdrac01'
prdrac02.diagnostic_dest='/u01/admin/prdrac02'
*.enable_pluggable_database=true
*.fal_server='prddg'
prdrac01.instance_number=1
prdrac02.instance_number=2
*.log_archive_config='DG_CONFIG=(prdrac,prdfs,prddg)'
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=prdrac'
*.log_archive_dest_2='service=prdfs SYNC AFFIRM alternate=log_archive_dest_3 valid_for=(online_logfiles,primary_role) db_unique_name=prdfs'
*.log_archive_dest_3='service=prddg SYNC max_failure=1 alternate=log_archive_dest_2 valid_for=(online_logfiles,primary_role) db_unique_name=prddg'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_dest_state_3='alternate'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=8
*.log_file_name_convert='+REDO_DG/prddg/','+REDO_DG/prdrac/'
*.open_cursors=1000
*.parallel_max_servers=100
*.pga_aggregate_target=4G
*.pre_page_sga=TRUE
*.processes=1000
*.remote_listener='prdrac-scan:1521'
*.remote_login_passwordfile='exclusive'
*.sga_max_size=16G
*.sga_target=16G
*.standby_file_management='AUTO'
*.statistics_level='ALL'
prdrac01.thread=1
prdrac02.thread=2
*.timed_os_statistics=0
*.timed_statistics=TRUE
prdrac01.undo_tablespace='UNDOTBS01'
prdrac02.undo_tablespace='UNDOTBS02'

 

Oracle Far Sync prdfs Initialization Parameters

 

*.audit_trail='db'
*.audit_sys_operations=TRUE
*.audit_file_dest='/u01/admin/prdfs/adump'
*.awr_pdb_autoflush_enabled=TRUE
*.compatible=12.2.0.1.0
*.control_files='+REDO_DG/prdfs/control01.ctl','+REDO_DG/prdfs/control02.ctl','+REDO_DG/prdfs/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='prdrac'
*.db_unique_name='prdfs'
*.db_recovery_file_dest='+FRA_DG'
*.db_recovery_file_dest_size=80G
*.diagnostic_dest='/u01/admin/prdfs'
*.enable_pluggable_database=true
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=prdfs'
*.log_archive_dest_2='service=prddg ASYNC valid_for=(standby_logfiles,standby_role) db_unique_name=prddg'
*.log_archive_config='DG_CONFIG=(prdrac,prdfs,prddg)'
*.log_archive_format='%t_%s_%r.dbf'
*.fal_server='prdrac'
*.db_file_name_convert='+FRA_DG/prdrac/','+FRA_DG/prdfs/'
*.log_file_name_convert='+REDO_DG/prdrac/','+REDO_DG/prdfs/'
*.sga_max_size=16G
*.sga_target=16G
*.open_cursors=1000
*.processes=1000
*.parallel_max_servers=100
*.pga_aggregate_target=4G
*.remote_login_passwordfile='exclusive'
*.pre_page_sga=TRUE
*.undo_tablespace='UNDOTBS01'
*.USE_LARGE_PAGES=only
*.statistics_level='ALL'
*.timed_os_statistics=0
*.timed_statistics=TRUE
*.standby_file_management=AUTO

 

Disaster Recovery Oracle RAC prddg Initialization Parameters

 

prddg01.audit_file_dest='/u01/admin/prddg01/adump'
prddg02.audit_file_dest='/u01/admin/prddg02/adump'
*.audit_sys_operations=TRUE
*.audit_trail='db'
*.awr_pdb_autoflush_enabled=TRUE
*.cluster_database=true
*.compatible='12.2.0.1.0'
*.control_files='+DATA_DG/prddg/control01.ctl','+DATA_DG/prddg/control02.ctl','+DATA_DG/prddg/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='+DATA_DG/prdrac/','+DATA_DG/prddg/'
*.db_name='prdrac'
*.db_recovery_file_dest='+FRA_DG'
*.db_recovery_file_dest_size=80G
*.db_unique_name='prddg'
prddg01.diagnostic_dest='/u01/admin/prddg01'
prddg02.diagnostic_dest='/u01/admin/prddg02'
*.enable_pluggable_database=true
*.fal_server='prdfs','prdrac'
prddg01.instance_number=1
prddg02.instance_number=2
*.log_archive_config='DG_CONFIG=(prdrac,prdfs,prddg)'
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=prddg'
*.log_archive_dest_2='service=prdrac ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=prdrac'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='+REDO_DG/prdrac/','+REDO_DG/prddg/'
*.open_cursors=1000
*.parallel_max_servers=100
*.pga_aggregate_target=4G
*.pre_page_sga=TRUE
*.processes=1000
*.remote_listener='prddg-scan:1521'
*.remote_login_passwordfile='exclusive'
*.sga_max_size=16G
*.sga_target=16G
*.standby_file_management='AUTO'
*.statistics_level='ALL'
prddg01.thread=1
prddg02.thread=2
*.timed_os_statistics=0
*.timed_statistics=TRUE
prddg01.undo_tablespace='UNDOTBS01'
prddg02.undo_tablespace='UNDOTBS02'
check-circle-line exclamation-circle-line close-line
Scroll to top icon