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)
$
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