| 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: oracle database archive files help
Hello Paula
From memory. so take with a grain of salt.
log_archive_dest_1 location=/u003/oraarc/prod/arch log_archive_dest_2 location=/u004/oraarc/prod/archlog_archive_min_succeed_dest 1
I think the problem is with: 'log_archive_min_succeed_dest 1'.
It means that oracle will write to BOTH destinations, but if one is
unavailable or full and oracle can write to the other, oracle will write
to the other and go on working.
I does not mean that after oracle successfully write the archive log to
one destination it will stop and not write the same archive log to the
second destination.
In your case:
If u003 and u004 are the same size then they both will become full at
the same time.
If u004 has more free space the after u003 is full, oracle will continue
to archive logs to u004 and will continue to work.
Adar Yechiel
Rechovot, Israel
Paula Stankus wrote:
> Guys,
>
> A colleague is telling me that the file system /u003 filling up is not
> an issue because we had the /u004 setup. I am saying that both are
> mandatory and we are multiplexing. He is gone to management with this
> disagreement. Doesn't the following show that both are mandatory??
> This is an 8.1.7 oracle version. It is my understanding:
>
>
> <http://us.rd.yahoo.com/evt=33539/*http://football.fantasysports.yahoo.com?ovchn=YAH&ovcpn=Integration&ovcrn=Mail+footer&ovrfd=YAH&ovtac=AD>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 25 2006 - 07:08:42 CDT
 |
 |