The following is a sample parameter file used for creating Physical Standby Database.
*.audit_file_dest='/home/oracle/admin/LCDR/adump'
*.background_dump_dest='/home/oracle/admin/LCDR/bdump'
*.compatible='10.2.0.3.0'
*.control_files='+ASMFLASH/LCDR/controlfile/current.261.740682331','+ASMUNDO/LCDR/controlfile/current.261.
740682331','+ASMIND/LCDR/controlfile/current.261.740682331'
*.core_dump_dest='/home/oracle/admin/LCDR/cdump'
*.cursor_sharing='SIMILAR'
*.db_block_size=8192
*.db_cache_size=5368709120
*.db_create_file_dest='+ASMDB'
*.db_create_online_log_dest_1='+ASMFLASH'
*.db_create_online_log_dest_2='+ASMUNDO'
*.db_create_online_log_dest_3='+ASMIND'
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_file_name_convert='+ASMDB/PRDB','+ASMDB/LCDR','+ASMIND/PRDB','+ASMIND/LCDR','+ASMFLASH/PRDB','+ASMFLASH/LCDR','+ASMUNDO/PRDB','+ASMUNDO/LCDR'
*.db_flashback_retention_target=0
*.db_keep_cache_size=2147483648
*.db_name='PRDB'
*.db_recovery_file_dest='+ASMFLASH'
*.db_recovery_file_dest_size=96636764160
*.db_unique_name='LCDR'
*.db_writer_processes=8
*.dispatchers='(PROTOCOL=TCP)(SERVICE=LCDRXDB)'
*.dml_locks=24220
*.event='44951 trace name context forever,level 1024'
*.filesystemio_options='SETALL'
*.job_queue_processes=10
*.fal_client='LCDR'
*.fal_server='PRDB'
*.instance_name='LCDR'
*.log_archive_config='DG_CONFIG=(LCDR,PRDB)'
*.log_archive_dest_1='LOCATION=/backup/prodarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=LCDR'
*.log_archive_dest_state_1='ENABLE'
*.log_buffer=67108864
*.log_file_name_convert='+ASMDB/PRDB','+ASMDB/LCDR','+ASMIND/PRDB','+ASMIND/LCDR','+ASMFLASH/PRDB','+ASMFLASH/LCDR','+ASMUNDO/PRDB','+ASMUNDO/LCDR'
*.open_cursors=5000
*.pga_aggregate_target=4294967296
*.processes=500
*.query_rewrite_integrity='TRUSTED'
*.remote_login_passwordfile='EXCLUSIVE'
*.service_names='LCDR'
*.session_cached_cursors=5000
*.sessions=500
*.sga_max_size=21474836480
*.sga_target=21474836480
*.shared_pool_size=1073741824
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
Thanks
Wednesday, September 14, 2011
Sample init.ora file for implementing Physical Standby
Labels:
Data Guard
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment