天天看點
傳回

深入了解控制檔案

本次是對資料庫控制檔案核心内容做了分析，其它内容就不一一羅列了，如有分析有誤的還望多多指正，我會及時做出修正，謝謝~

實驗步驟

控制檔案是一個二進制檔案，為了檢視其内容，我們可以通過oracle指令轉儲出來進行檢視（以下指令來自oracle 19c）：

SQL> alter session set events 'immediate trace name controlf level 8';
 
Session altered.
 
SQL> select value from v$diag_info where name='Default Trace File';
 
VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13639.trc

解讀 19c trace

trc 檔案頭簡介

檔案頭對檔案來源做出了簡介：包括檔案資訊、資料庫資訊、DB版本号、系統資訊、執行個體資訊和程序資訊 

# 檔案名
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13639.trc
​
# 資料庫資訊
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME: /u01/app/oracle/product/19.3.0/dbhome_1
​
# 系統資訊
System name: Linux
Node name: node1
Release: 3.10.0-957.el7.x86_64
Version: #1 SMP Thu Oct 4 20:48:51 UTC 2018
Machine: x86_64
​
# 執行個體資訊
Instance name: orcl
Redo thread mounted by this instance: 1
​
# 程序資訊
Oracle process number: 35
Unix process pid: 13639, image: oracle@node1 (TNS V1-V3)

會話資訊 

# 會話資訊，包括時間、SID、serial#、使用者名、用戶端、用戶端驅動等資訊
*** 2020-01-24T10:31:06.667767-05:00
*** SESSION ID:(237.49972) 2020-01-24T10:31:06.667836-05:00
*** CLIENT ID:() 2020-01-24T10:31:06.667850-05:00
*** SERVICE NAME:(SYS$USERS) 2020-01-24T10:31:06.667859-05:00
*** MODULE NAME:(sqlplus@node1 (TNS V1-V3)) 2020-01-24T10:31:06.667868-05:00
*** ACTION NAME:() 2020-01-24T10:31:06.667877-05:00
*** CLIENT DRIVER:(SQL*PLUS) 2020-01-24T10:31:06.667885-05:00

控制檔案頭  

# dump 控制檔案，序号為 543
DUMP OF CONTROL FILES, Seq # 543 = 0x21f
# 控制檔案頭
V10 STYLE FILE HEADER:
# 相容版本号
Compatibility Vsn = 318767104=0x13000000
# 資料庫的dbid、資料庫名
Db ID=1558045014=0x5cdde156, Db Name='ORCL'
Activation ID=0=0x0
# 控制檔案序号、檔案大小共 1142 個檔案塊
Control Seq=543=0x21f, File size=1142=0x476
# 檔案号為0、塊大小為16384，即16k塊大小、檔案類型為控制檔案
File Number=0, Blksiz=16384, File Type=1 CONTROL

查詢 V$CONTROLFILE_RECORD_SECTION 整理可知 

SQL> SELECT TYPE, 
  1         RECORD_SIZE, 
  2         RECORDS_TOTAL, 
  3         RECORD_SIZE*RECORDS_TOTAL, 
  4         ceil(record_size*records_total/((8*1024)-24))
  5    FROM v$controlfile_record_section;
 
