Oracle Database Discussions

Hi,

i created standby database in remote server,but archives are not applying on standby.

when i quered v$archived_log ,it displying "no rows selected".

hardware and software versions of primary and standby are same.

my db version:9.2.0.1


**My primary initfile is**


*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\NDS\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\oradata\NDS\CONTROL01.CTL','D:\oracle\oradata\NDS\CONTROL02.CTL','D:\oracle\oradata\NDS\CONTROL03.CTL'
*.core_dump_dest='D:\oracle\admin\NDS\cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='NDS'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NDSXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='NDS'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\admin\NDS\udump'
log_archive_start=true
log_archive_dest_1='location=D:\oracle\ora92\database\archive mandatory'
log_archive_dest_state_1=enable
log_archive_dest_2='service=stdby lgwr sync affirm'
log_archive_dest_state_2=enable
instance_name=nds
log_archive_format=nds%t_%s.arc


Standby init file is
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\stdby\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\stdby\control\control_stdby.ctl'
*.core_dump_dest='D:\oracle\stdby\cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='NDS'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NDSXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='stdby'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\stdby\udump'
log_archive_start=true
log_archive_dest_1='location=D:\oracle\ora92\database\archive1'
log_archive_dest_state_1=enable
standby_archive_dest='D:\oracle\stdby\archive2'
db_file_name_convert='D:\oracle\oradata\NDS','D:\oracle\stdby\stdbyoradata'
log_file_name_convert='D:\oracle\oradata\NDS','D:\oracle\stdby\stdbyoradata'
standby_file_management=auto
remote_archive_enable=true
fal_server=nds
fal_client=stdby


please help me , is there any mistake in init files ?


thanks.......