Bonjour tout le monde ,

J'ai régulierement ce fichier trace dans différentes bases avec ces messages :
Dump file d:\grangle\gaprod\db\trc\bdump\gaprod_lgwr_14096.trc
Sun Jan 15 15:00:23 2012
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.3.0 - Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 16 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:5361M/8187M, Ph+PgF:5915M/11063M, VA:866M/2047M
Instance name: gaprod

Redo thread mounted by this instance: 1

Oracle process number: 7

Windows thread id: 14096, image: ORACLE.EXE (LGWR)


*** SERVICE NAME) 2012-01-15 15:00:23.790
*** SESSION ID165.1) 2012-01-15 15:00:23.790
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
*** 2012-01-15 21:56:37.607
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 08:51:53.909
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 11:26:43.559
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 14:54:18.288
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 16:23:41.888
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 21:01:34.881
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 21:03:00.926
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 22:02:30.592
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-16 22:16:37.326
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-17 06:00:30.088
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-17 10:37:08.816
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-17 14:29:01.850
Media recovery not enabled or manual archival only 0x10000
*** 2012-01-17 16:00:06.933
Media recovery not enabled or manual archival only 0x10000

messages de l'alert log correspondant à la période :


Mon Jan 16 22:16:37 2012
Thread 1 advanced to log sequence 6689
Current log# 2 seq# 6689 mem# 0: D:\GRANGLE\GAPROD\DB\REDO\REDO1\REDO21.LOG
Tue Jan 17 06:00:30 2012
Thread 1 advanced to log sequence 6690
Current log# 3 seq# 6690 mem# 0: D:\GRANGLE\GAPROD\DB\REDO\REDO1\REDO31.LOG
Tue Jan 17 10:37:08 2012
Thread 1 advanced to log sequence 6691
Current log# 1 seq# 6691 mem# 0: D:\GRANGLE\GAPROD\DB\REDO\REDO1\REDO11.LOG
Tue Jan 17 14:29:01 2012
Thread 1 advanced to log sequence 6692
Current log# 2 seq# 6692 mem# 0: D:\GRANGLE\GAPROD\DB\REDO\REDO1\REDO21.LOG
Tue Jan 17 15:29:13 2012
/* OracleOEM */ CREATE SMALLFILE TABLESPACE "TBS_SPOT" LOGGING DATAFILE 'E:\GRANGLE\GAPROD\DB\BAS\TBS_SPOT.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Tue Jan 17 15:29:15 2012
Completed: /* OracleOEM */ CREATE SMALLFILE TABLESPACE "TBS_SPOT" LOGGING DATAFILE 'E:\GRANGLE\GAPROD\DB\BAS\TBS_SPOT.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Tue Jan 17 16:00:06 2012
Thread 1 advanced to log sequence 6693
Current log# 3 seq# 6693 mem# 0: D:\GRANGLE\GAPROD\DB\REDO\REDO1\REDO31.LOG

en heure de pointe , le log switch toutes les 3 heures ( à peu prés)
J'ai 3 groupes de redo (1 membre par groupe) de 50M chacun .

Que signifie donc le message

Media recovery not enabled or manual archival only 0x10000
présent dans le fichier trace du logwriter ?

la base est en mode no-archivelog .

Cordialement