Home » Server Options » Data Guard » Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH
Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH [message #255212] Tue, 31 July 2007 00:53 Go to next message
garg_puneet
Messages: 5
Registered: July 2007
Junior Member
Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH
Set log_archive_dest_1 location to +DATA but some logs are still shipped to +FLASH

log_archive_config string dg_config=(DRECLIN,ECLIN)
log_archive_dest string
log_archive_dest_1 string LOCATION=+DATA/ MANDATORY REOP
EN=300
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string service=ECLIN1 LGWR ASYNC vali
d_for=(online_logfiles,primary
_role) db_unique_name=ECLIN
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable

but error:
Set log_archive_dest_1 location to +DATA but some logs are still shipped to +FLASH

from alert.log file
RFS[5]: Archived Log: '+FLASH/dreclin/archivelog/2007_07_29/thread_1_seq_6157.1803.629202393'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: No standby redo logfiles of size 102400 blocks available
Sun Jul 29 10:41:34 2007
Media Recovery Log +FLASH/dreclin/archivelog/2007_07_29/thread_1_seq_6157.1803.629202393
Media Recovery Log +DATA/dreclin/archivelog/2007_07_29/thread_2_seq_2729.4707.629203275


please give me solution as soon as...........
Re: Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH [message #255381 is a reply to message #255212] Tue, 31 July 2007 11:09 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Your FRA is enabled?If yes then try to point db_recovery_file_dest to +DATA and check wheather it still going to +FLASH.
Post the querry result
SQL>select substr(name,1,40) from v$archived_log;
FLPS2
/u40/oracle/flps/oraarc/arch_1_2662_6225
FLPS2
/u40/oracle/flps/oraarc/arch_1_2663_6225
FLPS2
/u40/oracle/flps/oraarc/arch_1_2664_6225
FLPS2
/u40/oracle/flps/oraarc/arch_1_2665_6225
FLPS2
SQL>


Previous Topic: Not able to apply archive log to standby database
Next Topic: redo logs not getting applied
Goto Forum:
  


Current Time: Thu Dec 08 22:07:11 CST 2016

Total time taken to generate the page: 0.12165 seconds