Saturday, December 27, 2008

ALLOW 1 CORRUPTION

Allow Corruption in datafile recovering database:

When ever oracle encounter a corrupted block in datafile while restore, the restore just stops and we cannot go further in our restoration process. But we can still continue with restoring process by ALLOW x CORRUPTON clause allowing with restore database command.

Eg. In case if you have 2 corrupted blocks we can restore as below.

SQL>RECOVER DATABASE ALLOW 2 CORRUPTION;

1 comment:

Ravishna said...

Nice. Thanks for the explanation .