If you have the database backup trigger enabled, ADSM can backup the data
base based on the log threshholds you set.  Ours is set to trigger an
incremental DB back up if the log reaches 70% capacity. (It cannot be to
high or the log may fill up before the backup completes.)
We only use this trigger for "out of the ordinary" circumstances.  We
schedule 2 daily DB incremental backups and one weekly full DB backup.  If
we hit a maximum of 18 incrementals before the weekly run, the DB backup
trigger will force a full backup.




"Thomas A. La Porte" <tlaporte AT ANIM.DREAMWORKS DOT COM> on 03/20/98 09:34:21

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Claudia Masters/Texas Utilities)
Subject:  Re: Maximum recovery log capacity?




I agree with Gunther. We backup our database daily
(unfortunately, due to the size of the DB, we're forced to do
incremental backups and fulls only once a week) and we regularly
push up near this 5GB limit. I'm particularly perturbed b/c I
have a 9.1GB disk for the recovery log, of which I can only use a
little over half.
Why does this limit exist? It seems arbitrary--and incredibly
small, given that 500GB was the figure quoted as the max for a
database. I can't imagine you could run in roll-forward with
anything larger than 50GB without having to do DB backups several
times per day.
This brings me to another point: is there a reason why ADSM can't
be smart when the log *does* fill up (I know, it shouldn't
happen, but given the number of times the question gets asked on
this list, we all know that it does). When Oracle doesn't have a
log volume to which it can switch, it doesn't crash. It merely
prevents all database activity from continuing until the
administrator rectifies the problem. I particularly like the idea
of a set of log files which are switched when they fill up.
 -- Tom
"It's a dog eat dog world,                Thomas A. La Porte
 and I'm wearing milkbone underwear."     DreamWorks SKG
              - Norm Peterson             <tlaporte AT anim.dreamworks DOT com>
On Fri, 20 Mar 1998, H.G.Borrmann wrote:
>> Subject:  Maximum recovery log capacity?
[...]
>
>This limit is too small. We backup our database each day and we come near
the
>limit with the size of our logfile!
>
>Gunther
>._________________________________________________________________________
.
>|H.G.Borrmann                           |Tel.: (0761) 203-4652
|
>|Rechenzentrum der Universitaet Freiburg|Fax:  (0761) 203-4643
|
>|Hermann-Herder-Str. 10                 |email:
|
>|D79104 FREIBURG                        |borrmann AT ruf.uni-freiburg DOT de
|
>|_________________________________________________________________________
|
>