Database Utilities (MOSC)

MOSC Banner

Why DBV showed incorrect block numbers

edited Jan 30, 2013 3:45PM in Database Utilities (MOSC) 2 commentsAnswered ✓
I got a interesting case as below :
1.Customer noticed a data file blocks calculation result is incorrect by DBV utility :
$dbv file=rlv_8g_data15 blocksize=8192
DBVERIFY: Release 11.2.0.3.0 - Production on Thu Jan 24 17:35:17 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /dev/rlv_8g_data15
DBVERIFY - Verification complete

Total Pages Examined         : 524288  <<<<====================================half number of the total blocks in the datafile
......

2.In Rman and database dictionary views the info are correct :

RMAN> backup validate check logical datafile 19;
Starting backup at 24-JAN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center