表空间条目

***************************************************************************
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
此处只是对数据库控制文件核心内容做了分析,其它内容就不一一罗列了,如有分析有误的还望多多指正,我会及时做出修正,谢谢~