Re: Checing for DB Corruption

From: Chetan Wagle <chetanw_at_yahoo.com>
Date: Fri, 24 Sep 1999 11:45:30 +0530
Message-ID: <7sf4r8$3un$1@herald.ctp.com>

Do a full database export since export definitely detects any block corruption errors !!

Rgds,
Chetan

Chuck wrote in message <37ea7c44.84439968_at_client.nw.news.psi.net>...
>
>
>I am running Oracle 8.0.5 on Solaris 2.6. All database files are
>located on a Sun A5200 Fibre Array managed by Veritas 3.3.1
>
>
>Here is my problem:
>
>The fibre array lost power while databases were mounted and opened but
>not being used, ie no user sessions. I brought the array back online
>and synced the filesystems several times. However, my existing svrmgrl
>session died giving me a bus error and subsequent attempts to use
>svrmgrl failed also. I booted the server and everthing seems to have
>mounted successfully and the databases can be mounted and opened with
>no apparent problems. How can I verify that the databases are in a
>consistent state?
>
>Thanks,
>Chuck
>
Received on Fri Sep 24 1999 - 01:15:30 CDT