My Oracle Support Banner

RDBPROD: How to Recover Rows From a Corrupted Table When a Backup not Available (Doc ID 102521.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS VAX
HP OpenVMS Alpha

Goal

The purpose of this article is to describe a method of recovering as much data as possible from a table in a storage area with corrupt pages when there is no backup available to restore and recover the database. Depending on the database design, there may be more than one table stored in a storage area. Take this into account when performing the below steps.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.