On 17 May 2010 10:30, James Hogarth <james.hoga...@gmail.com> wrote:
> Hi all,
>
> I figure someone else has probably run across this and can provide some 
> advice.
>
> After enabling online backups last week on our oracle-xe instance we
> hit a problem of the flash recovery area filling up and stopping
> oracle (and hence spacewalk) from responding. I gave a band aid of
> increasing the allocated storage but can anyone provide any insight on
> what can be archived off the DB server from the flashrecovery
> directories (if anything) to stop this happening in future?
>
> Our Oracle DB is currently sitting at about 2 gigs of DB used by the
> spacewalk user. The flash recovery area was 10G and I've boosted it up
> to 20 for now...
>
> James
>

For the record in case anyone else hits this....

The backup recovery area being increased to 20GBs was still only just
enough to keep it semi-stable...

The reason it go so upset and grew so much was that the RMAN
configuration was holding data for a few days before obsoleting it and
as a consequence ran out of allocated space. Altered the configuration
to mark obsolete after a day using RMAN TARGET / and backups have been
clean since then.

James

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to