《深入淺出Oracle》的一個讀者在我的留言板上提出一個問題
alter session set eventsimmediate trace name controlf level ;
注意一下他的輸出:
DUMP OF CONTROL FILESSeq # = x e
VSTYLE FILE HEADER:
Compatibility Vsn == xa
Db ID== x ec d Db Name= TESTDB
Activation ID== x
Control Seq== x e File size= = x a
File Number=Blksiz= File Type= CONTROL
原來是V
在Oracle
在這個輸出中
記錄一下
DUMP OF CONTROL FILESSeq # = x a
VSTYLE FILE HEADER:
Compatibility Vsn == xa
Db ID== x Db Name= EYGLE
Activation ID== x
Control Seq== x a File size= = x ae
File Number=Blksiz= File Type= CONTROL
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size =compat size = section max = section in use =
lastrecid= old recno = last recno = )
(extent =blkno = numrecs = ) / / : :
DB NameEYGLE
Database flags =x x
Controlfile Creation Timestamp/ / : :
Incmplt recovery scn:x
Resetlogs scn:x Resetlogs Timestamp / / : :
Prior resetlogs scn:x Prior resetlogs Timestamp / / : :
Redo Version: compatible=xa
#Data files =#Online files =
Database checkpoint: Thread=scn: x a
Threads: #Enabled=#Open= Head= Tail=
enabled threads:
Max log members =Max data members =
Arch list: Head=Tail= Force scn: x a ebscn: x
Activation ID:
Controlfile Checkpointed at scn:x d / / : :
thread:rba:( x )
enabled threads:
*************************************************************************** CHECKPOINT PROGRESS RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = )
(extent =blkno = numrecs = )
THREAD #status: x flags: x dirty: low cache rba:( x dc ) on disk rba:( x df ) on disk scn: x c / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: THREAD # status: x flags: x dirty: low cache rba:( x ) on disk rba:( x ) on disk scn: x / / : : resetlogs scn: x / / : : heartbeat: mount id: *************************************************************************** EXTENDED DATABASE ENTRY ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) Control AutoBackup date(dd/mm/yyyy)= / / Next AutoBackup sequence= Database recovery target inc#: Last open inc#: flg: x flag: x Change tracking state= file index= checkpoint count= Flashback log count= block count= Oldest guarantee restore point= ***************************************************************************
REDO THREAD RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) THREAD # status: xf thread links forward: back: #logs: first: last: current: last used seq#: x enabled at scn: x / / : : disabled at scn: x / / : : opened at / / : : by instance eygle Checkpointed at scn: x a / / : : thread: rba:( x a d ) enabled threads: log history: ***************************************************************************
LOG FILE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) LOG FILE # : (name # ) D:\ORADATA\EYGLE\ONLINELOG\O _MF_ _ G OGOQG_ LOG (name # ) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O _MF_ _ G OGTJH_ LOG Thread redo log links: forward: backward: siz: x seq: x hws: xd bsz: nab: x ed flg: x dup: Archive links: fwrd: back: Prev scn: x a eb Low scn: x e d / / : : Next scn: x b / / : : LOG FILE # : (name # ) D:\ORADATA\EYGLE\ONLINELOG\O _MF_ _ G OGZKN_ LOG (name # ) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O _MF_ _ G OH JL_ LOG Thread redo log links: forward: backward: siz: x seq: x hws: x bsz: nab: xffffffff flg: x dup: Archive links: fwrd: back: Prev scn: x e d Low scn: x b / / : : Next scn: xffff ffffffff / / : : LOG FILE # : (name # ) D:\ORADATA\EYGLE\ONLINELOG\O _MF_ _ G OH Q_ LOG (name # ) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O _MF_ _ G OH XX_ LOG Thread redo log links: forward: backward: siz: x seq: x hws: xf bsz: nab: x ffd flg: x dup: Archive links: fwrd: back: Prev scn: x bc Low scn: x a eb / / : : Next scn: x e d / / : : ***************************************************************************
DATA FILE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) DATA FILE # : (name # ) D:\ORADATA\EYGLE\DATAFILE\O _MF_SYSTEM_ G OHFX _ DBF creation size= block size= status= xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x / / : : Checkpoint cnt: scn: x a / / : : Stop scn: xffff ffffffff / / : : Creation Checkpointed at scn: x / / : : thread: rba:( x ) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:( x ) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE # : (name # ) D:\ORADATA\EYGLE\DATAFILE\O _MF_UNDOTBS _ G OJ NB_ DBF creation size= block size= status= xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x / / : : Checkpoint cnt: scn: x a / / : : Stop scn: xffff ffffffff / / : : Creation Checkpointed at scn: x cc / / : : thread: rba:( x a b ) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:( x ) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE # : (name # ) D:\ORADATA\EYGLE\DATAFILE\O _MF_SYSAUX_ G OJHP _ DBF creation size= block size= status= xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x / / : : Checkpoint cnt: scn: x a / / : : Stop scn: xffff ffffffff / / : : Creation Checkpointed at scn: x e / / : : thread: rba:( x ac ) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:( x ) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE # : (name # ) D:\ORADATA\EYGLE\DATAFILE\O _MF_USERS_ G OJYYS_ DBF creation size= block size= status= xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x / / : : Checkpoint cnt: scn: x a / / : : Stop scn: xffff ffffffff / / : : Creation Checkpointed at scn: x f / / : : thread: rba:( x f ) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:( x ) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED ***************************************************************************
TEMP FILE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) TEMP FILE # : External File # (name # ) D:\ORADATA\EYGLE\DATAFILE\O _MF_TEMP_ G OJPDX_ TMP creation size= block size= status= x e head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x / / : : TEMP FILE # : External File # creation size= block size= status= xc head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x a / / : : *************************************************************************** TABLESPACE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) TABLESPACE # SYSTEM: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : TABLESPACE # UNDOTBS : recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : TABLESPACE # SYSAUX: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : TABLESPACE # TEMP: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : TABLESPACE # USERS: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : TABLESPACE # TEMP : recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x / / : : Tablespace PITR last completion scn: x / / : : ***************************************************************************
RMAN CONFIGURATION RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** FLASHBACK LOGFILE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** THREAD INSTANCE MAPPING RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) eygle recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= ***************************************************************************
MTTR RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) MTTR record for thread MTTR statistics status: Init time: Avg: us Times measured: File open time: Avg: us Times measured: Log block read time: Avg: us Times measured: Data block read/claim time: Avg: us Times measured: Data block write time: Avg: us change vector apply time: Avg: us Times measured: Ratio Information: # of log blocks measured: # of data blocks measured: # of change vectors measured: *************************************************************************** STANDBY DATABASE MAP RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** RESTORE POINT RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) ***************************************************************************
LOG FILE HISTORY RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) Earliest record: RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x a Latest record: RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x e d / / : : Next scn: x b RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x a eb / / : : Next scn: x e d RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x bc / / : : Next scn: x a eb RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x bc RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x fb / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x b / / : : Next scn: x fb RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x da / / : : Next scn: x b RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x eaff / / : : Next scn: x da RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x eaff RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x e / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x c a / / : : Next scn: x e RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x c a RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x efa / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x f d / / : : Next scn: x efa RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x b / / : : Next scn: x f d RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x b RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x ed / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x ed RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x e f / / : : Next scn: x RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x a / / : : Next scn: x e f RECID # Recno Record timestamp / / : : Thread= Seq#= Link Recid= kccic Recid= Low scn: x / / : : Next scn: x a *************************************************************************** OFFLINE RANGE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** ARCHIVED LOG RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP SET RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP PIECE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP DATAFILE RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP LOG RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE COPY RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP DATAFILE CORRUPTION RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE COPY CORRUPTION RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** DELETION RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) ***************************************************************************
PROXY COPY RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** INCARNATION RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) Earliest record: RECID # Recno Record timestamp Resetlogs scn and time scn: x / / : : Previous Resetlogs scn and time scn: x / / : : Incarnation (parent inc# flag)=( ) Latest record: RECID # Recno Record timestamp Resetlogs scn and time scn: x / / : : Previous Resetlogs scn and time scn: x / / : : Incarnation (parent inc# flag)=( ) ***************************************************************************
RMAN STATUS RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE HISTORY RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *************************************************************************** NORMAL RESTORE POINT RECORDS ***************************************************************************
(size =compat size = section max = section in use = last recid= old recno = last recno = ) (extent = blkno = numrecs = ) *** END OF DUMP ***
tml
From:http://tw.wingwit.com/Article/program/Oracle/201311/17097.html