Apr 1, 2016

Fix : DBV-00008: USERID must be specified for OSM files

One of my friend get below error while running dbv command for a datafile which was available in ASM disk group.

Err:   DBV-00008: USERID must be specified for OSM files

Here is sample error:

$ dbv file='+DATA/PROD/datafile/sample01.dbf'

DBVERIFY: Release 11.2.0.4.0 - Production on Fri Apr 1 14:02:30 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


DBV-00008: USERID must be specified for OSM files


So, you give the username and password via userid, then it will work fine.

Sample Example :

$ dbv userid=registration/reg40 file=+DATA/PROD/datafile/sample01.dbf 

DBVERIFY: Release 11.2.0.4.0 - Production on Fri Apr 1 14:05:27 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = +DATA/PROD/datafile/sample01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 1365512
Total Pages Processed (Data) : 836672
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 84780
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 360647
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 83413
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 0 (0.0)



Thanks .

No comments:

Post a Comment

Translate >>