Re: How can I be assured of the integrity of an Oracle database after a crash?

On 8 Jul 1997 18:40:29 GMT, scott.overby_at_sdsdata.com (Scott Overby) wrote:

>
>The subject saus it all.
>
>A client of ours wants to be assured of the integrity of an Oracle instance
>after experiencing sever server crashes(Nwtware 4.1 and Oracle 7.1.x).
>
>Are there any SQL scripts on can run to assure the client that the data is
>OK?
>
>
>--
>==========================================================================
>Scott Overby E-mail scott.overby_at_sdsdata.com
>Sr. Systems Analyst
>Strategic Data Systems FAX (414) 459-9123
>615 Penn Ave.
>Sheboygan, WI 53082
>===========================================================================
>

We use a set of scripts that export each table to /dev/null and then analyse each index. We rean each job separatly to gain the benefit of using all 8 CPUs. We then search (grep) all the output files for error messages. Corruptions have been found and the process works well. On a 80Gb database (50Gb used) it takes about 3 hours in total

John Hallas (jhalla_at_premier.co.uk) Received on Fri Jul 11 1997 - 00:00:00 CDT