dbverify

Hi all
New to this company after the DBA quit. I have noticed an ora-0600 with an argument[2023] that has never been fixed since a year ago.
While running DBVERIFY, I realized that some of the files are not accessible including the SYSTEM datafiles and some are.


DBVERIFY: Release 8.1.7.4.0 - Production on Wed Nov 3 09:05:03 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBV-00100: Specified FILE (/data1/oradata/vault/system01.dbf) not accessible
%

DBVERIFY: Release 8.1.7.4.0 - Production on Tue Nov 2 13:13:42 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBV-00100: Specified FILE (/vol01/oradata/vault/indx1.dbf) not accessible
%
DBVERIFY: Release 8.1.7.4.0 - Production on Tue Nov 2 09:03:00 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /data05/oradata/vault/rbs1.dbf
......................................................................DBVERIFY - Verification complete

Total Pages Examined : 3899232
Total Pages Processed (Data) : 56756
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 3842220
Total Pages Failing (Index): 0
Total Pages Processed (Other): 241
Total Pages Empty : 15
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
%
What does this leave me now? or what can one say about this situation. The database is still up running?

Please advise

Hi

(/data1/oradata/vault/system01.dbf does this file exist ?what are the permisiions on this file ?

do a export of sys objects for this database

regards
Hrishy

Hi

(/vol01/oradata/vault/indx1.dbf

index tablespace is corrupted if at all..You dont have to worry you can always rebuild all the indexes in this tablespaces

regards
Hrishy

Quote:

---

Originally posted by hrishy
do a export of sys objects for this database

---

And how would you do that? Certanly not with the exp utility...

hrishy
Thanks for the prompt response.
Do an export of the system objects from the same database? If the system datafile cannot be accessed..what does it mean? It means that there is something wrong with the system datafiiles right?
Correct me if I am wrong.

Is the file >2G? If yes, you need to use dbv from a newer version. Search on metalink..