DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: dbverify

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    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.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    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

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  5. #5
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    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.

  6. #6
    Join Date
    Oct 2002
    Posts
    807
    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
  •  


Click Here to Expand Forum to Full Width