| Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH [message #255212] |
Tue, 31 July 2007 00:53  |
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  |
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>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
