Dear friends
here is my init .ora file
i've an application working on a database called PRDSPRT i've cloned this database server on a new server to install a data guard on it the db_name must be the same as its required for the application
how can i install the DBfile name _ convert ?
& the log_file convert its pointing to the same path now
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._fast_full_scan_enabled=FALSE
*._like_with_bind_as_equality=TRUE
*._sort_elimination_cost_ratio=5
*._sqlexec_progression_cost=2147483647
*._system_trig_enabled=true
*._trace_files_public=TRUE
*.aq_tm_processes=1
*.background_dump_dest='/oracle/dev2/d01/db/tech_st/10.2.0/admin/PRDSPRT_srv-hq-on01/bdump'
*.compatible='10.2.0'
*.control_files='/oracle/dev2/d01/db/apps_st/data/cntrl01.dbf','/oracle/dev2/d01/db/apps_st/data/cntrl02.dbf','/oracle/dev2/d01/db/apps_st/data/cntrl03.dbf'
*.core_dump_dest='/oracle/dev2/d01/db/tech_st/10.2.0/admin/PRDSPRT_srv-hq-on01/cdump'
*.cursor_sharing='EXACT'# Required 11i settting
*.db_block_checking='FALSE'
*.db_block_checksum='TRUE'
*.db_block_size=8192
*.db_file_multiblock_read_count=8# Required 11i setting
*.db_files=512# Max. no. of database files
*.db_name='PRDSPRT'
*.db_unique_name='PROD'
*.dml_locks=10000
*.job_queue_processes=50
*.event="10298 trace name context forever, level 32"
*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/dev2/d01/db/archive'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
*.log_buffer=10485760
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20480'# trace file size
*.nls_comp='binary'# Required 11i setting
*.nls_date_format='DD-MON-RR'
*.nls_language='american'
*.nls_length_semantics='BYTE'# Required 11i setting
*.nls_numeric_characters='.,'
*.nls_sort='binary'# Required 11i setting
*.nls_territory='america'
*.olap_page_pool_size=4194304
*.open_cursors=600# Consumes process memory, unless using MTS.
*.optimizer_secure_view_merging=false
*.parallel_max_servers=20
*.parallel_min_servers=0
*.pga_aggregate_target=1G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.plsql_native_library_dir='/oracle/dev2/d01/db/tech_st/10.2.0/plsql/nativelib'
*.plsql_native_library_subdir_count=149
*.plsql_optimize_level=2# Required 11i setting
*.processes=500# Max. no. of users x 2
*.session_cached_cursors=500
*.sessions=400# 2 X processes
*.sga_target=2G
*.shared_pool_reserved_size=500M
*.shared_pool_size=1G
*.timed_statistics=true
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.user_dump_dest='/oracle/dev2/d01/db/tech_st/10.2.0/admin/PRDSPRT_srv-hq-on01/udump'
*.utl_file_dir='/usr/tmp','/usr/tmp','/patch/ora_tmp/PROD','/oracle/dev2/d01/db/tech_st/10.2.0/appsutil/outbound/PRDSPRT_srv-hq-on01','/usr/tmp'
*.workarea_size_policy='AUTO'# Required 11i setting
*.remote_login_passwordfile='EXCLUSIVE'
#standbydbsetup
DB_UNIQUE_NAME=PROD
SERVICE_NAMES=PROD
#physical standby db
log_archive_config= 'DG_CONFIG=(PROD,TEST)'
log_archive_dest1 = 'LOCATION=/oracle/dev2/d01/db/archive/
VALID\_FOR=(ALL\_LOGFILES,ALL\_ROLES)
DB\_UNIQUE\_NAME=PROD'
log_archive_dest2 = 'SERVICE=TEST LGWR ASYNC
VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE)
DB\_UNIQUE\_NAME=TEST'
log_archive_dest_state_1 = enable
log_archive_dest_state_2 = enable
log_archive_max_processes = 15
#failover parameters
*.fal_Server=TEST
*.fal_client=PROD
db_file_name_convert=('/oracle/dev2/d01/db/archive/','/oracle/dev2/d01/db/archive/',
'/oracle/dev2/d01/db/apps\_st/data/','/oracle/dev2/d01/db/apps\_st/data/')
log_file_name_convert=('/oracle/dev2/d01/db/archive/','/oracle/dev2/d01/db/archive/')
standby_file _managemnt = auto
