Re: index page failure

Hi Pete,

    You may -- note I say may -- be able to recover safely without rebuilding your entire database. If your indexes are not sharing tablespaces with your tables you can try dropping all of the indexes in the affected tablespaces, dropping the datafiles (remember to delete them at the operating system level) and then recreating the datafiles and indexes. Before you start export your tables (or extract the data so you can reload it with SQL Loader) and make sure that you have whatever scripts you will need to rebuild the database -- just in case.

    If your indexes and tables are sharing tablespaces you might be able to get away with dropping the offending indexes and then coalescing the database, but it is probably just as quick to rebuild and reload the database.

regards

Jerry Gitomer

karanikas_at_my-dejanews.com wrote in message <7g9ve0$ksu$1_at_nnrp1.dejanews.com>...
>Our system crashed the other day and we needed to restore from a
>cold bacup. Everything ran fine for a few hours and then the Sys
>Admin needed to reboot the server. It came back up fine and then we
>decided to use the verify_db utility to check things out. My
>verify_db utility error is indicating 9 occurance of index page
>failure stating 'kdxcofbo=x!=y".
>Verify_db says that the pages are failing and that the values are
>inconsistent. Can I just rebuild the indexes or do I need to rebuild
>the whole database (like support says to do). It has been recommended
>to export the whole database and then rebuild the database.
>
>Here is exactly what I am getting from the VERIFY_DB utility:
>"PAGE FAILED with CHECK CODE 1"
>
>Any help would be greatly appreciated.
>Thanks in advance,
>Pete
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 29 1999 - 12:12:55 CDT