Re: failed to archive

From: Chip <ocp-dba_at_earthlink.net>
Date: Tue, 15 Jul 2003 23:34:32 -0600
Message-Id: <25929.337935@fatcity.com>

In Oracle 8.1.7, a database can be configured with LOG_ARCHIVE_MAX_PROCESSES = 1
which starts 1 archive process when the database starts.

If the I/O response time for archiving a log takes too long, then Oracle will automatically start another archive process. The alert log shows the various archive process failures for archiving a log. After the poor I/O response for the archive destination(s) has been fixed, the database can be altered: ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES = 1; to shut down the extra archive processes.

Have Fun :)

AK wrote:

>
> I see a lot of "failed to archive " messages in alert.log . But
> finally the log gets archived . Is it due overloaded archiver ?
>
> this is from alert log.....
>
> ARC0: Beginning to archive log# 3 seq# 87568
> ARC0: Failed to archive log# 3 seq# 87568
> ARC0: Beginning to archive log# 2 seq# 87569
> Mon Jul 14 11:36:23 2003
> ARC4: Completed archiving log# 3 seq# 87568
>
> -ak
Received on Wed Jul 16 2003 - 00:34:32 CDT