Shulou(Shulou.com)06/01 Report--

SYS@hyyk > select table_name from dict where table_name like'% CONTROL%'

TABLE_NAME-DBA_HIST_WR_CONTROL DBA_REPRESOL_STATS_CONTROL USER_REPRESOL_STATS_CONTROL ALL_REPRESOL_STATS_CONTROL V$BACKUP_CONTROLFILE_DETAILS V$BACKUP_CONTROLFILE_SUMMARY V$CONTROLFILE V$CONTROLFILE_RECORD_SECTION V$SESSION_FIX_CONTROL V$SYSTEM_FIX_CONTROL V$DLM_TRAFFIC_CONTROLLER GV$CONTROLFILE GV$CONTROLFILE_RECORD_SECTION GV$DLM_TRAFFIC_CONTROLLER V$DIAG_ADR_CONTROL

SYS@hyyk > select * from V$CONTROLFILE_RECORD_SECTION

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID DATABASE 316 110 00 CKPT PROGRESS 8180 110 00 0 REDO THREAD 256 81 00 0 REDOLOG 72 163 00 3 DATAFILE 520 100 80 0 72 FILENAME 524 2298 12 00 0 TABLESPACE 68 100 9 00 5 TEMPORARY FILENAME 56 100 100 1 RMAN CONFIGURATION 1108 50 00 00 LOG HISTORY 56 292 62 1 62 62 OFFLINE RANGE 200 163 21 22 ARCHIVED LOG 584 56 40 1 40 40 BACKUP SET 40 409 31 3 3 BACKUP PIECE 736 200 31 3 3 BACKUP DATAFILE 200 245 7 1 7 7 BACKUP REDOLOG 76 215 000 0 DATAFILE COPY 736 200 11 11 BACKUP CORRUPTION 44 371 000 0 COPY CORRUPTION 40 409 000 0 DELETED OBJECT 20 818 11 11 PROXY COPY 928 246 000 0 BACKUP SPFILE 124 131 2 12 2 DATABASE INCARNATION 56 292 2 12 2 FLASHBACK LOG 84 2048 000 0 RECOVERY DESTINATION 80 11 000 INSTANCE SPACE RESERVATION 28 1055 1000 REMOVABLE RECOVERY FILES 32 1000 1000 RMAN STATUS 116 141 71 7 7 THREAD INSTANCE NAME MAPPING 0 8 80 00 MTTR 100 81 000 DATAFILE HISTORY 568 57 00 00 STANDBY DATABASE MATRIX 400 31 31 00 0 GUARANTEED RESTORE POINT 212 2048 00 00 RESTORE POINT 212 2083 00 00 DATABASE BLOCK CORRUPTION 80 8384 00 00 ACM OPERATION 104 64 60 00 FOREIGN ARCHIVED LOG 604 1002 00 00

Record size, which indicates the size of this part of the content in controlfile, in byte.

Then let's observe it through controlfile dump, as follows:

Dump controlfile header

SQL > oradebug setmypid Statement processed. SQL > ALTER SESSION SET EVENTS 'immediate trace name controlf level 1'

Session altered.

SQL > oradebug close_trace Statement processed. SQL > oradebug tracefile_name / home/ora10g/admin/roger/udump/roger_ora_8303.trc

Description: level 1-- dump controlfile header level 2-- level 1+datafile file header information level 3-- level 2 + reusable information level 10-- level 3 + all other information

* * LOG FILE RECORDS * * * * (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) it is known that this part of redo log occupies 72 byte in controlfile.

* * 2018-02-22 13 4293=0x10c5 21V 25.972 DUMP OF CONTROL FILES, Seq # 4293=0x10c5 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=2117284640=0x7e333320, Db Name='HYYK' Activation ID=0=0x0 Control Seq=4293=0x10c5, File size=596=0x254 File Number=0, Blksiz=16384, File Type=1 CONTROL

Compatibility Vsn: indicates the specific version number 0xb200000 after conversion and indicates 100205 DB ID: represents the db id number of the database Db Name: indicates the database name of the database Activation: there is no practical significance here Control Seq: represents the sequence number of control. File size: indicates the file size, but here it is block (conrolfile block) File Number: inside oracle, the file number that defines controlfile is 0. 0. Blksize: indicates the size of the controlfile block. File Type: indicates the file type.

Now that you know what the various parts of controlfile header mean, in some cases of controlfile corruption, you can even fix the controlfile manually to solve the problem. In addition to dump controlfile, we can also use the operating system command dd+od to observe, as follows:

[oracle@pc6 ~] $dd if=/u01/app/oracle/oradata/hyyk/control01.ctl bs=16384 count=1 | od-x | head-20 recorded 1x0 read in and 1x0 write out 16384 bytes (16 kB) copied 0000000 c200 0000 0000 ffc0 0000 0000 0000 0000000020 f832 0000 4000 0000 0254 0000 7c7d 7a7b 0000040 81a0 0000 0000 0000 00000 0000 0000 0000 0.0256473 seconds, 639 kB/ seconds

This dump is the information of os block.

[oracle@pc6 ~] $dd if=/u01/app/oracle/oradata/hyyk/control01.ctl bs=16384 count=2 | od-x | head-0000000 c200 0000 0000 ffc0 0000 0000 0000 0000020 fba4 0000 4000 0000 01c2 0000 7c7d 7a7b-33184 0000040 81a0 0000 0000 0000 0000060 0000 0000 0000 * 0040000 c215 0000 0001 0000 0000 0000 04020 ee77 000000000500 0a20 4d29 930a 0040040 4f52 45470050000000 26f4 0000 01c2 0000000060400000 000000000000 0000 0000 0000000000000000000033033033732303033 0000 0000 0000 0040140 fb8d 95ed d25b 3008 733f 0069 0000 0000 0040160 6204 305b 0000 0000 0000 0040200 0000 0000 0000 * 0040400 0000 0000 0000 00404 0000 0000 0000 0040440 0001 0000 0000 0000 0000000 0000 0000 0000000 0000 0100000 The converted value of 1944000 means controlfile block size. (16384 after conversion to decimal) 01c2 represents the file size in block, and 450 after conversion to decimal. 7c7d 7a7b represents the magic number number of the operating system platform, and each operating system may have a different number.

C215 is the header information, this does not need to pay attention to 0001 means file type. 0500 0a20 means database version number 4d29 930a means DB ID number 4f52 4547 0052 represents DB Name, as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.