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

Last updated on APRIL 13, 2017

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

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 hundreds of Community platforms