Oracle Database Discussions

Hi guys,

We've been using our 10g installation for a while now without any problems. Yesterday, I put it in ARCHIVELOG mode and tried to configure RMAN to schedule daily backups for us. I think I've misconfigured the ARCHIVELOG stuff somehwhere though - I'm getting ORA error messages coming out of my ears.

The database runs fine for a while, but I guess the ARCHIVELOG directory is getting full as I get the following error messages:

ORA-16038: log 2 sequence# 7419 cannot be archived
ORA-19504: failed to create file ""

When I do a `show parameters`, I see the following log_archive_X parameters:

---- BEGIN
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string

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

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 6203392
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string
---- END

I set the log_archive_dest directory yesterday without any problems, but I don't see it here.

When I try to set log_archive_dest, I get:
ORA-16038: log 2 sequence# 7419 cannot be archived
ORA-19504: failed to create file ""

When I try to set log_archive_dest_1 I get:
ORA-16038: log 2 sequence# 7419 cannot be archived
ORA-19504: failed to create file ""

If it's not obvious, I'm a little out of my depth. Can someone help me troubleshoot why Oracle is choking when the archive logs are written?

Thank you very much in advance for any advice/replies.

Lee