Re: Pluggable database in 12C
From: TheBoss <TheBoss_at_invalid.nl>
Date: 23 Oct 2012 22:20:04 GMT
Message-ID: <XnsA0F6369A9A4TheBossUsenet_at_194.109.133.133>
Noons <wizofoz2k_at_gmail.com> wrote in
news:8e1f23f4-18f4-4ca2-b35e-e184eb9e1057_at_r8g2000pbs.googlegroups.com:
> not
>
>
> Some of the messages I'm seeing:
> "Thread 1 cannot allocate new log, sequence 167
> Private strand flush not complete"
> This is on a db with 6 redo log of 1GB each.
> Doing a search on that seems to indicate the message is relatively
> harmless in 11gr2.
> If it is, then why put it there in the first place?
> And what does it REALLY mean and what is the remediation if any?
>
Date: 23 Oct 2012 22:20:04 GMT
Message-ID: <XnsA0F6369A9A4TheBossUsenet_at_194.109.133.133>
Noons <wizofoz2k_at_gmail.com> wrote in
news:8e1f23f4-18f4-4ca2-b35e-e184eb9e1057_at_r8g2000pbs.googlegroups.com:
> On Oct 22, 4:11 pm, Noons <wizofo..._at_yahoo.com.au> wrote:
>
>> But I'm getting some alert messages that I don't understand. They >> are
> not
>> warnings, nor errors. Just "comments", I guess? (for what purpose?)
>
>
> Some of the messages I'm seeing:
> "Thread 1 cannot allocate new log, sequence 167
> Private strand flush not complete"
> This is on a db with 6 redo log of 1GB each.
> Doing a search on that seems to indicate the message is relatively
> harmless in 11gr2.
> If it is, then why put it there in the first place?
> And what does it REALLY mean and what is the remediation if any?
>
Did you check MOS for this?
It has several notes related to this.
According to my notes, the most relevant are:
Checkpoint Tuning and Troubleshooting Guide [ID 147468.1] Manual Log Switching Causing "Thread 1 Cannot Allocate New Log" Message in the Alert Log [ID 435887.1] Can Not Allocate Log [ID 1265962.1]
HTH
-- JeroenReceived on Wed Oct 24 2012 - 00:20:04 CEST