Last updated on MAY 28, 2014
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Goal
<p >*Goal
<span >Enter the goal of the document. What does the customer want to accomplish?
- This Article is intended for users who have a Primary and Standby configuration and corruption has been reported on couple of blocks in a datafile.
- This document explains how to use datafile copy option in block recovery to do block recovery there by effectively saving time in applying lots of archivelogs .
- This document is intended for users where Downtime is not available and datafile restore/ recovery is not a option since file would have to be taken offline.
- A valid level0 or full backups are available but were taken few days/weeks backup and there are lots of archivelog that need to be applied for block recovery from these backups which might take days.
- Backups are on tape.
- Corruption are reported Only on Primary or Standby database but not on both and not on same data blocks.
- Both Primary and standby are in Sync or gap is less.
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