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:
Nice. Thanks for the explanation .
Post a Comment