今天查看数据库日志，出现下面的日志：

Expanded controlfile section 11 from 28 to 56 records

Requested to grow by 28 records; added 1 blocks of records

于是估计查找跟control file有关的视图：

select table_name from dict where table_name like upper('%control%');

TABLE_NAME

------------------------------

DBA_REPRESOL_STATS_CONTROL

ALL_REPRESOL_STATS_CONTROL

USER_REPRESOL_STATS_CONTROL

DBA_HIST_WR_CONTROL

GV$DLM_TRAFFIC_CONTROLLER

V$DLM_TRAFFIC_CONTROLLER

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

GV$CONTROLFILE

GV$CONTROLFILE_RECORD_SECTION

V$SYSTEM_FIX_CONTROL

V$SESSION_FIX_CONTROL

V$BACKUP_CONTROLFILE_DETAILS

V$BACKUP_CONTROLFILE_SUMMARY

看一下视图名，确定看视图V$CONTROLFILE_RECORD_SECTION

desc V$CONTROLFILE_RECORD_SECTION

select * from V$CONTROLFILE_RECORD_SECTION;

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID

---------------------------- ----------- ------------- ------------ ----------- ---------- ----------

DATABASE 316 1 1 0 0 0

CKPT PROGRESS 8180 11 0 0 0 0

REDO THREAD 256 8 1 0 0 0

REDO LOG 72 16 8 0 0 8

DATAFILE 428 100 16 0 0 1352

FILENAME 524 2298 159 0 0 0

TABLESPACE 68 100 13 0 0 9

TEMPORARY FILENAME 56 100 1 0 0 1

RMAN CONFIGURATION 1108 50 1 0 0 1

LOG HISTORY 56 2920 456 1 456 456

OFFLINE RANGE 200 163 0 0 0 0

ARCHIVED LOG 584 56 40 30 13 41

BACKUP SET 40 409 1 1 1 1

BACKUP PIECE 736 200 2 1 2 2

BACKUP DATAFILE 116 282 0 0 0 0

BACKUP REDOLOG 76 215 13 1 13 13

DATAFILE COPY 660 223 0 0 0 0

BACKUP CORRUPTION 44 371 0 0 0 0

COPY CORRUPTION 40 409 0 0 0 0

DELETED OBJECT 20 818 17 1 17 17

PROXY COPY 852 249 0 0 0 0

BACKUP SPFILE 36 454 0 0 0 0

DATABASE INCARNATION 56 292 2 1 2 2

FLASHBACK LOG 84 2048 134 0 0 0

RECOVERY DESTINATION 180 1 1 0 0 0

INSTANCE SPACE RESERVATION 28 1055 1 0 0 0

REMOVABLE RECOVERY FILES 32 1000 0 0 0 0

RMAN STATUS 116 141 16 1 16 16

THREAD INSTANCE NAME MAPPING 80 8 8 0 0 0

MTTR 100 8 1 0 0 0

DATAFILE HISTORY 568 57 0 0 0 0

STANDBY DATABASE MATRIX 400 10 10 0 0 0

GUARANTEED RESTORE POINT 212 2048 0 0 0 0

RESTORE POINT 212 2083 0 0 0 0

发现没有找到表示section 11的字段

于是找V$CONTROLFILE_RECORD_SECTION的基表看看

explain plan for select * from V$CONTROLFILE_RECORD_SECTION;

select * from table(dbms_xplan.display);

找到基表发现无法与V$CONTROLFILE_RECORD_SECTION的字段对应，决定查看V$CONTROLFILE_RECORD_SECTION视图的定义

select VIEW_DEFINITION from v$fixed_view_definition where view_name like upper('%CONTROL%RECORD%');

果然发现：

select inst_id,decode(indx,0,'DATABASE',1, 'CKPT PROGRESS', 2, 'REDO THREAD',3,'REDO LOG',4,'DATAFILE',5,'FILENAME',6,'T

ABLESPACE',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 COR

RUPTION',19,'DELETED OBJECT',20,'PROXY COPY',21,'BACKUP SPFILE',23,'DATABASE INCARNATION',24,'FLASHBACK LOG',25, 'RECOVE

RY DESTINATION', 26,'INSTANCE SPACE RESERVATION', 27, 'REMOVABLE RECOVERY FILES', 28, 'RMAN STATUS', 29, 'THREAD INSTANC

E NAME MAPPING', 30, 'MTTR', 31, 'DATAFILE HISTORY', 32, 'STANDBY DATABASE MATRIX', 33, 'GUARANTEED RESTORE POINT', 34,

'RESTORE POINT', 'UNKNOWN'),rsrsz,rsnum,rsnus,rsiol,rsilw,rsrlw from x$kccrs where indx not in (22)

select TYPE , RECORD_SIZE , RECORDS_TOTAL , RECORDS_USED , FIRST_INDEX , LAST_INDEX , LAST_RECID from GV$CONTROLFILE_RE

CORD_SECTION where inst_id = USERENV('Instance')

[@more@]

ITPub博客

控制文件扩展问题

最新文章