Re: Flashback log file sync

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 14 May 2012 03:40:04 +0000 (UTC)
Message-ID: <pan.2012.05.14.03.40.04_at_gmail.com>

On Sun, 13 May 2012 09:56:11 +0100, Jonathan Lewis wrote:

> | Wow! Not that I don't believe you, but that is really wild. I'll try |
> checking it by doing a hex dump of some .fb files and confirm this. |
>
> I wouldn't want you to do otherwise.

And you are right. Current record: block image. I still don't understand why did they do it like that.

Trace file /oracle/diag/rdbms/o11/O11/trace/O11_ora_2567.trc Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/11.2.0/11.2.0.3 System name: Linux

Node name:      medo.home.com
Release:        3.3.5-2.fc16.x86_64
Version:        #1 SMP Tue May 8 11:24:50 UTC 2012
Machine:        x86_64

Instance name: O11
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 2567, image: oracle_at_medo.home.com

• 2012-05-13 23:33:46.282
• SESSION ID:(11.17) 2012-05-13 23:33:46.282
• CLIENT ID:() 2012-05-13 23:33:46.282
• SERVICE NAME:(O11.home.com) 2012-05-13 23:33:46.282
• MODULE NAME:(sqlplus_at_medo.home.com (TNS V1-V3)) 2012-05-13 23:33:46.282
• ACTION NAME:() 2012-05-13 23:33:46.282

DUMP OF FLASHBACK LOG FILE (15) /data/oracle/flashback/O11/flashback/ o1_mf_7txdxqkn_.flb
 FILE HEADER:

        Compatibility Vsn = 186646528=0xb200000
        Db ID=1818577220=0x6c654944, Db Name='O11'
        Activation ID=1818575684=0x6c654344
        Control Seq=3492=0xda4, File size=65536=0x10000
        File Number=15, Blksiz=8192, File Type=8 FLASH BACK

  FLASHBACK HEADER:
   Flashback Block Header:

      Seq: 16 Block: 1 Cks: 0xc586 Flag: 0x1 Lst: 0    description:"Thread 0001, Seq# 0000000016, SCN 0x0000001bbfaf"    thread: 1 seq: 16 version 0 nab: 65537    reset logs count: 0x2e883e0a scn: 0x0000.000f30dc    formatted blocks: 65536 usable blocks: 65536    magic: 4 previous magic: 0 flags: 0x0    Low scn: 0x0000.001bbfaf 05/12/2012 15:05:06    High scn: 0x0000.001bc39c 05/12/2012 15:13:17    Last Marker:

      fba: (lno 0 thr 0 seq 0 bno 0 bof 0) Flashback async buffers are set to 32

• 2012-05-13 23:33:52.815 Current records:
  • Record at fba: (lno 15 thr 1 seq 16 bno 65536 bof 4852) **** RECORD HEADER: Type: 1 (Block Image) Size: 28 RECORD DATA (Block Image): file#: 7 rdba: 0x01c08cf8 Next scn: 0x0000.001bc39c [0.1819548] Flag: 0x1 Block Size: 8192 BLOCK IMAGE: buffer rdba: 0x01c08cf8 scn: 0x0000.001bbca2 seq: 0x02 flg: 0x04 tail: 0xbca22802 frmt: 0x02 chkval: 0x285c type: 0x28=PAGETABLE MANAGED LOB BLOCK Hex dump of block: st=0, typ_found=1

-- 
http://mgogala.byethost5.com

Received on Sun May 13 2012 - 22:40:04 CDT