data block address2016-06-23 20:01:43这里讨论的不是数据库管理员DBA，而是数据块地址DBA:Data Block Address！ A Data Block Address (DBA) is the address of an Oracle data block for access purposes. ----源自《Oracle内核技术揭秘》的探索 DBA的...
这里讨论的不是数据库管理员DBA，而是数据块地址DBA:Data Block Address！ A Data Block Address (DBA) is the address of an Oracle data block for access purposes. ----源自《Oracle内核技术揭秘》的探索 DBA的结构：8以后，DBA中，前10个二进制位是文件号，后面的就是块号了。 DBA的转换：dump出来文件之后，有的DBA后面有转换后的结果，比如： rdba: 0x010001c8 (4/456)；有的DBA却没有转换后的结果，比如记录高水位的DBA： HWM Flag: HWM Set Highwater:: 0x010001d0 ext#: 0 blk#: 8 ext size: 8 以例子中的DBA为例，转换：
一个DBA转换的例子：转自：http://www.orafaq.com/wiki/Data_block_address Find the DBA for a given rowStart by getting the file and block number of the row. Example: SQL> SELECT 2 dbms_rowid.rowid_relative_fno(rowid) REL_FNO, 3 dbms_rowid.rowid_block_number(rowid) BLOCKNO, 4 empno, ename 5 FROM emp WHERE empno = 7369; REL_FNO BLOCKNO EMPNO ENAME ---------- ---------- ---------- ---------- 4 20 7369 SMITH Now, convert the file and block numbers to a DBA address: SQL> variable dba varchar2(30) SQL> exec :dba := dbms_utility.make_data_block_address(4, 20); PL/SQL procedure successfully completed. SQL> print dba DBA -------------------------------- 16777236 Convert a DBA back to file and block numbersExample: SQL> SELECT dbms_utility.data_block_address_block(16777236) "BLOCK", 2 dbms_utility.data_block_address_file(16777236) "FILE" 3 FROM dual; BLOCK FILE ---------- ---------- 20 4 不过，使用dbms_utility包搞出来的DBA与dump出来的DBA不相同，dump出来的DBA，可以使用转换二进制的方<span><span>式计算出来（上面给出了例子），但是dbms_utility计算出来的DBA，使用转换二进制的方式，算出来的明显不正确。</span></span>
honeywell Custom Algorithm Block and Custom Data Block User Guide.pdf2019-10-22 18:48:18honeywell Custom Algorithm Block and Custom Data Block User Guidepdf,honeywell Custom Algorithm Block and Custom Data Block User Guide
Data Block Dump2013-12-28 22:32:26Data Block Dump
Data Block Dump
A data block dump shows detailed information of the contents of the block for the given datafile number and the block number. It shows you exactly how the data is stored internally. Depending on whether it is a table or index segment, the data block will list the contents of rows or index keys. The segment header block dump will list the extent map information. The undo header block dump will list the free extent pool in the undo segments. You may need to dump the contents of the data block when investigating block corruptions. In addition, complex recovery situations also warrant block dumps to check the SCN of the block.dump出数据块的内容，里面的内容有可能不同，取决于是表段还是索引段，可能会dump出rows或是index keys。对于undo段头的块，我们可以列出free的extent pool。我们调查data block corruptions就可以通过dump数据块，在做复杂的recovery时也可以通过dump数据块来得知数据块的SCN号。
The following methods dump the contents of the interested data blocks to the trace file in the UDUMP directory. Data block dumps contain the actual data stored in the blocks.
If your database instance has the hidden parameter _TRACE_FILES_PUBLIC set to TRUE, please remember that the trace file data can be viewed by anyone with access to your database server machine. It will compromise data security and confidentiality.
alter system dump datafile <file#> block <block#>;--提供file#与block#
alter system dump datafile <file#> block min <min_block#> block max <max_block#>;--dump出邻居的块
select file_id, block_id, blocks from dba_extents where segment_name = ‘TEST’; FILE_ID BLOCK_ID BLOCKS ---------- ---------- ---------- 1 29081 8
REM ---- To dump the segment header block alter system dump datafile 1 block 29081; REM ---- To dump the data block next to the segment header alter system dump datafile 1 block 29082 REM ---- To dump both the blocks at the same time alter system dump datafile 1 block min 29081 block max 29082;
OS data block size2014-03-20 15:09:14OS data block size 分类： System技术积累 2006-01-08 20:56 391人阅读 评论(0) 收藏 举报 osbytesolaris磁盘emcaix AS400的data block size 是520byte （即磁盘要低格为520byte的数据块） ，而且AS400很怪，...
如何阅读oracle数据块data block dump文件2017-07-28 17:51:35Dumping Oracle Blocks Brian Peasland, Raytheon at EROS Data Center Introduction ...In a few cases, it is desirable to dump the contents of an Oracle data block. These blocks may comprise
Dumping Oracle Blocks
Brian Peasland, Raytheon at EROS Data Center
In a few cases, it is desirable to dump the contents of an Oracle data block. These blocks may comprise a table, an index, or even the control file. While we can query the contents of a table, we may want to see what is happening to a particular block of that table. We might want to see not only the data in the block that any query can return, but also see what’s going on behind the scenes in the block. This paper will show you how to dump the contents of a block in a table, index and control file. This paper will also show you how to interpret some of the results of these dumps.
Why Dump Blocks?
So why are we doing this? For the most part, it is just idle curiosity. DBAs are inquisitive folks by nature. Oracle Corp. has released just enough information on database internals to tantalize us without giving away all the secrets. And we’d like to see what’s going on behind the scenes. So for most cases, we are dumping blocks just for fun. In other cases, we are dumping blocks to actually find out some meaningful information. But in the end, it is up to you.
Trace File Information
All of the examples in this paper will generate trace files. Those trace files will be present in USER_DUMP_DEST for you to view. To determine the trace file generated, use a query similar to the following:
ORA9I SQL> select pa.value || '/' || i.instance_name || '_ora_' 2 || pr.spid || '.trc' as trace_file 3 from v$session s, v$process pr, v$parameter pa, v$instance i 4 where s.username = user and s.paddr = pr.addr 5* and pa.name='user_dump_dest'; TRACE_FILE ------------------------------------------------------------------------ /edcsns14/pkg/oracle/admin/ora9i/udump/ora9i_ora_25199.trc
This query shows the full path and filename of the generated trace file for my session. This is the text file we look in to see the results of our dump.
All trace files contain the same basic information at the beginning of the file.
Oracle9i Enterprise Edition Release 220.127.116.11.0 - Production With the Partitioning option JServer Release 18.104.22.168.0 - Production ORACLE_HOME = /edcsns14/pkg/oracle/9.0.1 System name: SunOS Node name: edcsns14 Release: 5.7 Version: Generic_106541-11 Machine: sun4u Instance name: ora9i Redo thread mounted by this instance: 1 Oracle process number: 11 Unix process pid: 653, image: oracle@edcsns14 (TNS V1-V3) *** 2002-03-27 17:06:06.573 *** SESSION ID:(12.4240) 2002-03-27 17:06:06.535
Output similar to above is shown in each trace file. This output shows the database version, some platform specific information such as host name and OS level, the database instance name, the processes identifiers (Oracle and Unix) for the session that generated the trace file, and the date and time the file was generated. We’ll skip this introductory information in examining our trace files.
Dumping A Table Block
To dump a block belonging to a table, you’ll need to know the file number and block number of that block. If you already know the file number and block, then you are all set. But for our example, we’ll want to figure that out.
ORA9I SQL> select file_id,block_id,bytes,blocks 2 from dba_extents 3 where owner='PEASLAND' and segment_name='EMP'; FILE_ID BLOCK_ID BYTES BLOCKS ------- ---------- ---------------- -------- 3 9 65,536 8
Here, I’ve queried the data dictionary to find out which file my EMP table resides in. The EMP table is in file# 3, starting at block# 9, and is eight blocks long. This query will return one row for each extent of the object. So this object is comprised of only one extent. We can verify which tablespace file# 3 belongs to with the following query:
ORA9I SQL> select tablespace_name,file_name from dba_data_files 2 where relative_fno = 3; TABLESPACE_NAME FILE_NAME ------------------------------ ----------------------------------------- USER_DATA /edcsns14/oradata3/ora9i/user_data01.dbf
As I had expected, my table is in the USER_DATA tablespace.
Now that we know which file and blocks hold our table, let’s dump a sample block of the table. This is done as follows:
ORA9I SQL> alter system dump datafile 3 block 10; System altered. You can dump a range of blocks with the following command: ORA9I SQL> alter system dump datafile 3 block min 10 block max 12; System altered.
Let’s now look at the contents of dumping one block.
Start dump data blocks tsn: 3 file#: 3 minblk 10 maxblk 10 buffer tsn: 3 rdba: 0x00c0000a (3/10) scn: 0x0000.00046911 seq: 0x02 flg: 0x04 tail: 0x69110602 frmt: 0x02 chkval: 0x579d type: 0x06=trans data Block header dump: 0x00c0000a Object id on Block? Y seg/obj: 0x6d9c csc: 0x00.46911 itc: 2 flg: O typ: 1 - DATA fsl: 0 fnx: 0x0 ver: 0x01 Itl Xid Uba Flag Lck Scn/Fsc 0x01 xid: 0x0005.02f.0000010c uba: 0x00806f10.00ca.28 C--- 0 scn 0x0000.00046900 0x02 xid: 0x0003.01c.00000101 uba: 0x00800033.0099.04 C--- 0 scn 0x0000.00046906
This is the beginning of the data block dump. The first line tells us that we are dumping file#3, starting at block# 10 (minblk), and finishing with block# 10 (maxblk). Had we dumped more than one data block, these values would represent a range. The relative data block address (rdba) is 0x00c0000a. For more information on the rdba, refer to a later section in this paper. At the end of this line, we can see in parentheses that the rdba corresponds to file# 3, block# 10 (3/10).
The third line describes the SCN of the data block. In our case, the SCN is 0x0000.00046911. The tail of the data block is composed of the last two bytes of the SCN (6911) appended with the type (06) and the sequence (02). If the decomposition of the tail does not match these three values, then the system knows that the block is inconsistent and needs to be recovered. While this tail value shows up at the beginning of the block dump, it is physically stored at the end of the data block.
The block type shows up on the fourth line. Some of the valid types correspond to the following table:
Type Meaning 0x02 undo block 0x06 table or index data block 0x0e undo segment header 0x10 data segment header block 0x17 bitmapped data segment header
The “Object id on Block?” line tells us whether or not this object is in SYS.OBJ$. Since Oracle 6, this should always be “Y”. If you look at the next line, the seg/obj value tells us the segment’s object id (in hex). In our example, this is 0x6d9c. Hex ‘6D9C’ is ‘28060’ in decimal. We can verify that this is our table with the following query:
ORA9I SQL> select owner,object_name from dba_objects 2 where object_id=28060; OWNER OBJECT_NAME ---------- ------------------------------ PEASLAND EMP
As we had hoped, this is our table.
The csc value is the Cleanout System Change number. This value tells us when block cleanout was performed on this block. Hopefully, it matches the SCN of the data block. The itc value is the Interested Transaction List Count. In our case, there are two transactions interested in this block. Those interested transactions appear at the end of our example. We can see the transaction id (Xid) of those two transactions. Those transaction ids correspond to rollback segments that are used to process our transactions.
The flag (flg) is either “-” or “O”, used to indicate if this block is on a freelist. If the block is on a freelist, the flag will be “0”. If it is not on a freelist, then the flag will be “-”. Our block in question is on the freelist.
Well, that was quite a lot of information and we haven’t really looked at too much of the dump. Let’s look at the next section of the data block dump.
data_block_dump =============== tsiz: 0x1fa0 hsiz: 0x2e pbl: 0x024d015c bdba: 0x00c0000a flag=------------- ntab=1 nrow=14 frre=9 fsbo=0x2e fseo=0x1b18 avsp=0x1d8a tosp=0x1d8a 0xe:pti nrow=14 offs=0 0x12:pri offs=0x1c30 0x14:pri offs=0x1f4f 0x16:pri offs=0x1f24 0x18:pri offs=0x1efb 0x1a:pri offs=0x1ece 0x1c:pri offs=0x1ea5 0x1e:pri offs=0x1e7c 0x20:pri offs=0x1e54 0x22:pri offs=0x1e2e 0x24:pri sfll=13 0x26:pri offs=0x1ca4 0x28:pri offs=0x1cf1 0x2a:pri offs=0x1b18 0x2c:pri sfll=-1
The tsiz value shows us the amount of available room in the block for data. Here, we get ‘1fa0’ which translates to 8,096 bytes of useable room. The rest of our 8,192 byte block is used for overhead such as the block header.
The ntab value shows us how many tables are stored in this block. Unless this block belongs to a cluster, this value will be ‘1’. The nrow value tells us how many rows of data are stored in this block. Our data block has 14 rows of data.
Starting at address ‘0xe’, we get a directory to each row. We can see that the first row (index entry zero) starts at offset address to the block ‘0x1c30’. Each of the blocks rows follows from here. This way, a row can be found really quickly. Remember that a ROWID is basically a pointer to a unique row. In Oracle 8+, the ROWID is of the form O.F.B.R (or objectno,relativefno,blockno,rowno). So when the system quickly points to a particular block in a particular file, the row number points to a slot in this directory. The directory then points to a specific location in the block. This is the start of that row.
Now that we have a roadmap to our data block, let’s look at the remainder of the trace file to see the actual rows of data in the block.
block_row_dump: tab 0, row 0, @0x1c30 tl: 39 fb: --H-FL-- lb: 0x0 cc: 8 col 0: [ 3] c2 4a 46 col 1: [ 5] 53 4d 49 54 48 col 2: [ 5] 43 4c 45 52 4b col 3: [ 3] c2 50 03 col 4: [ 7] 77 b4 0c 11 01 01 01 col 5: [ 3] c2 09 19 col 6: *NULL* col 7: [ 2] c1 15
The actual row data starts with the phrase “block_row_dump:”. Then a row of data is given. I’ve only shown one row of data here, as the rest is similar. We can see that this row belongs to table ‘0’ (tab) of our cluster. Since there is no cluster in our example, we do not have more than one table so this value will be zero. We can also see that this is row ‘0’ and the address of that row is given. This address should correspond to our roadmap noted above.
The ‘tl’ value gives us the total number of bytes for this row, including any overhead. We can see that this row occupies 39 bytes. The ‘cc’ value gives us a column count. We have eight columns in this row. This can easily be verified by doing a DESCRIBE on the table and counting the columns, or by querying USER_TAB_COLUMNS.
The ‘fb’ value gives us flags about the row. ‘H’ means that we have the head of the row. ‘F’ means that we have the first piece of the row. ‘L’ means we also have the last piece of the row. Since this is the first and last piece of the row, the row is not chained. Since this is also the head of the row, the row has not been migrated.
The rest of the information for the row is the data for each column. For instance, in column 1, we have the following ASCII character codes, “53 4d 49 54 48”. A quick look at an ASCII conversion chart will tell us that these characters are “SMITH”. If you are familiar with the sample EMP table, you will know that SMITH is one of our employees. Notice that column 6 is NULL. Column 4 is the HIREDATE column. This is a DATE datatype. From this block, you can easily verify that the DATE datatype requires seven bytes of storage. Column 0 contains a number. The three bytes here are the representation of that number.
Dumping The Extent Header
In the previous section, we dump a block in the middle of the table. The first block in the segment contains some interesting information as well. If you recall, our EMP table was in file#3, starting at block# 9. We previously dumped a block in the middle of the table. Let’s now dump the first block of this table.
ORA9I SQL> alter system dump datafile 3 block 9;
We will now look at the contents of our trace file.
Start dump data blocks tsn: 3 file#: 3 minblk 9 maxblk 9 buffer tsn: 3 rdba: 0x00c00009 (3/9) scn: 0x0000.000467ee seq: 0x01 flg: 0x04 tail: 0x67ee1001 frmt: 0x02 chkval: 0x3d71 type: 0x10=DATA SEGMENT HEADER - UNLIMITED Extent Control Header ----------------------------------------------------------------- Extent Header:: spare1: 0 spare2: 0 #extents: 1 #blocks: 7 last map 0x00000000 #maps: 0 offset: 4128 Highwater:: 0x00c0000b ext#: 0 blk#: 1 ext size: 7 #blocks in seg. hdr's freelists: 1 #blocks below: 1 mapblk 0x00000000 offset: 0 Unlocked Map Header:: next 0x00000000 #extents: 1 obj#: 28060 flag: 0x40000000 Extent Map ----------------------------------------------------------------- 0x00c0000a length: 7
We’ve already seen the first four lines in the previous section. One thing to notice is that the type is 0x10 for a data segment header. After this, things look a little different. We are now given information about this particular extent. We can see that this particular segment is comprised of only one extent (#extents) and that it has seven data blocks (#blocks). If you remember from the previous section, this segment is really composed of eight blocks. But the first block is for the segment header, so it is not counted here.
From this segment header, we can get information about the High Watermark (HWM). If we look at the line starting with ‘Highwater::’, we can see that the HWM is in rdba 0x00c0000b. This is in the 0th extent of our segment (ext#), in the 1st block (blk#). Remember that we count from zero so the HWM is really in the first extent, second block. Additionally, two lines below this one, we can see that there is only 1 block below the HWM (#blocks below). We can also see that there is only one block on the segment header freelist (#blocks in seg. hdr’s freelists). Let’s look at a more complex example from a table that is using more than one block.
Extent Header:: spare1: 0 spare2: 0 #extents: 48 #blocks: 383 last map 0x00000000 #maps: 0 offset: 4128 Highwater:: 0x00c01d8c ext#: 47 blk#: 3 ext size: 8 #blocks in seg. hdr's freelists: 0 #blocks below: 378
Here, we can see a much bigger table. From this information, we can tell that the table is made of 48 extents, totaling 383 blocks. The HWM is in the 47th extent in block 3. There are 378 blocks below the HWM. This means that we have five blocks above the HWM. Before the DBMS_SPACE package became available, this method of dumping the segment header was the only way to get information on the HWM. Now that the DBMS_SPACE package is available, this method has become basically obsolete. But it is still an interesting exercise.
Dumping An Index
For this section of the paper, we are only concerning ourselves with B-tree indexes. This section does not cover dumping blocks of bitmap indexes or IOTs.
The data blocks that make up an index are different than table data blocks. A B-tree index has branch blocks and leaf blocks. We will first perform a tree dump of the entire B-tree index. We will examine various blocks of this tree dump. To start the tree dump, we need to know the OBJECT_ID of the index. This is done with a simple SQL statement:
ORA9I SQL> select object_id from user_objects
2 where object_name='DB_OBJ_OBJID_IDX';
We now have the OBJECT_ID of our index. Let’s generate a dump of this index.
ORA9I SQL> alter session set events 'immediate trace name treedump level 28046';
With the ALTER SESSION SET EVENTS command above, we have forced the system to generate a tree dump of the B-tree index. Note that the level number is the OBJECT_ID of the index in question. We have now generated a trace file that we can read to get detailed information of our B-tree index. Let’s examine the trace file a section at a time to understand its contents.
----- begin tree dump
branch: 0xc01d92 12590482 (0: nrow: 9, level: 2)
branch: 0xc01ed7 12590807 (-1: nrow: 323, level: 1)
leaf: 0xc01d93 12590483 (-1: nrow: 42 rrow: 42)
This is the beginning of our tree dump. The first branch block is the root of the tree. In our example, this block is hex address c01d92, which translates to decimal address 12590482. These addresses help us traverse from block to block. Notice that the level of this root block is level 2. If you start counting at zero, then it should be obvious that this index B-tree has a height of three.
Below the root block is another branch block at address 0xc01ed7. You can verify that this block is one below the root by looking at the level of this block, in this case, ‘1’. The next line shows us the first leaf block of the B-tree index. Leaf blocks are always at level 0 so there is no need to put that information in the dump. What follows next is a dump of that leaf block.
Leaf block dump =============== header address 2349359196=0x8c08605c kdxcolev 0 KDXCOLEV Flags = - - - kdxcolok 0 kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y kdxconco 4 kdxcosdc 0 kdxconro 42 kdxcofbo 120=0x78 kdxcofeo 7080=0x1ba8 kdxcoavs 6960 kdxlespl 0 kdxlende 0 kdxlenxt 12590484=0xc01d94 kdxleprv 0=0x0 kdxledsz 0 kdxlebksz 8032
Of interest here is the kdxlenxt and kdxleprv values. These denote the addresses of the next leaf block and previous leaf block respectively. These pointers are important for INDEX RANGE SCANS of data. The next leaf block is at address 0xc01d94 while the previous leaf block is address 0x0. This block is the first leaf block looking at the tree from left to right. Therefore, there is no previous leaf block. The address 0x0 signifies no previous block. Likewise, the rightmost leaf block will have no next leaf block and will have this dummy address. Continuing with the leaf block dump is the data in the leaf block.
row#0 flag: -----, lock: 0 col 0; len 2; (2): c1 03 col 1; len 6; (6): 43 5f 4f 42 4a 23 col 2; len 3; (3): 53 59 53 col 3; len 6; (6): 00 c0 1c 4a 00 9b row#1 flag: -----, lock: 0 col 0; len 2; (2): c1 03 col 1; len 6; (6): 43 5f 4f 42 4a 23 col 2; len 3; (3): 53 59 53 col 3; len 6; (6): 00 c0 1d 07 00 9b
I’ve only included the first two rows of data in the leaf block. You can see that (counting from zero) these are the first two rows. If you page through the dump file, you’ll see each and every row in the leaf block. There are many more leaf blocks, but they look very similar.
Of particular interest are the three columns for each row. This index is a composite index on three columns of the table. The index columns are listed in order. You can see the hexadecimal values of the ASCII codes for the data in those columns. This is where you can see the actual data stored in the leaf rows. Unfortunately, you’ll have to convert these ASCII codes by hand.
After this leaf block, the rest of the leaf block dumps off that first branch block are shown. With many, many leaf blocks per branch block, it can generate quite a lengthy dump file. If you page forward far enough, you’ll see the end of the leaf block dump and the start of the next branch block.
----- end of leaf block dump -----
branch: 0xc01fef 12591087 (0: nrow: 279, level: 1)
leaf: 0xc01ed6 12590806 (-1: nrow: 25 rrow: 25)
Here is the start of the second branch block off the root node. I know that this branch block is one off the root block since its level is one less. How do I know that this branch block is the second branch block from left to right? Look at the first number inside the parentheses. For this block, that number is ‘0’. The leftmost branch block is ‘-1’. You can go back in this paper to verify this is true for the first branch block. Then start counting forward. So ‘0’ is really the second branch block.
Why start counting at ‘-1’ when normally we start counting at ‘0’? It all has to do with how keys are stored in the branch blocks. The first key is not stored because it is assumed to be less than the second key. Since the second key is started at ‘0’ this means the first branch is one less than zero.
Let’s look at one more piece of information. The NROW indicator shows the number of rows in that block. For leaf blocks, this is the number of table rows pointed to by that leaf block. For branch blocks, this is the number of blocks underneath that branch block in the tree. Leaf blocks also contain the RROW indicator. RROW is the number of rows after all current transactions have been committed. In our examples, these two indicators are the same since there are no active transactions against that data.
In our previous work, we saw some block addresses (often called the rdba). For instance, we saw the following when dumping a leaf block:
----- begin tree dump
branch: 0xc01d92 12590482 (0: nrow: 9, level: 2)
We know the hexadecimal and decimal equivalent of this block address. How can we determine where this is in the Oracle database? We’ll have to use the DBMS_UTILITY package to do that. We’ll use a procedure in this package to convert the decimal Data Block Address (DBA) to our familiar file number, block number.
ORA9I SQL> select dbms_utility.data_block_address_file(12590482) as file#,
2 dbms_utility.data_block_address_block(12590482) as block from dual;
Here, we can see that this branch block belongs to datafile 3, block number 7570. Quick queries on the data dictionary can reveal exactly which object this belongs to, but we already know that.
Control File Dumps
This section will take you beyond the simple BACKUP CONTROL FILE TO TRACE. If you have never viewed a control file backup to trace, I suggest you start there first. Most of the information in the control files is accessible from various V$ views. Those V$ views, in effect, just query the control file by accessing X$ tables whose sole purpose is to peek into the current contents of the control file. What is presented here is just a fun, interesting way to see the same information.
ORA9I SQL> alter session set events 'immediate trace name controlf level 1';
Here, we generated a dump of the control file, level 1. A level 1 dump of the control file dumps only the control file header. Let’s take a look at the information in the control file header.
DUMP OF CONTROL FILES, Seq # 1602 = 0x642 FILE HEADER: Software vsn=150994944=0x9000000, Compatibility Vsn=134217728=0x8000000 Db Id=2254477402=0x8660985a, Db Name='ORA9I' Control Seq=1602=0x642, File size=194=0xc2 File Number=0, Blksiz=8192, File Type=1 CONTROL *** END OF DUMP ***
That’s all there is to it! It is just a few short lines. From this dump, we can see interesting information such as the unique database identifier (2254477402), the database name (ORA9I), and the database block size (8192).
A level 2 dump shows the file header, the database info record, and the checkpoint progress record. We’ve already seen the file header, so let’s look at the database info record.
************************************************************************ DATABASE ENTRY ************************************************************************ (blkno = 0x1, size = 192, max = 1, in-use = 1, last-recid= 0) DF Version: creation=0x9000000 compatible=0x8000000, Date 02/26/2002 13:43:54 DB Name "ORA9I" Database flags = 0x00404000 Controlfile Creation Timestamp 02/26/2002 13:43:55 Incmplt recovery scn: 0x0000.00000000 Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 02/26/2002 13:43:54 Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00 Redo Version: creation=0x9000000 compatable=0x9000000 #Data files = 4, #Online files = 4 Database checkpoint: Thread=1 scn: 0x0000.0005f8d8 Threads: #Enabled=1, #Open=1, Head=1, Tail=1 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Max log members = 5, Max data members = 1 Arch list: Head=0, Tail=0, Force scn: 0x0000.0005eae3scn: 0x0000.00000000 Controlfile Checkpointed at scn: 0x0000.0005fa9b 03/27/2002 15:11:39 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
There is a lot of information here. From here, we can again see that the database and control files were initially created on 02/26/2002 13:43. We can see that the last time the database was opened with the RESETLOGS option was at the time the database was created. Further down, we can see that we have four datafiles and that all four datafiles are online. Furthermore, we can see that we can have a maximum of five log file members. The control file was last checkpointed at SCN 0x0000.0005fa9b, at time 03/27/2002 15:11:39.
A level 3 dump also includes information on all records, including data files, log files, tempfiles, and tablespaces. We’ll look at a few of these examples.
*************************************************************************** LOG FILE RECORDS *************************************************************************** (blkno = 0x5, size = 72, max = 5, in-use = 3, last-recid= 3) LOG FILE #1: (name #1) /edcsns14/oradata3/ora9i/redo01.log Thread 1 redo log links: forward: 2 backward: 0 siz: 0x2800 seq: 0x00000202 hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0005f1fc Low scn: 0x0000.0005f8d8 03/27/2002 14:25:58 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 LOG FILE #2: (name #2) /edcsns14/oradata3/ora9i/redo02.log Thread 1 redo log links: forward: 3 backward: 1 siz: 0x2800 seq: 0x00000200 hws: 0x2 bsz: 512 nab: 0x2801 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0005e23e Low scn: 0x0000.0005eae3 03/27/2002 14:24:03 Next scn: 0x0000.0005f1fc 03/27/2002 14:25:01 LOG FILE #3: (name #3) /edcsns14/oradata3/ora9i/redo03.log Thread 1 redo log links: forward: 0 backward: 2 siz: 0x2800 seq: 0x00000201 hws: 0x2 bsz: 512 nab: 0x2801 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0005eae3 Low scn: 0x0000.0005f1fc 03/27/2002 14:25:01 Next scn: 0x0000.0005f8d8 03/27/2002 14:25:58
This section shows us information about the online redo logs. This is how the control file knows about each log file (3 of them in our case). We can also see the low and high SCN of each online redo log file. Notice that in our case, the high SCN for log file #1 is 0xffff.ffffffff. This means that there is now high SCN yet because this is the active online redo log! Similar information is presented for the other sections.
There are more levels to the control file dump. Level 4, shows all of the above information and adds the four most recent records for circular reuse record types. Level 5 adds the same information, but double the most recent records for circular reuse record types. Each additional level doubles it again.
The information found in control file dumps is pretty self-explanatory. So I won’t go into much more detail here. Try dumping a control file and examining the contents yourself.
Hopefully, you’ve had some fun peering down to the internal operations of different files that make up an Oracle database. We’ve seen how to dump table data blocks, indexes, and control files. We’ve also seen how to make sense of some of the information presented to us in our dump. While you may not find many practical uses for these techniques, it is a good exercise.
oracle的datablock的结构2012-03-04 17:09:07先摘录一下官方文档，回头在弄一个dump的内容验证一下。...The Oracle data block format is similar regardless of whether the data block contains table, index, or clustered data. Figure 2-2i
【Oracle Form】Data Block 与 Canvas2014-03-24 08:48:29Data Block 和 Canvas是Form中两个比较重要的概念。 Data Block Data Block是用来定义需要展示的对象的地方。 Form主要作用是用来作为操作数据库的接口，Data Block可以用来映射到数据库的表。 Data Block从...
Torque 3D/DataBlock2009-11-10 14:51:00概述： 从概念上理解，datablock是一个提供了重要的位置存储信息的结构，其他对象可以引用datablock且共享这些信息，典型的例子，一个datablock包含一个美术资源的文件名，当我们要在游戏世界里创建一个平面，我们...
DBA- data block address2009-08-08 11:36:00随手记录一下:http://www.orafaq.com/wiki/Data_block_addressData block addressFrom Oracle FAQA Data Block Address (DBA) is the address of an Oracle data block for access purposes. Find the DBA
数据块（Data Block）原理深入剖析2018-05-02 09:44:27数据块（Data Block）原理深入剖析什么是数据块（Data Block）数据块（Oracle Data Blocks），本文简称为“块”，是Oracle最小的存储单位，Oracle数据存放在“块”中。一个块占用一定的磁盘空间。特别注意的是，这里...
ORA-01578 ORACLE data block corrupted2014-11-25 17:20:05用户连接到数据库执行存储过程时报坏块ORA-01578ORACLE data block corrupted错误
Data Block Address (DBA)各种形式间的转换2014-09-26 11:25:45Data block address Jump to: navigation, search A Data Block Address (DBA) is the address of an Oracle data block for access purposes. Find the DBA for a given row Start by getting the fil
data block的信息2009-05-25 22:16:00数据块中包括的3种头信息： 首先，数据块是通过data block buffer cache完成读和写操作的，所以它提供了20bytes的Cache Header和4bytes的 Tail给Cache，用来读取和管理。第2部分是为Transaction层提供的Header信息。...
偷窥Data block 的物理结构2013-03-23 15:00:581． Data Block 物理结构图： 2． 一次对block的dump过程： SQL> create table t9 (a varchar(10)); Table created. SQL> insert into t9 values('a'); 1 row created. SQL> commit; Commit...
block(data block,directory block)、inode、块位图、inode位图和super block概念详解2016-03-03 14:27:551.block：文件系统中存储数据的最小单元，ext3文件系统中，创建时默认4k，分为存储文件数据的data block和存储目录数据的directory block 2.inode：又称“索引节点”，每一个inode对应一个文件或目录，记录了...
data block corrupted解决方法2010-06-22 16:49:17ORACLE data block corrupted (file # 8, block # 181)data file 6:'*******.dbf' 查了一下，解决办法是： 1、运行select * from dba_extents where file_id=8 and 181 between block_id and block_id+bl...
Oracle Data block 的物理结构2009-10-19 22:52:00对data block物理结构的认识 1.Data Block 物理结构图： 2.一次对block的dump过程： PHP code：SQL> create table t9 (a varchar(10));Table created.SQL> insert into t9 values(a);1 row created
recover tablespace /database出现错误ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data ...2019-06-24 13:37:44ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252 错误原因：重做日志和数据块不一致导致的问题。 问题欢迎过程： 1.首先我对表空间进行了一次备份backuptablespace t1 2.模拟表空间...
Oracle的data block内容研读(转)2013-07-30 11:22:43Oracle的data block内容研读(转) ...DataBlock是Oracle中存储数据块的最小存储单元，由多个os数据块组成。主要由三个逻辑层组成（通过c语言描绘的结构，如下图一所示）：the cache layer，the t
ORA-01578: ORACLE data block corrupted2011-12-12 11:58:15ORA-01578: ORACLE data block corrupted (file # 16, block # 27059) SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS WHERE file_id = 16 AND 27059 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS ...
有关oracle data block的英文解读2006-12-17 15:26:00at the finest of granularity,oracle stores data in data blocks (also called logical blocksOracle blocks,or pages):A data block is the smallest unit of data used by a database one data block corresp
140.Identify two situations in which the block header grows in a data block. (Choose two.)2016-08-04 11:29:56140.Identify two situations in which the block header grows in a data block. (Choose two.)
Identify two situations in which the block header grows in a data block. (Choose two.) 选项 A.when ...2016-01-21 15:48:36Identify two situations in which the blockheader grows in a data block. (Choose two.) 选项 A.when row directories need more row entries B.when there is rowmigration in the data block C.when there is
实际工作中ORA-01578: ORACLE data block corrupted遇到问题的解决方式2017-05-08 14:07:53在实际项目生产环境中，外部的不可抗外部环境影响系统的正常运行往往很难控制，这样我们就需要...ORA-01578: Oracle data block corrupted (file # 5, block #27059) SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME F
每天两道oracle笔试题+第七天：1、简述数据库的data block、extent、segement的区别？2、简述为何要使用...2014-01-22 16:21:331、简述数据库的data block、extent、segement的区别？ 2、简述为何要使用索引？ 问题: 1、答： data block是数据库中最小的逻辑存储单元。当数据库的对象需要更多的物理存储空间时，连续的data block就组成了...
check and recover data block corrupted2013-11-26 23:21:30一、测试手工生成数据文件坏块 ...SQL> create tablespace blocktest datafile '/u01/app/oradata/amber/blocktest01.dbf' size 1m; SQL> select file#,name from v$datafile; FILE# NAME ---------- ----------
Leveldb源码解析第一篇【Data Block】2017-06-09 17:17:41[data block N] [meta block 1] ... [meta block K] [metaindex block] [index block] [Footer] (fixed size; starts at file_size - sizeof(Footer)) < end_of_file > 第一眼看着不明觉厉，这是个...