| DBVERIFY problem [message #59889] |
Wed, 31 December 2003 10:33  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
Hi,
After taking backups of datafiles I ran the DBVERIFY utility from command promt to make sure that my backups are valid and consistent.
Following is my command
C:oracleora92bin>dbv.exe file=C:ORACLEORADATAHRDBUSERS02.DBF
I tried on backups too but I keep getting the following message
--------------------------------
DBVERIFY: Release 9.2.0.1.0 - Production on Wed Dec 31 15:30:46 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBV-00103: Specified BLOCKSIZE (2048) differs from actual (8192)
---------------------------------
I created a database using DBCA and did not change any parameters but still I keep getting the same message.
Oracle documentation/ some other website
http://www.remote-dba.cc/teas_aegis_util14.htm
say the output needs to something completely different.
Please help
Thanks
Scott
|
|
|
|
| Re: DBVERIFY problem [message #59892 is a reply to message #59889] |
Thu, 01 January 2004 22:35  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Try: dbv.exe file=C:ORACLEORADATAHRDBUSERS02.DBF BLOCKSIZE=8192
"BLOCKSIZE is required only if the file to be verified does not have a block size of 2 KB. If the file does not have block size of 2 KB and you do not specify BLOCKSIZE, you will receive the error DBV-00103."
- Chapter 12 of the Oracle9i Database Utilities Guide.
Best regards.
Frank
|
|
|
|
| Re: DBVERIFY problem [message #60441 is a reply to message #59889] |
Sun, 08 February 2004 20:03 |
Gnana Sekar
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
Hi Scott,
This is not a big issue. While you give dbv command , you must specify even this parameter blocksize=8192
Now this will give you output
ex :
> dbv file=e:oraclesampuser01.dbf blocksize=8192
this will surely work,
Bye.
Gnana Sekar.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
