转储控制文件信息

2010/07/26 by admin 2 Comments

当前控制文件的内容可以通过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”]

Filed Under: Oracle Tagged With: ORA, Oracle Bug, RAC, sql

Comments

admin says

2010/07/26 at 21:23

转储文件示例：
[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 ***

回复
admin says

2010/08/18 at 23:14

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)
…

回复

转储控制文件信息

Comments

Comment 取消回复