Help: STALE logs problem

From: <kal121_at_my-deja.com>
Date: Mon, 06 Nov 2000 17:39:08 GMT
Message-ID: <8u6qbr$ikb$1@nnrp1.deja.com>

Hi,

I have an 8.1.6 database on Linux. I created 5 redo log groups, 2 members each.

Tried to do an update, but the "commit" command just hung for a long time and would not complete. I suspected the redo logs. Sure enough, 4 of the 5 groups were STALE - all 4 groups' members.

My question is, what would cause 4 of 5 groups to go completely STALE? Could an improper shutdown cause this? (Turns out the machine was being rebooted without shutting down Oracle first).

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 06 2000 - 11:39:08 CST