Hi
Until very recently we had 2 locations setup for archive logs, one localy and one on another server shared drive, this worked fine util someone decided to move the location on the other server, the share still have the same name but nothing is written to it, first location works fine.
My parameters look like this:
SQL> show parameter archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 600
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=d:\oradata\SYDBAS2\ar
ch MANDATORY REOPEN=300
log_archive_dest_10 string
log_archive_dest_2 string LOCATION=\\JK8\sydbas2\arch
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %S_%R_%T.ARC
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string %ORACLE_HOME%\RDBMS
Strangely enough when I check what my logs are up to it thinks that destination 2 is active and you can see that logs are switching.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination \\JK8\sydbas2\arch
Oldest online log sequence 158483
Next log sequence to archive 158486
Current log sequence 158486
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination \\JK8\sydbas2\arch
Oldest online log sequence 158489
Next log sequence to archive 158492
Current log sequence 158492
In my log I get this:
Sun Oct 27 23:48:44 2013
Thread 1 cannot allocate new log, sequence 158136
Checkpoint not complete
Current log# 2 seq# 158135 mem# 0: C:\ORADATA\SYDBAS2\REDO02A.DBF
Current log# 2 seq# 158135 mem# 1: D:\ORADATA\SYDBAS2\REDO02B.DBF
Private_strands 39 at log switch
Thread 1 advanced to log sequence 158136
Sun Oct 27 23:48:47 2013
Current log# 4 seq# 158136 mem# 0: C:\ORADATA\SYDBAS2\REDO04A.DBF
Current log# 4 seq# 158136 mem# 1: D:\ORADATA\SYDBAS2\REDO04B.DBF
Sun Oct 27 23:48:48 2013
ARC1: Evaluating archive thread 1 sequence 158135
Sun Oct 27 23:48:48 2013
Errors in file d:\oracle\admin\sydbas2\bdump\sydb_arc1_2456.trc:
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 5) Access is denied.
Is it just a os user problem? What user should have access to the archive folder?
I suspect that I have overlooked something realy simple but as I have stared at it for some time now I need some fresh eyes.
Apreciate all help.
Rgds
Robert