-
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
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
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
-
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...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Is the file >2G? If yes, you need to use dbv from a newer version. Search on metalink..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|