TYPE                         RECORD_SIZE RECORDS_TOTAL SIZE     BLOCK#    BLOCKS
---------------------------- ----------- ------------- ------- ------- ---------
TITLE                                  1             1               1         1
DATABASE                             316             1     316       2         1
CKPT PROGRESS                       8180            11   89980       3        12
REDO THREAD                          256             8    2048      15         1
REDO LOG                              72            16    1152      16         1
DATAFILE                             520          1024  532480      17        66
FILENAME                             524          4146 2172504      83       266
TABLESPACE                           180          1024  184320     349        23
TEMPORARY FILENAME                    56          1024   57344     372         8
RMAN CONFIGURATION                  1108            50   55400     380         7
LOG HISTORY                           56           292   16352     387         3
OFFLINE RANGE                        200          1063  212600     390        27
ARCHIVED LOG                         584            28   16352     417         3
BACKUP SET                            96          1022   98112     420        13
BACKUP PIECE                         780          1006  784680     433        97
BACKUP DATAFILE                      200          1063  212600     530        27
BACKUP REDOLOG                        76           215   16340     557         3
DATAFILE COPY                        736          1000  736000     560        91
BACKUP CORRUPTION                     44          1115   49060     651         7
COPY CORRUPTION                       40          1227   49080     658         7
DELETED OBJECT                        20           818   16360     665         3
PROXY COPY                           928          1004  931712     668       115
BACKUP SPFILE                        124           131   16244     783         2
DATABASE INCARNATION                  56           292   16352     785         3
FLASHBACK LOG                         84          2048  172032     788        22
RECOVERY DESTINATION                 180             1     180     810         1
INSTANCE SPACE RESERVATION            28          1055   29540     811         4
REMOVABLE RECOVERY FILES              32          1000   32000     815         4
RMAN STATUS                          116           141   16356     819         3
THREAD INSTANCE NAME MAPPING          80             8     640     822         1
MTTR                                 100             8     800     823         1
DATAFILE HISTORY                     568            57   32376     824         4
STANDBY DATABASE MATRIX              400           128   51200     828         7
GUARANTEED RESTORE POINT             256          2048  524288     835        65
RESTORE POINT                        256          2108  539648     900        67
DATABASE BLOCK CORRUPTION             80          8384  670720     967        83
ACM OPERATION                        104            64    6656    1050         1
FOREIGN ARCHIVED LOG                 604          1002  605208    1051        75
PDB RECORD                           780            10    7800    1126         1
AUXILIARY DATAFILE COPY              584           128   74752    1127        10
MULTI INSTANCE REDO APPLY            556             1     556    1137         1
PDBINC RECORD                        144           113   16272    1139         2
TABLESPACE KEY HISTORY               108           151   16308    1141         2

資料庫條目資訊

其中包括資料庫檔案及日志檔案數量、檢查點等資訊： 

***************************************************************************
DATABASE ENTRY
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='DATABASE';
# TYPE           RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# -------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# DATABASE               316             1            1           0          0          0          0
# size指出資料庫項的位元組數，本例中為 316 byte;
# max指出最大的塊
# in-use目前正在使用的塊
 (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)
 # 建立時間
 01/21/2020 08:31:18
 # 資料庫名稱
 DB Name "ORCL"
 Database flags = 0x00404000 0x00001000 0x00000080
 # 控制檔案建立時間
 Controlfile Creation Timestamp  01/21/2020 08:31:19
 # 資料庫是否進行過不完全回複
 Incmplt recovery scn: 0x0000000000000000
 # 控制檔案啟用 resetlog 的時間及 scn
 Resetlogs scn: 0x0000000000000001 Resetlogs Timestamp  01/21/2020 08:31:18
 # 啟用 Resetlogs 之前的 scn 值和時間
 Prior resetlogs scn: 0x0000000000000000 Prior resetlogs Timestamp  01/01/1988 00:00:00
 # 重做日志檔案的版本是13.0.0.0
 Redo Version: compatible=0x13000000
 # 資料檔案總數以及 online 檔案數
 #Data files = 5, #Online files = 5
 # 目前啟用了一個線程，當然，也僅僅打開了這一個線程，資料庫的檢查點 scn，即 v$database.checkpoint_change#
 Database checkpoint: Thread=1 scn: 0x000000000008e5e1
 # 說明有頭尾的概念
 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
 # 說明最多一個日志組有３個成員，經測試可以添加3個以上的成員到日志組中
 # Oracle 目前還不支援資料檔案的多路複用，是以，Max data members 的值為 1，這個條目是為以後的版本更新而預留的。
 Max log members = 3, Max data members = 1
 # 凡是開始 scn 小于 Force scn 的重做都被歸檔。強制 scn 是所有重做都被歸檔的 scn。後者為目前日志檔案的first_change#
 Arch list: Head=0, Tail=0, Force scn: 0x0000000000077407scn: 0x0000000000000000
 Activation ID: 1558025302
 SCN compatibility 3
 Auto-rollover enabled
 # current 目前日志的 first_change# scn
 Controlfile Checkpointed at scn:  0x000000000008f4d0 01/24/2020 10:30:43
 thread:0 rba:(0x0.0.0)
