Total Pages Marked Corrupt = number of blocks for which the cache header is invalid, thereby making it impossible for DBVERIFY to identify the block type Total Pages Failing (Index) = number of blocks that failed the index block checking routine Total Pages Failing (Data) = number of blocks that failed the data block checking routine Total Pages Processed = number of blocks that were verified (formatted blocks) Total Pages Examined = number of blocks in the file A portion of the resulting output is also shown.ĭBVERIFY - Verification starting : FILE = t_db1.dbf The following is a sample verification of the file t_ feedback parameter has been given the value 100 to display one period (.) for every 100 pages processed. Sample verification for a single data file. This enables you to customize parameter files to handle different types of data files and to perform specific types of integrity checks on data files. You can store various values for DBVERIFY parameters in flat files. Specifies the name of the parameter file to use. If n = 0, then there is no progress display. The default sends output to the terminal display.Ĭauses DBVERIFY to send a progress display to the terminal in the form of a single period (.) for n number of pages verified during the DBVERIFY run. Specifies the file to which logging information should be written. When a value is specified for HIGH_SCN, DBVERIFY writes diagnostic messages for each block whose block-level SCN exceeds the value specified. If the file does not have block size of 2 KB and you do not specify BLOCKSIZE, then you will receive the error DBV-00103. If you do not specify END, then DBVERIFY defaults to the last block in the file.īLOCKSIZE is required only if the file to be verified does not have a block size of 2 KB. If you do not specify START, then DBVERIFY defaults to the first block in the file. Specify block addresses in Oracle blocks (as opposed to operating system blocks). If you do specify this parameter, both a username and a password must be entered otherwise a DBV-00112: USERID incorrectly specified error is returned. This parameter is only necessary when the files being verified are Oracle ASM files.
0 Comments
Leave a Reply. |