Re: Why 'Failed to archive' & 'Failed to archive TEST' appear in the alert log file?

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 30 Jul 2003 01:31:21 -0700
Message-ID: <ec4cec95.0307300031.3818dde2@posting.google.com>

jeffyee_at_hotmail.com (Jeffrey Yee) wrote in message news:<ec4cec95.0307242118.7a40d7ce_at_posting.google.com>...

> "Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f1d6f0e$1_1_at_news.estpak.ee>...

> > Hi!
> >
> > It looks like you have to increase your enqueue_resources init.ora
> > parameter.
> >
> > Tanel.
> >
> > "Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message
> > news:ec4cec95.0307212238.6271debf_at_posting.google.com...
> > > Hi,
> > >
> > > I'm running Oracle9i 9.0.1.4 on hp-ux b11.11. I recently change the
> > > online redo log size from 10M to 200M, because of checkpoint not
> > > complete message in the alert log file. Now, I'm puzzle with another
> > > message from the same alert log file. I get 'Failed to archive' or
> > > 'Failed to archive TEST' message. But when I check on my archive
> > > location & v$log view (archived=yes for all, except the status=current
> > > logfile), all my online redo logs has been archived. I even have 10G
> > > available on my archive log mount point. And the 'TEST' is worrying
> > > me, because I have no idea what it means. Is there a way to get
> > > documentation on the messages that appear on the alert log file?
> > >
> > > A cut-out of my alert log file:
> > >
> > ****************************************************************************
> > *
> > > Sat Jul 19 13:58:56 2003
> > > ARC0: Completed archiving log 4 thread 1 sequence 5681
> > > Failed to archive
> > > ORA-00053 Max number of enqueues exceeded
> > > Failed to archive
> > > Failed to archive
> > > Mon Jul 21 13:43:42 2003
> > > Thread 1 advanced to log sequence 5683
> > > Current log# 1 seq# 5683 mem# 0: /ovo_data/oradata/redo01.log
> > > ...
> > > Mon Jul 21 22:21:10 2003
> > > ARC0: Completed archiving log 1 thread 1 sequence 5683
> > > Failed to archive TEST
> > > Failed to archive TEST
> > >
> > ****************************************************************************
> > *
> > >
> > > Please advice. Thank you in advance.
> > >
> > > Best Regards,
> > > Jeffrey Yee

> 
> I have 975 for enqueue_resources.
> 
> I do the following:
> select * from v$resource_limit where resource_name in ('sessions',
> 'enqueue_locks', 'enqueue_resources');
> 
> RESOURCE_NAME	CURRENT_	MAX_	INITIAL_       LIMIT_VALUE
>                 UTILIZATION UTILIZATION ALLOCATION
> sessions	        27	41	       445	       445
> enqueue_locks	        21	32	      5330	      5330
> enqueue_resources	21	64	       975	 UNLIMITED
> 
> The formula provided in the Oracle9i Database Reference says that:
> 'For more than 10 sessions, it is the number of database files +
> ((SESSIONS - 10) * 2) + 55.' For my case, I have 19 dbf files.
> Therefore, it becomes 19 + ((41-10) * 2) + 55 = 19 +62 + 55 = 136.
> 
> I'm at a lost on the proper enqueue_resources value that I should set.
> Please do advice, as I still get Failed to archive TEST in the alert
> log file.
> 
> Thank you.

I have increase enqueue_resources to 985, and just an hour ago, I get 'Failed to Archive !!!!'. What is the difference between 'Failed to Archive', 'Failed to Archive TEST' & 'Failed to Archive !!!!'?

Please advice. Thank you. Received on Wed Jul 30 2003 - 03:31:21 CDT