转储控制文件信息

当前控制文件的内容可以通过CONTROLF dump以文本形式转储到实例参数指定的目录下。

各级别CONTROLF转储的区别:

转储级别 转储内容
1 仅包含文件头信息
2 包括文件头,数据库信息记录,检查点进程记录
3 所有记录类型,针对循环重用的记录类型仅保留最早及最近的记录
4 如上,包含4条最新的可重用类型的记录
5+ 如上,包含的可重用类型记录为2*level条
SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump controlf 3;
Statement processed.
SQL> oradebug tracefile_name;
/s01/rac10g/admin/PROD/udump/prod_ora_3710.trc

以下例而言,使用oradebug命令启动转储,将会把当前控制文件信息以文本形式转储到该服务进程对应的用户转储文件中,文本中记录了level 3所对应的内容。

SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump controlf 3;
Statement processed.
SQL> oradebug tracefile_name;
/s01/rac10g/admin/PROD/udump/prod_ora_3710.trc

oradebug必须以SYSDBA形式登陆后方能使用,你也可以以非SYSDBA的身份通过alter session形式启动转储:

SQL> alter session set events 'immediate trace name controlf level 3';

Session altered.

[gview file=”http://askmac.cn/wp-content/uploads/resource/Controlfile.doc”]


Posted

in

by

Tags:

Comments

2 responses to “转储控制文件信息”

  1. admin Avatar
    admin

    转储文件示例:
    [maclean@rh2 ~]$ cat /s01/rac10g/admin/PROD/udump/prod_ora_4544.trc
    /s01/rac10g/admin/PROD/udump/prod_ora_4544.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORACLE_HOME = /s01/rac10g
    System name: Linux
    Node name: rh2
    Release: 2.6.18-194.el5
    Version: #1 SMP Mon Mar 29 22:10:29 EDT 2010
    Machine: x86_64
    Instance name: PROD
    Redo thread mounted by this instance: 1
    Oracle process number: 16
    Unix process pid: 4544, image: oracle@rh2 (TNS V1-V3)

    *** 2010-07-26 21:21:31.056
    *** ACTION NAME:() 2010-07-26 21:21:31.056
    *** MODULE NAME:(sqlplus@rh2 (TNS V1-V3)) 2010-07-26 21:21:31.056
    *** SERVICE NAME:(SYS$USERS) 2010-07-26 21:21:31.056
    *** SESSION ID:(147.78) 2010-07-26 21:21:31.056
    DUMP OF CONTROL FILES, Seq # 638 = 0x27e
    V10 STYLE FILE HEADER:
    Compatibility Vsn = 169870592=0xa200500
    Db ID=137073014=0x82b9176, Db Name=’PROD’
    Activation ID=0=0x0
    Control Seq=638=0x27e, File size=430=0x1ae
    File Number=0, Blksiz=16384, File Type=1 CONTROL

    ***************************************************************************
    DATABASE ENTRY
    ***************************************************************************
    (size = 316, compat size = 316, section max = 1, section in-use = 1,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 1, numrecs = 1)
    07/24/2010 22:04:38
    DB Name “PROD”
    Database flags = 0x00404000 0x00001000
    Controlfile Creation Timestamp 07/24/2010 22:04:38
    Incmplt recovery scn: 0x0000.00000000
    Resetlogs scn: 0x0000.0005eca9 Resetlogs Timestamp 07/24/2010 22:04:40
    Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 04/20/2010 08:24:24
    Redo Version: compatible=0xa200500
    #Data files = 4, #Online files = 4
    Database checkpoint: Thread=1 scn: 0x0000.000c5980
    Threads: #Enabled=1, #Open=1, Head=1, Tail=1
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Max log members = 3, Max data members = 1
    Arch list: Head=0, Tail=0, Force scn: 0x0000.000bb5f0scn: 0x0000.0005eca9
    Activation ID: 137118838
    Controlfile Checkpointed at scn: 0x0000.000c61f1 07/26/2010 17:10:44
    thread:0 rba:(0x0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000

    ***************************************************************************
    CHECKPOINT PROGRESS RECORDS
    ***************************************************************************
    (size = 8180, compat size = 8180, section max = 11, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 2, numrecs = 11)
    THREAD #1 – status:0x2 flags:0x0 dirty:5
    low cache rba:(0x16.8b77.0) on disk rba:(0x16.8b83.0)
    on disk scn: 0x0000.000c7a6b 07/26/2010 21:20:52
    resetlogs scn: 0x0000.0005eca9 07/24/2010 22:04:40
    heartbeat: 725359406 mount id: 137216089
    THREAD #2 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #3 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #4 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #5 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #6 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #7 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0
    THREAD #8 – status:0x0 flags:0x0 dirty:0
    low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
    on disk scn: 0x0000.00000000 01/01/1988 00:00:00
    resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
    heartbeat: 0 mount id: 0

    ***************************************************************************
    EXTENDED DATABASE ENTRY
    ***************************************************************************
    (size = 276, compat size = 276, section max = 1, section in-use = 1,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 137, numrecs = 1)
    Control AutoBackup date(dd/mm/yyyy)=24/ 7/2010
    Next AutoBackup sequence= 0
    Database recovery target inc#:2, Last open inc#:2
    flg:0x0, flag:0x0
    Change tracking state=0, file index=0, checkpoint count=0
    Flashback log count=0, block count=0
    Desired flashback log size=0 blocks
    Oldest guarantee restore point=0
    Highest thread enable/disable scn: 0x0000.00000000
    Number of Open thread with finite next SCN in last log: 0
    Number of half-enabled redo threads: 0

    ***************************************************************************
    REDO THREAD RECORDS
    ***************************************************************************
    (size = 256, compat size = 256, section max = 8, section in-use = 1,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 9, numrecs = 8)
    THREAD #1 – status:0xf thread links forward:0 back:0
    #logs:3 first:1 last:3 current:1 last used seq#:0x16
    enabled at scn: 0x0000.0005eca9 07/24/2010 22:04:40
    disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
    opened at 07/26/2010 16:35:42 by instance PROD
    Checkpointed at scn: 0x0000.000c5980 07/26/2010 16:35:42
    thread:1 rba:(0x16.2.10)
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    log history: 21
    restore point keep sequence: 0

    ***************************************************************************
    LOG FILE RECORDS
    ***************************************************************************
    (size = 72, compat size = 72, section max = 16, section in-use = 3,
    last-recid= 9, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 10, numrecs = 16)
    LOG FILE #1:
    (name #5) /s01/rac10g/oradata/PROD/onlinelog/o1_mf_1_64q6xrsr_.log
    (name #6) /s01/rac10g/flash_recovery_area/PROD/onlinelog/o1_mf_1_64q6xsoy_.log
    Thread 1 redo log links: forward: 2 backward: 0
    siz: 0x19000 seq: 0x00000016 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2
    Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000c09b2
    Low scn: 0x0000.000c597f 07/26/2010 16:35:42
    Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
    LOG FILE #2:
    (name #3) /s01/rac10g/oradata/PROD/onlinelog/o1_mf_2_64q6xths_.log
    (name #4) /s01/rac10g/flash_recovery_area/PROD/onlinelog/o1_mf_2_64q6xv9o_.log
    Thread 1 redo log links: forward: 3 backward: 1
    siz: 0x19000 seq: 0x00000014 hws: 0x7 bsz: 512 nab: 0x1e99 flg: 0x0 dup: 2
    Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b62dd
    Low scn: 0x0000.000bb5f0 07/25/2010 00:10:20
    Next scn: 0x0000.000c09b2 07/25/2010 00:13:00
    LOG FILE #3:
    (name #1) /s01/rac10g/oradata/PROD/onlinelog/o1_mf_3_64q6xw1b_.log
    (name #2) /s01/rac10g/flash_recovery_area/PROD/onlinelog/o1_mf_3_64q6xwv0_.log
    Thread 1 redo log links: forward: 0 backward: 2
    siz: 0x19000 seq: 0x00000015 hws: 0x6 bsz: 512 nab: 0x498 flg: 0x0 dup: 2
    Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000bb5f0
    Low scn: 0x0000.000c09b2 07/25/2010 00:13:00
    Next scn: 0x0000.000c597f 07/26/2010 16:35:42

    ***************************************************************************
    DATA FILE RECORDS
    ***************************************************************************
    (size = 428, compat size = 428, section max = 100, section in-use = 4,
    last-recid= 5, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 11, numrecs = 100)
    DATA FILE #1:
    (name #10) /s01/rac10g/oradata/PROD/datafile/o1_mf_system_64q6wd5j_.dbf
    creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
    tablespace 0, index=1 krfil=1 prev_file=0
    unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
    Checkpoint cnt:107 scn: 0x0000.000c5980 07/26/2010 16:35:42
    Stop scn: 0xffff.ffffffff 07/25/2010 00:23:01
    Creation Checkpointed at scn: 0x0000.00000007 04/20/2010 08:24:26
    thread:0 rba:(0x0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Offline scn: 0x0000.0005eca8 prev_range: 0
    Online Checkpointed at scn: 0x0000.0005eca9 07/24/2010 22:04:40
    thread:1 rba:(0x1.2.0)
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Hot Backup end marker scn: 0x0000.00000000
    aux_file is NOT DEFINED
    DATA FILE #2:
    (name #9) /s01/rac10g/oradata/PROD/datafile/o1_mf_undotbs1_64q6wd7f_.dbf
    creation size=0 block size=8192 status=0xe head=9 tail=9 dup=1
    tablespace 1, index=2 krfil=2 prev_file=0
    unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
    Checkpoint cnt:70 scn: 0x0000.000c5980 07/26/2010 16:35:42
    Stop scn: 0xffff.ffffffff 07/25/2010 00:23:01
    Creation Checkpointed at scn: 0x0000.0005e654 04/20/2010 08:49:03
    thread:0 rba:(0x0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Offline scn: 0x0000.0005eca8 prev_range: 0
    Online Checkpointed at scn: 0x0000.0005eca9 07/24/2010 22:04:40
    thread:1 rba:(0x1.2.0)
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Hot Backup end marker scn: 0x0000.00000000
    aux_file is NOT DEFINED
    DATA FILE #3:
    (name #8) /s01/rac10g/oradata/PROD/datafile/o1_mf_sysaux_64q6wd5m_.dbf
    creation size=0 block size=8192 status=0xe head=8 tail=8 dup=1
    tablespace 2, index=3 krfil=3 prev_file=0
    unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
    Checkpoint cnt:107 scn: 0x0000.000c5980 07/26/2010 16:35:42
    Stop scn: 0xffff.ffffffff 07/25/2010 00:23:01
    Creation Checkpointed at scn: 0x0000.000016a6 04/20/2010 08:24:32
    thread:0 rba:(0x0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Offline scn: 0x0000.0005eca8 prev_range: 0
    Online Checkpointed at scn: 0x0000.0005eca9 07/24/2010 22:04:40
    thread:1 rba:(0x1.2.0)
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Hot Backup end marker scn: 0x0000.00000000
    aux_file is NOT DEFINED
    DATA FILE #4:
    (name #7) /s01/rac10g/oradata/PROD/datafile/o1_mf_users_64q6wd89_.dbf
    creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
    tablespace 4, index=4 krfil=4 prev_file=0
    unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
    Checkpoint cnt:106 scn: 0x0000.000c5980 07/26/2010 16:35:42
    Stop scn: 0xffff.ffffffff 07/25/2010 00:23:01
    Creation Checkpointed at scn: 0x0000.000022b3 04/20/2010 08:24:34
    thread:0 rba:(0x0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Offline scn: 0x0000.0005eca8 prev_range: 0
    Online Checkpointed at scn: 0x0000.0005eca9 07/24/2010 22:04:40
    thread:1 rba:(0x1.2.0)
    enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000 00000000 00000000
    Hot Backup end marker scn: 0x0000.00000000
    aux_file is NOT DEFINED

    ***************************************************************************
    TEMP FILE RECORDS
    ***************************************************************************
    (size = 56, compat size = 56, section max = 100, section in-use = 1,
    last-recid= 1, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 89, numrecs = 100)
    TEMP FILE #1: External File #201
    (name #11) /s01/rac10g/oradata/PROD/datafile/o1_mf_temp_64q6xyox_.tmp
    creation size=2560 block size=8192 status=0x1e head=11 tail=11 dup=1
    tablespace 3, index=5 krfil=1 prev_file=0
    unrecoverable scn: 0x0000.0005ecf4 07/24/2010 22:04:46

    ***************************************************************************
    TABLESPACE RECORDS
    ***************************************************************************
    (size = 68, compat size = 68, section max = 100, section in-use = 5,
    last-recid= 1, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 88, numrecs = 100)
    TABLESPACE #0 SYSTEM: recno=1
    First datafile link=1 Tablespace Flag=0
    Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
    Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
    TABLESPACE #1 UNDOTBS1: recno=2
    First datafile link=2 Tablespace Flag=0
    Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
    Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
    TABLESPACE #2 SYSAUX: recno=3
    First datafile link=3 Tablespace Flag=0
    Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
    Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
    TABLESPACE #4 USERS: recno=4
    First datafile link=4 Tablespace Flag=0
    Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
    Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
    TABLESPACE #3 TEMP: recno=5
    First datafile link=1 Tablespace Flag=1
    Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
    Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00

    ***************************************************************************
    RMAN CONFIGURATION RECORDS
    ***************************************************************************
    (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 90, numrecs = 50)

    ***************************************************************************
    FLASHBACK LOGFILE RECORDS
    ***************************************************************************
    (size = 84, compat size = 84, section max = 2048, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 139, numrecs = 2048)

    ***************************************************************************
    THREAD INSTANCE MAPPING RECORDS
    ***************************************************************************
    (size = 80, compat size = 80, section max = 8, section in-use = 8,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 156, numrecs = 8)
    PROD recno=1
    UNNAMED_INSTANCE_2 recno=2
    UNNAMED_INSTANCE_3 recno=3
    UNNAMED_INSTANCE_4 recno=4
    UNNAMED_INSTANCE_5 recno=5
    UNNAMED_INSTANCE_6 recno=6
    UNNAMED_INSTANCE_7 recno=7
    UNNAMED_INSTANCE_8 recno=8

    ***************************************************************************
    MTTR RECORDS
    ***************************************************************************
    (size = 100, compat size = 100, section max = 8, section in-use = 1,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 157, numrecs = 8)
    MTTR record for thread 1
    MTTR statistics status: 1
    Init time: Avg: 6707576 us, Times measured: 4
    File open time: Avg: 3702 us, Times measured: 15
    Log block read time: Avg: 20 us, Times measured: 65536
    Data block read/claim time: Avg: 170 us, Times measured: 1000
    Data block write time: Avg: 390 us
    1000 change vector apply time: Avg: 0 us, Times measured: 1
    Ratio Information:
    # of log blocks measured: 73289
    # of data blocks measured: 2867
    # of change vectors measured: 300847

    ***************************************************************************
    STANDBY DATABASE MAP RECORDS
    ***************************************************************************
    (size = 400, compat size = 400, section max = 10, section in-use = 10,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 160, numrecs = 10)

    ***************************************************************************
    RESTORE POINT RECORDS
    ***************************************************************************
    (size = 212, compat size = 212, section max = 2048, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 161, numrecs = 2048)

    ***************************************************************************
    LOG FILE HISTORY RECORDS
    ***************************************************************************
    (size = 56, compat size = 56, section max = 292, section in-use = 21,
    last-recid= 21, old-recno = 1, last-recno = 21)
    (extent = 1, blkno = 94, numrecs = 292)
    Earliest record:
    RECID #1 Recno 1 Record timestamp 07/24/10 22:04:55 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
    Low scn: 0x0000.0005eca9 07/24/10 22:04:40 Next scn: 0x0000.00060572
    Latest record:
    RECID #21 Recno 21 Record timestamp 07/26/10 16:35:42 Thread=1 Seq#=21 Link-Recid=20 kccic-Recid=2
    Low scn: 0x0000.000c09b2 07/25/10 00:13:00 Next scn: 0x0000.000c597f
    RECID #20 Recno 20 Record timestamp 07/25/10 00:13:00 Thread=1 Seq#=20 Link-Recid=19 kccic-Recid=2
    Low scn: 0x0000.000bb5f0 07/25/10 00:10:20 Next scn: 0x0000.000c09b2
    RECID #19 Recno 19 Record timestamp 07/25/10 00:10:20 Thread=1 Seq#=19 Link-Recid=18 kccic-Recid=2
    Low scn: 0x0000.000b62dd 07/24/10 23:44:17 Next scn: 0x0000.000bb5f0
    RECID #18 Recno 18 Record timestamp 07/24/10 23:44:17 Thread=1 Seq#=18 Link-Recid=17 kccic-Recid=2
    Low scn: 0x0000.000b1436 07/24/10 23:42:47 Next scn: 0x0000.000b62dd
    RECID #17 Recno 17 Record timestamp 07/24/10 23:42:47 Thread=1 Seq#=17 Link-Recid=16 kccic-Recid=2
    Low scn: 0x0000.000ac539 07/24/10 23:32:44 Next scn: 0x0000.000b1436
    RECID #16 Recno 16 Record timestamp 07/24/10 23:32:44 Thread=1 Seq#=16 Link-Recid=15 kccic-Recid=2
    Low scn: 0x0000.000a7574 07/24/10 23:22:55 Next scn: 0x0000.000ac539
    RECID #15 Recno 15 Record timestamp 07/24/10 23:22:55 Thread=1 Seq#=15 Link-Recid=14 kccic-Recid=2
    Low scn: 0x0000.000a22e8 07/24/10 23:17:26 Next scn: 0x0000.000a7574
    RECID #14 Recno 14 Record timestamp 07/24/10 23:17:26 Thread=1 Seq#=14 Link-Recid=13 kccic-Recid=2
    Low scn: 0x0000.0009d3df 07/24/10 23:05:46 Next scn: 0x0000.000a22e8
    RECID #13 Recno 13 Record timestamp 07/24/10 23:05:46 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=2
    Low scn: 0x0000.00098524 07/24/10 23:04:35 Next scn: 0x0000.0009d3df
    RECID #12 Recno 12 Record timestamp 07/24/10 23:04:35 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=2
    Low scn: 0x0000.0009368a 07/24/10 23:00:04 Next scn: 0x0000.00098524
    RECID #11 Recno 11 Record timestamp 07/24/10 23:00:04 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=2
    Low scn: 0x0000.0008e619 07/24/10 22:51:17 Next scn: 0x0000.0009368a
    RECID #10 Recno 10 Record timestamp 07/24/10 22:51:17 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=2
    Low scn: 0x0000.00089783 07/24/10 22:48:07 Next scn: 0x0000.0008e619
    RECID #9 Recno 9 Record timestamp 07/24/10 22:48:07 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=2
    Low scn: 0x0000.000846d3 07/24/10 22:46:27 Next scn: 0x0000.00089783
    RECID #8 Recno 8 Record timestamp 07/24/10 22:46:27 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=2
    Low scn: 0x0000.0007f863 07/24/10 22:45:32 Next scn: 0x0000.000846d3
    RECID #7 Recno 7 Record timestamp 07/24/10 22:45:32 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=2
    Low scn: 0x0000.0007a9df 07/24/10 22:45:18 Next scn: 0x0000.0007f863
    RECID #6 Recno 6 Record timestamp 07/24/10 22:45:18 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=2
    Low scn: 0x0000.000756d1 07/24/10 22:11:11 Next scn: 0x0000.0007a9df
    RECID #5 Recno 5 Record timestamp 07/24/10 22:11:11 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=2
    Low scn: 0x0000.00070844 07/24/10 22:10:12 Next scn: 0x0000.000756d1
    RECID #4 Recno 4 Record timestamp 07/24/10 22:10:12 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=2
    Low scn: 0x0000.0006b9c0 07/24/10 22:08:28 Next scn: 0x0000.00070844
    RECID #3 Recno 3 Record timestamp 07/24/10 22:08:28 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=2
    Low scn: 0x0000.00066813 07/24/10 22:06:08 Next scn: 0x0000.0006b9c0
    RECID #2 Recno 2 Record timestamp 07/24/10 22:06:08 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=2
    Low scn: 0x0000.00060572 07/24/10 22:04:55 Next scn: 0x0000.00066813
    RECID #1 Recno 1 Record timestamp 07/24/10 22:04:55 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
    Low scn: 0x0000.0005eca9 07/24/10 22:04:40 Next scn: 0x0000.00060572

    ***************************************************************************
    OFFLINE RANGE RECORDS
    ***************************************************************************
    (size = 200, compat size = 200, section max = 163, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 95, numrecs = 163)

    ***************************************************************************
    ARCHIVED LOG RECORDS
    ***************************************************************************
    (size = 584, compat size = 584, section max = 28, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 97, numrecs = 28)

    ***************************************************************************
    BACKUP SET RECORDS
    ***************************************************************************
    (size = 40, compat size = 40, section max = 409, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 98, numrecs = 409)

    ***************************************************************************
    BACKUP PIECE RECORDS
    ***************************************************************************
    (size = 736, compat size = 736, section max = 200, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 99, numrecs = 200)

    ***************************************************************************
    BACKUP DATAFILE RECORDS
    ***************************************************************************
    (size = 116, compat size = 116, section max = 282, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 108, numrecs = 282)

    ***************************************************************************
    BACKUP LOG RECORDS
    ***************************************************************************
    (size = 76, compat size = 76, section max = 215, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 110, numrecs = 215)

    ***************************************************************************
    DATAFILE COPY RECORDS
    ***************************************************************************
    (size = 660, compat size = 660, section max = 223, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 111, numrecs = 223)

    ***************************************************************************
    BACKUP DATAFILE CORRUPTION RECORDS
    ***************************************************************************
    (size = 44, compat size = 44, section max = 371, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 120, numrecs = 371)

    ***************************************************************************
    DATAFILE COPY CORRUPTION RECORDS
    ***************************************************************************
    (size = 40, compat size = 40, section max = 409, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 121, numrecs = 409)

    ***************************************************************************
    DELETION RECORDS
    ***************************************************************************
    (size = 20, compat size = 20, section max = 818, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 122, numrecs = 818)

    ***************************************************************************
    PROXY COPY RECORDS
    ***************************************************************************
    (size = 852, compat size = 852, section max = 249, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 123, numrecs = 249)

    ***************************************************************************
    INCARNATION RECORDS
    ***************************************************************************
    (size = 56, compat size = 56, section max = 292, section in-use = 2,
    last-recid= 2, old-recno = 1, last-recno = 2)
    (extent = 1, blkno = 138, numrecs = 292)
    Earliest record:
    RECID #1 Recno 1 Record timestamp
    Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
    Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
    Incarnation (parent inc#, flag)=(0, 0)
    Latest record:
    RECID #2 Recno 2 Record timestamp
    Resetlogs scn and time scn: 0x0000.0005eca9 07/24/10 22:04:40
    Previous Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
    Incarnation (parent inc#, flag)=(1, 2)
    RECID #1 Recno 1 Record timestamp
    Resetlogs scn and time scn: 0x0000.00000001 04/20/10 08:24:24
    Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
    Incarnation (parent inc#, flag)=(0, 0)

    ***************************************************************************
    RMAN STATUS RECORDS
    ***************************************************************************
    (size = 116, compat size = 116, section max = 141, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 155, numrecs = 141)

    ***************************************************************************
    DATAFILE HISTORY RECORDS
    ***************************************************************************
    (size = 568, compat size = 568, section max = 57, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 158, numrecs = 57)

    ***************************************************************************
    NORMAL RESTORE POINT RECORDS
    ***************************************************************************
    (size = 212, compat size = 212, section max = 2083, section in-use = 0,
    last-recid= 0, old-recno = 0, last-recno = 0)
    (extent = 1, blkno = 188, numrecs = 2083)
    *** END OF DUMP ***

  2. admin Avatar
    admin

    ALTER SESSION SET EVENTS ‘immediate trace name controlf level 10′;
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Note that for this event, the level controls how many records are to=20
    be dumped.

    The number of dumped records is 2^(level – 2) Hence :

    level 10 (2^8) =3D 256 records
    level 11 (2^9) =3D 512
    level 12 (2^10) =3D 1024

    (Watch max_dump_file size when dumping a high number of records)

    It is also sometimes useful to: “ALTER DATABASE BACKUP CONTROLFILE TO =
    TRACE”.

    (From Oracle 7.1.x)

    *DUMP OF CONTROL FILES, Seq # 202417 =3D 316b1
    * FILE HEADER:
    Software vsn=3D117502976=3D700f400, Compatibility =
    Vsn=3D117477376=3D7009000
    Db Id=3D4188500840=3Df9a77368, Db Name=3D’ECI_RPT’
    Control Seq=3D202417=3D316b1, File size=3D1238=3D4d6
    File Number=3D0, Blksiz=3D512, File Type=3D4
    =3D=3D> Control Seq Control file sequence number
    =3D=3D> File Number No concept of file no for control files
    =3D=3D> File Size This files Size (blocks)
    =3D=3D> Blksiz This files block size
    =3D=3D> File Type (See kcc.h)
    KCCTYPCF 1 * control file *
    KCCTYPRL 2 * redo log file *
    KCCTYPDF 3 * vanilla db data file *
    KCCTYPBC 4 * backup control file *

    * DATABASE ENTRY:
    (offset =3D 0x200, size =3D 144, max =3D 1, hi =3D 1)
    DF Version: creation=3D0x700f400 compatable=3D0x700b000, Date =
    05/27/95 03:34:38
    DB Name “ECI_RPT”
    Database flags =3D 0x00000147
    =3D=3D> ^^^^^^^^^^^^^^^^^^^(kcc.h)
    KCCDIMRE 0x0001 * whether media recovery enabled *
    KCCDICKD 0x0002 * if dictionary must be checked with control =
    file *
    KCCDIRLR 0x0004 * DB OPEN RESETLOGS required *
    KCCDIJNK 0x0008 * junk value from beta – do not reuse this flag =
    *
    KCCDIMRC 0x0010 * was/is last mounted READ_COMPATIBLE *
    KCCDICNV 0x0020 * control file was just created by convert from =
    v6 *
    KCCDIIRA 0x0040 * Incomplete Recovery Allowed when resetting =
    logs *
    KCCDIDBM 0x0080 * K_MLS – on next open DataBase Mac mode *
    KCCDICCF 0x0100 * Controlfile was created with CREATE =
    CONTROFILE *

    Incmplt recovery scn: 0.06d3ac0c Resetlogs scn: 0.02811906 count: =
    0xc99f490
    =3D=3D> ^^^ Last Incomplete recovery ^^^ Last Resetlogs
    Redo Version: creation=3D0x700f400 compatable=3D0x700c000
    #Data files =3D 204, #Online files =3D 1
    =3D=3D> ^^^ Can derive no of OFFLINE files from these figures.
    Database checkpoint: Thread=3D0 scn: 0.00000000
    Threads: #Enabled=3D1, #Open=3D0, Head=3D0, Tail=3D0
    enabled threads: 01000000 00000000 00000000 00000000 00000000 =
    00000000 …
    Max log members =3D 4, Max data members =3D 1
    Log hist =3D 0, Arch list: Head=3D0, Tail=3D0, Force scn: 0.00000000
    =3D=3D> ^^^^^^^^^ Size of Log history if being stored
    =0C
    * REDO THREAD ENTRIES:
    (offset =3D 0x290, size =3D 92, max =3D 6, hi =3D 1)
    * THREAD #1 – status:0x6 thread links forward:0 back:0
    =3D=3D> ^^^^(kcc.h)
    KCCRTOPN 0x01 * set if thread is OPeN *
    KCCRTENB 0x02 * set if thread is ENaBled *
    KCCRTPUB 0x04 * set if thread is enabled PUBlicly *
    #logs:3 first:1 last:3 current:3 last used seq#:0x0
    enabled at scn: 0.00000000 01/01/88 00:00:00
    Checkpointed at scn: 0.00000000 01/01/88 00:00:00
    thread:0 rba:(0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 =
    00000000 …
    LOG FILE ENTRIES:
    (offset =3D 0x4b8, size =3D 72, max =3D 96, hi =3D 3)
    * LOG FILE #1:
    (# 3) /opt/oracle/ECI_RPT/redo_log1.dbf
    Thread 1 redo log links: forward=3D2 backward=3D0
    siz=3D0x64000 seq=3D0x0 hws=3D0x0 bsz=3D512 nab=3D0x0 flg=3D0x1
    =3D=3D> seq=3DLog Seq no, hws=3DHdr write Seq# nab=3DNext available =
    block (kcc.h)=20
    =3D=3D> flg: KCCLESPL 0x0001 * set if log file spooled *
    KCCLENAL 0x0002 * set if No more ALocation may be done in =
    log *
    KCCLEUSM 0X0004 * if set USe Me as the next log to make =
    current *
    KCCLECUR 0x0008 * set if this is the current log *

    Archive links: fwrd=3D0 back=3D0 Prev scn: 0.00000000
    =3D=3D> ^^^Low SCN of PREVIOUS log
    Low scn: 0.00000000 01/01/88 00:00:00
    =3D=3D> ^^^SCN when log was switched INTO
    Next scn: 0.00000000 01/01/88 00:00:00
    =3D=3D> ^^^SCN After redo in this log (Ie: should =3D=3D low of NEXT =
    log)

    * DATA FILE #1:
    (#207) /usr/support/oracle/m4/pms505676/system_1_bpk.dbf
    size=3D51200 bsize=3D2048 status=3Dx213 head=3D207 tail=3D207 dup=3D1
    =3D=3D> ^^^^(kcc.h)
    KCCFESTS 0x0001 * belongs to System TableSpace *
    KCCFEONL 0x0002 * file is ONLine *
    KCCFERDE 0x0004 * ReaDing is Enabled *
    KCCFECGE 0x0008 * ChanGing is Enabled *
    KCCFEMRR 0x0010 * Media Recovery Required *
    KCCFEGEM 0x0020 * Generate End hot backup Marker at next open =
    *
    KCCFECKD 0x0040 * File entry generated by check dictionary *
    KCCFESOR 0x0080 * Save Offline scn Range at next checkpoint *
    KCCFERMF 0x0100 * Renamed Missing File *
    KCCFEGOI 0x0200 * Generate Off-line Immediate marker *

    Checkpoint cnt:61191 scn: 0.06d3ac0c stop scn: ffff.ffffffff 05/27/95 =
    03:34:39
    =3D=3D> Last Checkpoint SCN ^^^^^^^^^^^^^^ ^^^ Stop=3Dfff implies =
    OPEN or WARM backup
    Creation Checkpointed at scn: 0.00000003 12/04/93 06:37:16
    thread:0 rba:(0.0.0)
    enabled threads: 00000000 00000000 00000000 00000000 00000000 =
    00000000
    00000000 00000000
    Offline scn: 0.00000000
    Online Checkpointed at scn: 0.00000000 01/01/88 00:00:00
    thread:0 rba:(0.0.0)

Leave a Reply to admin Cancel reply

Your email address will not be published. Required fields are marked *