Citation:
***************************************************************************
LOG FILE RECORDS
***************************************************************************
(size = 72, compat size = 72, section max = 16, section in-use = 3,
last-recid= 3, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
(name #3) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO01.LOG
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x19000 seq: 0x0000003b hws: 0x5 bsz: 512 nab: 0xc05c flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001a595d
Low scn: 0x0000.001ad5da 09/20/2006 21:46:17
Next scn: 0x0000.001b4ca8 09/21/2006 11:00:24
LOG FILE #2:
(name #2) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO02.LOG
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x19000 seq: 0x0000003c hws: 0x3 bsz: 512 nab: 0xcc9 flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001ad5da
Low scn: 0x0000.001b4ca8 09/21/2006 11:00:24
Next scn: 0x0000.001b5378 09/21/2006 11:36:47
LOG FILE #3:
(name #1) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO03.LOG
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x19000 seq: 0x0000003d hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001b4ca8
Low scn: 0x0000.001b5378 09/21/2006 11:36:47
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
2. faire un switch log
Citation:
***************************************************************************
LOG FILE RECORDS
***************************************************************************
(size = 72, compat size = 72, section max = 16, section in-use = 3,
last-recid= 3, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
(name #3) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO01.LOG
Thread 1 redo log links: forward: 2 backward: 0
siz: 0x19000 seq: 0x0000003e hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001b5378
Low scn: 0x0000.001b57ea 09/21/2006 12:11:39
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #2:
(name #2) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO02.LOG
Thread 1 redo log links: forward: 3 backward: 1
siz: 0x19000 seq: 0x0000003c hws: 0x3 bsz: 512 nab: 0xcc9 flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001ad5da
Low scn: 0x0000.001b4ca8 09/21/2006 11:00:24
Next scn: 0x0000.001b5378 09/21/2006 11:36:47
LOG FILE #3:
(name #1) E:\ORACLE\PRODUCT\10.2.0\ORADATA\B10R2\REDO03.LOG
Thread 1 redo log links: forward: 0 backward: 2
siz: 0x19000 seq: 0x0000003d hws: 0x2 bsz: 512 nab: 0x78a flg: 0x0 dup: 1
Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.001b4ca8
Low scn: 0x0000.001b5378 09/21/2006 11:36:47
Next scn: 0x0000.001b57ea 09/21/2006 12:11:39
on voit bien que le fichier de contrôle à été modifié.