| 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
Hi Tom,
It cannot be done (there: my neck fully stretched out :-)) since
log_archive_dest_1 to n will provide
only for multiple locations of the same file being written out by one or
more ARCH processes.
Martin Kendall
-----Original Message-----
Sent: 26 April 2001 16:51
To: Multiple recipients of list ORACLE-L
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).
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 - 13:21:45 CDT
 |
 |