Oracle Database Discussions

Hello,

We have a patch reboot weekend once a month. All servers including file servers, Oracle db servers will be rebooted during that time. I have one Oracle db server is unable to start itself after the reboot. I have to log onto sqlplus, and type 'startup' to start it manually. The error in oradim.log is:

ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.


My environment is Oracle 10G R2 10.2.0.4.0 – 64 bit on Windows 2003 Enterprise X64 Service Pack2.

Here is some useful info:

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination \\prod\logs\OracleLogs\orac1 (**THIS IS MY FILE SERVER, not on the same server as
Oracle db server**)

SQL> show parameter log_archive;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=\\prod\logs\OracleLogs\orac1
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string ARC%S_%R.%T
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

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size big integer 2G

Do you see any wrong configuration above?

May I just use LOG_ARCHIVE_DEST_1 and leave LOG_ARCHIVE_DEST as NULL?

Can I set different locations for LOG_ARCHIVE_DEST (LOG_ARCHIVE_DEST_1) and db_recovery_file_dest?

I suspect the file server may not be available when the db server starts up, so I plan to do a DT and reboot the db server when the file server is up, and see if Oracle can start up itself this time.

Do you have any suggestion I can try?

Thanks.