Re: about alter.log file .

alex schreef:

> Hi guys:
> My database version is 9.2.0.5 .Below display in my alter.log file.What
> matter with my DB,and
> how can i do it.Thanks
> Regards
> Alex
>
> Completed checkpoint up to RBA [0xc4a.2.10], SCN: 0x0000.0f44bb26
> Fri Jan 12 09:30:27 2007
> Beginning log switch checkpoint up to RBA [0xc4b.2.10], SCN:
> 0x0000.0f464900
> Thread 1 advanced to log sequence 3147
> Current log# 2 seq# 3147 mem# 0: /data/app/cdt/cdtdata/log2.dbf
> Fri Jan 12 09:51:09 2007
> Completed checkpoint up to RBA [0xc4b.2.10], SCN: 0x0000.0f464900
> Fri Jan 12 11:34:46 2007
> Beginning log switch checkpoint up to RBA [0xc4c.2.10], SCN:
> 0x0000.0f47d5bb
> Thread 1 advanced to log sequence 3148
> Current log# 3 seq# 3148 mem# 0: /data/app/cdt/cdtdata/log1.dbf
> Fri Jan 12 11:55:26 2007
> Completed checkpoint up to RBA [0xc4c.2.10], SCN: 0x0000.0f47d5bb
> Fri Jan 12 13:38:01 2007
> Beginning log switch checkpoint up to RBA [0xc4d.2.10], SCN:
> 0x0000.0f4963d8
> Thread 1 advanced to log sequence 3149
> Current log# 1 seq# 3149 mem# 0: /data/app/cdt/cdtdata/log3.dbf
> Fri Jan 12 13:58:46 2007
> Completed checkpoint up to RBA [0xc4d.2.10], SCN: 0x0000.0f4963d8
> Fri Jan 12 14:40:37 2007
> Beginning log switch checkpoint up to RBA [0xc4e.2.10], SCN:
> 0x0000.0f4a6d2f
> Thread 1 advanced to log sequence 3150

Why do you think there's something wrong with your database ?

You have obviously specified the parameter log_checkpoints_to_alert and that is what Oracle does, logging your checkpoints to the aler.log

Hans Received on Fri Jan 12 2007 - 02:50:44 CST