# 開啟的 thread
 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
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='CKPT PROGRESS';
# TYPE           RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# -------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# CKPT PROGRESS         8180            11            0           0          0          0          0
(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
THREAD #1 - status:0x2 flags:0x0 dirty:29
# 這個就是自 low cache rba 寫入到 on disk rba，即執行個體恢複前滾的 rba 位址段
# on disk rba是磁盤上的最高的重做值，在進行實力恢複應用重做的時候必須達到這個值。
low cache rba:(0xe.22d68.0) on disk rba:(0xe.22d90.0)
# on disk scn是on disk rba 處的 scn 值
on disk scn: 0x000000000008f4d4 01/24/2020 10:30:43
# 啟用 Resetlogs 時的 scn 值和時戳，和資料庫項中的相應條目是一緻的
resetlogs scn: 0x0000000000000001 01/21/2020 08:31:18
# 心跳機制
heartbeat: 1030490376 mount id: 1558287699
# 如下 7 個線程同上
THREAD #2 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 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: 0x0000000000000000 01/01/1988 00:00:00
resetlogs scn: 0x0000000000000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0

補充資料庫條目  

***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
(size = 900, compat size = 900, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 390, numrecs = 1)
# 主要是控制檔案自動備份，下次備份的序列
Control AutoBackup date(dd/mm/yyyy)=21/ 1/2020
Next AutoBackup sequence= 0
Database recovery target inc#:1, Last open inc#:1
flg:0x0, flag:0x2000
Change tracking state=0, file index=0, checkpoint count=0scn: 0x0000000000000000
# Oracle 閃回功能
Flashback log count=0, block count=0
Desired flashback log size=0 blocks
Oldest guarantee restore point=0
Highest thread enable/disable scn: 0x0000000000000001
Number of Open thread with finite next SCN in last log: 0
Number of half-enabled redo threads: 0
Sum of absolute file numbers for files currently being moved online: 0
Minimum flashback scn: 0x0000000000000000
Cross-endian dictionary SCN scn: 0x0000000000000000
Old recovery timestamp:  01/01/1988 00:00:00
New recovery timestamp:  01/01/1988 00:00:00
Head filename record number for pre-created datafiles=0
Tail filename record number for pre-created datafiles=0

重做線程條目  

***************************************************************************
REDO THREAD RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='REDO THREAD';
# TYPE           RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# -------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# REDO THREAD            256             8            1           0          0          0          0
 (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:0x40f thread links forward:0 back:0
 #logs:3 first:1 last:3 current:2 last used seq#:0xe
# 啟用線程 1 時的 scn 值
 enabled at scn: 0x0000000000000001 01/21/2020 08:31:24
# 禁用線程 1 時的 scn 值，因為該線程目前處于打開狀态，是以該值為無窮大
 disabled at scn: 0x0000000000000000 01/01/1988 00:00:00
# 打開線程的時戳，目前線程以及被哪個執行個體打開
 opened at 01/24/2020 09:24:40 by instance orcl
Checkpointed at scn:  0x000000000008e5e1 01/24/2020 09:24:40
 thread:1 rba:(0xe.20ac0.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
 # 對應select max(sequence#) from v$log_history;
 log history: 13
 restore point keep sequence: 0

日志檔案條目 

***************************************************************************
LOG FILE RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='REDO LOG';
# TYPE           RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# -------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# REDO LOG                72            16            3           0          0          3          0
 (size = 72, compat size = 72, section max = 16, section in-use = 3,
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
# 标記日志檔案是否删除
LOG FILE #1: 
# 指明此日志組有幾個成員
  name #1: /oradata/ORCL/redo01a.log
# 這裡有個forward、backward，把日志組連結起來
 Thread 1 redo log links: forward: 2 backward: 0
# nab是日志檔案中LGWR可用的下一個資料塊的位址，如果這個值是無窮大，說明這個日志檔案是目前（LGWR正在寫入）的日志檔案
 siz: 0x32000 seq: 0x0000000d hws: 0x4 bsz: 512 nab: 0x28c37 flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000000000077407
# 對應 v$log.first_change# 和 last_change#
# 日志發生切換時會配置設定一個低scn和一個高scn
# 低 scn 就是上一個日志的高 scn 的值，而高scn則設定為無窮大，直到切換到下一個日志檔案時，再将目前日志的高scn設定為下一個日志檔案的低scn，将下一個日志檔案的高scn設定為無窮大。
 Low scn: 0x0000000000081b9c 01/21/2020 11:23:59
 Next scn: 0x0000000000087599 01/21/2020 11:28:36
LOG FILE #2: 
  name #2: /oradata/ORCL/redo02a.log
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x32000 seq: 0x0000000e hws: 0x7 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000000000081b9c
 Low scn: 0x0000000000087599 01/21/2020 11:28:36
# 對于目前(current)日志檔案，其最終scn不可知，是以next scn被設定為無窮大
 Next scn: 0xffffffffffffffff 01/01/1988 00:00:00
LOG FILE #3: 
  name #3: /oradata/ORCL/redo03a.log
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x32000 seq: 0x0000000c hws: 0x4 bsz: 512 nab: 0x293dd flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x000000000006af2c
 Low scn: 0x0000000000077407 01/21/2020 11:21:29
 Next scn: 0x0000000000081b9c 01/21/2020 11:23:59

資料檔案條目 

***************************************************************************
DATA FILE RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='DATAFILE';
# TYPE           RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# -------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# DATAFILE               520          1024            5           0          0          5          0
(size = 520, compat size = 520, section max = 1024, section in-use = 5,
  last-recid= 5, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 1024)
# 檔案 1
DATA FILE #1: 
# 資料檔案名稱
  name #4: /oradata/ORCL/system01.dbf
# 檔案大小，塊大小，頭尾
creation size=89600 block size=8192 status=0xe flg=0x1 head=4 tail=4 dup=1
# PDB_id，檔案所屬表空間，0 說明是系統表空間
 pdb_id 0, tablespace 0, index=1 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
# 檢查點計數、檢查點scn：為資料檔案頭和控制檔案頭第一次檢查，如果通過則資料庫進行二次檢查，第二次檢查資料檔案頭的開始scn和控制檔案中記錄的該檔案的結束scn是否一緻
 Checkpoint cnt:19 scn: 0x000000000008e5e1 01/24/2020 09:24:40
# 此時stop scn被置為無窮大
 Stop scn: 0xffffffffffffffff 01/21/2020 14:55:06
# creation scn 對應 v$datafile.creation_change#
 Creation Checkpointed at scn:  0x000000000000000b 01/21/2020 08:31:36
 thread:1 rba:(0x1.3.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
# offline scn 也對應 v$datafile.offline_change#
 Offline scn: 0x0000000000000000 prev_range: 0
# 當檔案聯機時，檔案聯機時的檢查點 scn 作為聯機 scn 儲存在控制檔案中
# 由于系統表空間的資料檔案永遠不能脫機，是以系統資料檔案的脫機 scn 應該為 0x0000.00000000
 Online Checkpointed at scn:  0x0000000000000000 
 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
# 熱備結束時的 scn
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
# plugin scn 同上
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #2: 
  name #5: /oradata/ORCL/sysaux01.dbf
creation size=70400 block size=8192 status=0xe flg=0x1 head=5 tail=5 dup=1
 pdb_id 0, tablespace 1, index=2 krfil=2 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:19 scn: 0x000000000008e5e1 01/24/2020 09:24:40
 Stop scn: 0xffffffffffffffff 01/21/2020 14:55:06
 Creation Checkpointed at scn:  0x0000000000000dbc 01/21/2020 08:31:52
 thread:1 rba:(0x1.34d0.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
 Offline scn: 0x0000000000000000 prev_range: 0
 Online Checkpointed at scn:  0x0000000000000000 
 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
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #3: 
  name #6: /oradata/ORCL/undotbs01.dbf
creation size=25600 block size=8192 status=0xe flg=0x1 head=6 tail=6 dup=1
 pdb_id 0, tablespace 2, index=3 krfil=3 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:19 scn: 0x000000000008e5e1 01/24/2020 09:24:40
 Stop scn: 0xffffffffffffffff 01/21/2020 14:55:06
 Creation Checkpointed at scn:  0x0000000000001177 01/21/2020 08:31:57
 thread:1 rba:(0x1.42a0.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
 Offline scn: 0x0000000000000000 prev_range: 0
 Online Checkpointed at scn:  0x0000000000000000 
 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
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #4: 
  name #8: /oradata/ORCL/users01.dbf
creation size=64000 block size=8192 status=0xe flg=0x1 head=8 tail=8 dup=1
 pdb_id 0, tablespace 4, index=5 krfil=4 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:19 scn: 0x000000000008e5e1 01/24/2020 09:24:40
 Stop scn: 0xffffffffffffffff 01/21/2020 14:55:06
 Creation Checkpointed at scn:  0x000000000000123c 01/21/2020 08:32:05
 thread:1 rba:(0x1.43ad.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
 Offline scn: 0x0000000000000000 prev_range: 0
 Online Checkpointed at scn:  0x0000000000000000 
 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
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #5: 
  name #9: /oradata/ORCL/usertbs01.dbf
creation size=25600 block size=8192 status=0xe flg=0x1 head=9 tail=9 dup=1
 pdb_id 0, tablespace 5, index=6 krfil=5 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:19 scn: 0x000000000008e5e1 01/24/2020 09:24:40
 Stop scn: 0xffffffffffffffff 01/21/2020 14:55:06
 Creation Checkpointed at scn:  0x0000000000001252 01/21/2020 08:32:07
 thread:1 rba:(0x1.43d9.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
 Offline scn: 0x0000000000000000 prev_range: 0
 Online Checkpointed at scn:  0x0000000000000000 
 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
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0

臨時檔案條目  

***************************************************************************
TEMP FILE RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='TEMPORARY FILENAME';
# TYPE               RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# ------------------ ----------- ------------- ------------ ----------- ---------- ---------- ----------
# TEMPORARY FILENAME          56          1024            1           0          0          1          0
 (size = 56, compat size = 56, section max = 1024, section in-use = 1,
  last-recid= 1, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 189, numrecs = 1024)
TEMP FILE #1: External File #201 
  name #7: /oradata/ORCL/temp01.dbf
creation size=2560 block size=8192 status=0x1e head=7 tail=7 dup=1
 pdb_id 0, tablespace 3, index=4 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000001229 01/21/2020 08:31:59

表空間條目 

***************************************************************************
TABLESPACE RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='TABLESPACE';
# TYPE               RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# ------------------ ----------- ------------- ------------ ----------- ---------- ---------- ----------
# TABLESPACE                 180          1024            6           0          0          6          0
 (size = 180, compat size = 180, section max = 1024, section in-use = 6,
  last-recid= 6, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 177, numrecs = 1024)
# 表空間編号
PDB ID 0 TABLESPACE #0 SYSTEM: recno=1
# 表空間第一個資料檔案
 First datafile link=1  Tablespace Flag=0x0000
# 表空間基于 pitr 模式的開始時的 scn
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
# 同上最新的 scn
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00
PDB ID 0 TABLESPACE #1 SYSAUX: recno=2
 First datafile link=2  Tablespace Flag=0x0000
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00
PDB ID 0 TABLESPACE #2 UNDOTBS1: recno=3
 First datafile link=3  Tablespace Flag=0x0000
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00
PDB ID 0 TABLESPACE #3 TEMPTS1: recno=4
 First tempfile link=1  Tablespace Flag=0x0001
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00
PDB ID 0 TABLESPACE #4 USERS: recno=5
 First datafile link=4  Tablespace Flag=0x0000
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00
PDB ID 0 TABLESPACE #5 USERTBS: recno=6
 First datafile link=5  Tablespace Flag=0x0000
 Tablespace PITR mode start scn: 0x0000000000000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000000000000000 01/01/1988 00:00:00

RMAN 配置條目 

***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='RMAN CONFIGURATION';
# TYPE               RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# ------------------ ----------- ------------- ------------ ----------- ---------- ---------- ----------
# RMAN CONFIGURATION        1108            50            0           0          0          0          0
# 未使用此功能故 section in-use = 0
 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 193, numrecs = 50)

閃回日志檔案條目  

***************************************************************************
FLASHBACK LOGFILE RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='FLASHBACK LOG';
# TYPE               RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# ------------------ ----------- ------------- ------------ ----------- ---------- ---------- ----------
# FLASHBACK LOG               84          2048            0           0          0          0          0
# 未使用此功能故 section in-use = 0
 (size = 84, compat size = 84, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 392, numrecs = 2048)

程序執行個體映射條目 

***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
# 如下對應此下的資訊如每條記錄的大小,記錄個數;已使用記錄數
# select * from v$controlfile_record_section where type='THREAD INSTANCE NAME MAPPING';
# TYPE                         RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID     CON_ID
# ---------------------------- ----------- ------------- ------------ ----------- ---------- ---------- ----------
# THREAD INSTANCE NAME MAPPING          80             8            8           0          0          0          0
 (size = 80, compat size = 80, section max = 8, section in-use = 8,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 409, numrecs = 8)
orcl 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

　　此處隻是對資料庫控制檔案核心内容做了分析，其它内容就不一一羅列了，如有分析有誤的還望多多指正，我會及時做出修正，謝謝~

深入了解控制檔案
Oracle資料庫
上一篇: Postgresql實戰經驗之alter table 開小差了
下一篇: 1z0-062 題庫解析6

繼續閱讀