oracle data file not accessible

[Former Member]

Dear All,

I hitting the following error while trying using dbv command:

-

---

kuldb84s:oraq00 50> dbv FILE=p00.data483

DBVERIFY: Release 10.2.0.4.0 - Production on Mon Nov 22 14:53:12 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBV-00100: Specified FILE (p00.data483) not accessible

kuldb84s:oraq00 51>

-

---

I hitting the same thing with BRTOOLS as well.

Do you know what is the error message above meant ?

Best Regards,

Ken

[Former Member]

Dear All,

This question has been resolved by mounting the all the sapdata file systems with option CIO.

Thanks all.

Best Regards,

Ken

[Former Member]

Dear Gagan,

I would not go for restarting the DB before finding out the root cause. I meant, the reason for restarting DB ?

Dear Tom,

I have tried with the full path, but the result is the same.

Regarding to the dbv help,

1. The data file is exists.

2. The data file is not end with .dbf

I tried the same command in other system, the particular data file able to be verified.

3. How do we justify whether the data files are being locked or not ?

Bes Regards,

Ken

[Former Member]

I recommend Note 527250 - DBV-00100 Composite SAP note

[TomCenens]

Dear Ken

You can also read following thread for more information:

[http://database.itags.org/oracle/51758/]

It includes the SQL statements to check if datafile is locked and so on.

Kind regards

Tom

[Former Member]

Try rebooting the oracle DB along with all services once and then try.

Regards,

[TomCenens]

This message was moderated.