本文共 4524 字，大约阅读时间需要 15 分钟。
SQL> select type, record_size, records_total from v$controlfile_record_section;TYPE RECORD_SIZE RECORDS_TOTAL---------------------------- ----------- -------------DATABASE 316 1CKPT PROGRESS 8180 35REDO THREAD 256 32REDO LOG 72 192DATAFILE 520 1024FILENAME 524 4674TABLESPACE 68 1024TEMPORARY FILENAME 56 1024RMAN CONFIGURATION 1108 50LOG HISTORY 56 292OFFLINE RANGE 200 1063ARCHIVED LOG 584 136BACKUP SET 40 1227BACKUP PIECE 736 1000BACKUP DATAFILE 200 1063BACKUP REDOLOG 76 430DATAFILE COPY 736 1000BACKUP CORRUPTION 44 1115COPY CORRUPTION 40 1227DELETED OBJECT 20 818PROXY COPY 928 1004BACKUP SPFILE 124 131DATABASE INCARNATION 56 292FLASHBACK LOG 84 2048RECOVERY DESTINATION 180 1INSTANCE SPACE RESERVATION 28 1055REMOVABLE RECOVERY FILES 32 1000RMAN STATUS 116 141THREAD INSTANCE NAME MAPPING 80 32MTTR 100 32DATAFILE HISTORY 568 57STANDBY DATABASE MATRIX 400 31GUARANTEED RESTORE POINT 212 2048RESTORE POINT 212 2083DATABASE BLOCK CORRUPTION 80 8384ACM OPERATION 104 64FOREIGN ARCHIVED LOG 604 1002 v$controlfile_record_section 的数据实际来源于X$KCCRS内部表v$controlfile_record_section 视图的定义select inst_id, decode(indx, 0, 'DATABASE', 1, 'CKPT PROGRESS', 2, 'REDO THREAD', 3, 'REDO LOG', 4, 'DATAFILE', 5, 'FILENAME', 6, 'TABLESPACE', 7, 'TEMPORARY FILENAME', 8, 'RMAN CONFIGURATION', 9, 'LOG HISTORY', 10, 'OFFLINE RANGE', 11, 'ARCHIVED LOG', 12, 'BACKUP SET', 13, 'BACKUP PIECE', 14, 'BACKUP DATAFILE', 15, 'BACKUP REDOLOG', 16, 'DATAFILE COPY', 17, 'BACKUP CORRUPTION', 18, 'COPY CORRUPTION', 19, 'DELETED OBJECT', 20, 'PROXY COPY', 21, 'BACKUP SPFILE', 23, 'DATABASE INCARNATION', 24, 'FLASHBACK LOG', 25, 'RECOVERY DESTINATION', 26, 'INSTANCE SPACE RESERVATION', 27, 'REMOVABLE RECOVERY FILES', 28, 'RMAN STATUS', 29, 'THREAD INSTANCE NAME MAPPING', 30, 'MTTR', 31, 'DATAFILE HISTORY', 32, 'STANDBY DATABASE MATRIX', 33, 'GUARANTEED RESTORE POINT', 34, 'RESTORE POINT', 35, 'DATABASE BLOCK CORRUPTION', 36, 'ACM OPERATION', 37, 'FOREIGN ARCHIVED LOG', 'UNKNOWN'), rsrsz, rsnum, rsnus, rsiol, rsilw, rsrlw from x$kccrs where indx not in (22)下表罗列出了controlfile 控制文件可能出现的数据库各类文件的记录，如数据文件记录、文件名记录、表空间记录等：
31. Datafile History Record: (1 per dropped datafile)
本文转自maclean_007 51CTO博客，原文链接: http://blog.51cto.com/maclean/1278172
转载地址：http://lpgia.baihongyu.com/