深入了解oracle控制文件

实验步骤

控制文件是一个二进制文件，为了查看其内容，我们可以通过oracle命令转储出来进行查看（以下命令来自oracle 19c）：

1
2
3
4
5
6
7
8
9
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版本号、系统信息、实例信息和进程信息 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# 文件名
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)

会话信息

1
2
3
4
5
6
7
8
# 会话信息，包括时间、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

控制文件头 

1
2
3
4
5
6
7
8
9
10
11
12
13
# 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 整理可知

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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

数据库条目信息

其中包括数据库文件及日志文件数量、检查点等信息： 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
***************************************************************************
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

检查点计数条目

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
***************************************************************************
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

补充数据库条目 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
***************************************************************************
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

重做线程条目 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
***************************************************************************
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

日志文件条目

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
***************************************************************************
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

数据文件条目

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
***************************************************************************
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

临时文件条目 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
***************************************************************************
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

表空间条目

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
***************************************************************************
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 配置条目

1
2
3
4
5
6
7
8
9
10
11
12
***************************************************************************
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)

闪回日志文件条目 

1
2
3
4
5
6
7
8
9
10
11
12
***************************************************************************
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)

进程实例映射条目

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
***************************************************************************
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

https://www.cnblogs.com/sandata/p/12515852.html

posted @ 2021-09-28 14:41  da0h1  阅读(763)  评论(0)    收藏  举报