| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: multiple archive destinations
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails using the old format will continue to be delivered until 30th June 2001.
Tom,
You don't mention what size the redo logs are. Might it not be more
efficient to have fewer but larger sized redo logs which will give the
archiver time to copy the data prior to the redo log being ready for
overwriting.
I know I have not answered the main point re multiple arc processes to
different destinations but I have not got time to look at the docs at the
moment.
John
-----Original Message-----
From: blair_at_pjm.com [mailto:blair_at_pjm.com]
Sent: 26 April 2001 16:51
To: Multiple recipients of list ORACLE-L
Subject: multiple archive destinations
RDBMS: 8.1.6.2 OS: AIX 4.3.3
Our large (600G) insert-intensive (17Meg / min) database has
24 on-line redo
logs (8 each on 3 disks used in round-robin fashion) and
occasionally has
problems with the archiver being unable to keep up with the
data fill rate.
When this happens on-line redo logs fill faster than the ARC
process can write
them. I have successfully used more than one ARC process
but of course all ARC
processes are writing to the same destination (which becomes
the limiting
factor).
What I'd really like to do is use more than one archive log
destination - with 2
(or more) ARC processes - each writing to a separate
destination. But reading
through the manual it looks like the multiple archive
destination facility was
developed for multiplexing each redo log to more than one
destination (for
hot-standbys for example) - rather than each redo log to one
of several
destinations depending on which ARC process is working on
it.
Is there any way to accomplish my purpose?
thanks,
..tom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: blair_at_pjm.com
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
This e-mail and any files transmitted with it, are confidential to Logica and are
intended solely for the use of the individual or entity to whom they are addressed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
INET: HallasJ_at_logicae.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 26 2001 - 12:30:00 CDT
 |
 |