Re: 9.2 32-bit to 10.2 64-bit Migration

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 15 Jul 2006 07:58:11 +0200
Message-ID: <1s0hb2d6poi3qv5ql3rm3mjkq0rhrn5qki@4ax.com>

On 14 Jul 2006 13:52:44 -0700, "Charles Hooper" <hooperc2000_at_yahoo.com> wrote:

>To help my understanding, what if the tablespace were 25GB in size, and
>you therefore have at least 13 - 2GB data files for the tablespace.
>You find that the twelfth data file for the tablespace is corrupt. Can
>you recover just that data file? My suspicion is that the tables and
>indexes, which have data blocks in that data file likely are not
>completely contained within that data file, but rather have data blocks
>in several of the data files. If you were to recover just this
>corrupted data file, would that not leave the database in an
>inconsistent state?

Even in a non-Rman environment you can, since Oracle 6, issue a recover datafile command.

To HansF: as far as I know, you can do block recovery in a RMAN environment only when you have non-incremental backups. That would pretty much exclude big datafiles.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jul 15 2006 - 00:58:11 CDT