Oracle tool: DBV usage

Oracle tool: DBV usage 1 defines that oracle Bad blocks can be divided into Physical Bad blocks and logical Bad blocks. Bad block corruption information is similar to: ORA-01578: ORACLE data block corruption upted (file #6, block #11) ORA-01110: data file 6: '/u01/app/oracle/oradata/orcl/tbs01.dbf'
The main purpose of the DBVERIFY tool is to check the physical structure of data files and control files, including whether the data files are damaged, whether logical Bad blocks exist, and what types of data contained in the data files. Whether the database is opened or not, you can access the data file, that is, whether it is online or offline. In Unix systems: $ ORACLE_HOME/bin/dbv. Www.2cto.com
2 Command [SQL] C: \ Users \ Administrator> dbv DBVERIFY: Release 10.2.0.1.0-Production on Thursday September 20 01:24:37 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. www.2cto.com keyword description (default) -------------------------------------------------- FILE to be verified (none) START block (the first block of the FILE) END Block (the last block of the FILE) BLOCKSIZE logical block size (8192) LOGFILE output log (none) FEEDBACK Display progress (0) PARFILE parameter file (none) USERID username/password (none) SEGMENT_ID segment ID (tsn. relfile. block) (none) the highest block SCN to be verified by HIGH_SCN (none) (scn_wrap.scn_base or scn) Note: ① if feedback = 1000, verify that the first block shows one. this symbol ② USERID -- specify ③ FILE when verifying the asm FILE -- specify the data FILE name to be verified ④ BLOCKSIZE -- specify the size of the data FILE. The default value is 8192, for non-8192 blocks, DBV-00103 errors will be received. ⑤ PARFILE -- you can place some options in the parameter file, like using expdp/impdp. ⑥ SEGMENT_ID -- validation segment, requiring tablespace ID, Data File ID, segment header ID 3 limit ① DBV is restricted by version. a later version can automatically identify a lower-version database, for example, a database with 11 Gbit/s dbv access 9i, however, an error is reported when dbv of a lower version accesses a later version. ② Online log files, archived logs, RMAN backup set verification www.2cto.com 4 case (1) [SQL] C: \ Users \ Administrator> dbv file = d: \ oracle \ product \ 10.2.0 \ oradata \ ORCL \ DATAFILE \ O1_MF_USERS_7TQZTYTO_.DBF DBVERIFY: Release 10.2.0.1.0-Production on Thursday September 20 01:04:07 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. DBVERIFY-Start verification: FILE = d: \ oracle \ product \ 10.2.0 \ oradata \ ORCL \ DATAFILE \ O1_MF_USERS_7TQZTYTO_.DBF www.2cto.com DBVERI FY-Total number of pages for verification completion check: 42560 -- total number of pages for verification. One page is the total number of pages processed by a data block (data): 40681 total number of failed pages (data): 0 total number of pages processed (INDEX): 97 total number of failed pages (INDEX): 0 total number of pages processed (other): 592 total number of pages processed (segment ): 0 total number of failed pages (segment): 0 total number of blank pages: 1190 total number of pages marked as damaged: 0 total number of inbound pages: 0 maximum block SCN: 4772756 (0.4772756) we can see that the result of dbverify includes the number of blocks included in the data file, including how many data blocks, how many index blocks, and how many empty blocks, number of blocks marked as bad blocks and number of Bad blocks. Note: If the Total Pages Influx value is greater than zero and no bad blocks exist, it is because the dbv program runs on open files and encounters a data block currently being written by the DBWn process. In the case of www.2cto.com (ii) DBV, the tool is also used when the database is opened to verify the usage of the specified segment [SQL] 01:18:15 sys @ ORCL (^ ω ^) SELECT TABLESPACE_ID, HEADER_FILE, HEADER_BLOCK 01:19:27 2 FROM SYS_DBA_SEGS 01:19:27 3 WHERE SEGMENT_NAME ='s _ EMP '01:19:29 4/TABLESPACE_ID HEADER_FILE HEADER_BLOCK ----------- ------------ 4 4 4 603 C: \ Users \ Administrator> DBV userid = hr/hr segment_id = 4.4.603 DBVERIFY: Release 10.2.0.1.0-Production on Thursday September 20 01:22:04 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. DBVERIFY-Start verification: SEGMENT_ID = 4.4.603 www.2cto.com DBVERIFY-Total number of pages for verification completion check: 8 Total number of pages processed (data): 5 total number of failed pages (data ): total number of pages processed by 0 (INDEX): Total number of failed pages (INDEX): Total number of pages processed by 0 (other): 2 total number of pages processed (segment ): 1 Total number of failed pages (segment): 0 total number of blank pages: 0 total number of pages marked as damaged: 0 total number of inbound pages: 0 maximum block SCN: 4689412 (0.4689412)