Re: 8.1.6 goes mad until HD full

From: Hannes Erven <h.e_at_gmx.at>
Date: Fri, 26 Oct 2001 16:38:45 +0200
Message-ID: <3bd9744a$0$9880$6e365a64@newsreader02.highway.telekom.at>

"Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message news:9rbo66$s74u3$1_at_ID-85580.news.dfncis.de...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> "Hannes Erven" <h.e_at_gmx.at> wrote in message
> news:3bd95b7f$0$20542$5039e797_at_newsreader01.highway.telekom.at...
> >
> > My primary is concern is this: what makes oracle write archived
> > redo 100 times more often as usual, and how do I find out? I can
> > definitely say that it's not simply more connections, more updates,
> > large imports or something like that.
>
> Leaving tablespaces in backup mode.

Hmm, that would require someone or something that placed one or more tablespaces in backup mode and leave them there.

I can't image that this happens here, since it's a hot standby config and none of our DBAs has manually put tablespaces in backup mode before the oracle crashes. And we don't have backup software run against the primary server which uses online backup.

Anyways, thank you for the hint, I will check next time oracle comes down... :-/

best regards,

-hannes Received on Fri Oct 26 2001 - 09:38:45 CDT