深入了解控制文件（二）

03月

671 0 0

数据文件条目

***************************************************************************
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

标签： Oracle

你还没有登录，请先登录或注册！

还没有人评论，欢迎说说您的想法！