Re: Question for DBA: control files and processes

In article <397E8BBD.E088D15A_at_demon.co.uk>,   holders <holders_at_demon.co.uk> wrote:
> What version of Oracle is it 8.0.5 or 8.1.5

this is 805 on Sun Solaris

>
> zyman_at_my-deja.com wrote:
>
> > Hello,
> > In my alert.log consist such "wonderfull" information:
> >
> > kccrsz: requested to expand controlfile section 9 by 660 record(s)
> > limited expansion to 191 records since maximum numrecs is 65535
> > kccrsz: expanded controlfile section 9 from 65344 to 65535 records
> >
> > the question is what is this "kccrsz" is ? Waht section it is
 talking
> > about??? which records????? why it (control file) have only 65535
> > records ? what are this records?
> > Ihaven't see any! information about such kind mesg in Oracle
> > documentation... :(
> >
> > Then lets' continue with alert.log:
> >
> > kccrsz: denied expansion of controlfile section 9 by 661 record(s)
> > the number of records is already at maximum value (65535)
> > krcpwnc: following controlfile record written over:
> > RECID #3350 Recno 62307 Record timestamp
> > 07/15/00 13:13:10
> > Thread=1 Seq#=3350 Link-Recid=3349
> > Low
> > scn: 0x0000.03e0f985
> > 07/14/00 18:16:02
> > Next
> > scn: 0x0000.03e0fa38
> > Thread 1 advanced to log sequence 68886
> > Current log# 3 seq# 68886 mem# 0:
> > /u03/oradata/oracle8/bpcd/redobpcd03.log
> > kccrsz: denied expansion of controlfile section 9 by 2026 record(s)
> > the number of records is already at maximum value (65535)
> > krcpwnc: following controlfile record written over:
> > RECID #3351 Recno 62308 Record timestamp
> > 07/15/00 17:44:30
> > Thread=1 Seq#=3351 Link-Recid=3350
> > Low
> > scn: 0x0000.03e0fa38
> > 07/15/00 13:13:10
> > Next
> > scn: 0x0000.03e12b4b
> >
> > COOLLL!!! I always become very exciting than I see such kind of
 friendly
> > information with a lot of documentation about everything but not
 about
> > this!!!
> > Does anb. knows how to translate this into English please?
> > Or the only information we can get from all this numbers and mesgs.
 is :
> > "I'm dieing, diying.... I'm already dead. Your database." ?
> >
> > Ok, The next "super" informative mesg. from alert log:
> >
> > LGWR: terminating instance due to error 204
> > Instance terminated by LGWR, pid = 848
> >
> > Database mounted in Exclusive Mode.
> > Completed: alter database mount
> > Mon Jul 24 10:04:25 2000
> > alter database open
> > Beginning crash recovery of 1 threads
> > Recovery of Online Redo Log: Thread 1 Group 3 Seq 72114 Reading mem
 0
> > Mem# 0 errs 0: /u03/oradata/oracle8/bpcd/redobpcd03.log
> > Crash recovery completed successfully
> > Mon Jul 24 10:04:25 2000
> > Rolling back half complete log switch of thread 1
> > LGWR: terminating instance due to error 204
> > Instance terminated by LGWR, pid = 17140
> >
> > Cool! there is the description of this error 204? Where should I
 look?
> > this is ora-. snp- what is this?
> >
> > Somtetimes I just "felt in love" in Oracle....
> >
> > THank You.
> > ANdy
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 26 2000 - 00:00:00 CDT