If you have not already done so, please take a look at Note # 45042.1 on
Metalink (Archiver Best Practices). It offers some suggestions that may be
of some help to you. Also, have you considered upgrading to Oracle 8.x and
take advantage of RMAN for your backups?
- Kirti
> -----Original Message-----
> From: blair_at_pjm.com [SMTP:blair_at_pjm.com]
> Sent: Wednesday, April 26, 2000 8:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: dbms_job question ??
>
> We are running Oracle 7.3.2.3 OPS on AIX 4.2.1
>
> Our database is 600G and extremely insert-intensive (330M per 15 minutes).
>
> During hot backup (which takes 10 hours) all 23 on-line redo logs usually
> fill
> and the database stops
> because they are filling faster than the archive process can copy them to
> the
> archive filesystem.
>
> Can anyone suggest any Oracle tuning that may help? I cant think of
> anything.
> Is there a way (in Unix) to give the archiver an exclusive lock on the
> archive
> filesystem during a redo log write?
>
> ..tom
> --
> Author:
> INET: blair_at_pjm.com
Received on Wed Apr 26 2000 - 10:35:13 CDT
