In addition to running the Oracle Enterprise Edition, Oracle requires the following prerequisites for Block Media Recovery to be met as defined in Performing Block Media Recovery of the Oracle Database Backup and Recovery User’s Guide.
• |
The target database must run in ARCHIVELOG mode and be open or mounted with a current Control File. |
The V$DATABASE_BLOCK_CORRUPTION view displays blocks marked corrupt by database components such as RMAN commands, ANALYZE, and SQL queries. Physical corruption, sometimes called media corruption, results in rows being added to this view. For example, the database does not recognize the block: the checksum is invalid, the block contains all zeros, or the block header is fractured.
In addition to being reported in V$DATABASE_BLOCK_CORRUPTION, block corruption is also reported in the following locations:
• |
• |
• |
Results of the DBVERIFY utility |
A standard User Managed restore with Plug‑in for Oracle includes the following steps:
1 |
Connect to the database with SYSDBA privileges by using the SQL*Plus utility. |
1 |
In the Navigation pane, click Create Restore Job. |
• |
Restore All Using Defaults: To restore using the prepopulated defaults, click this button, and proceed to Finalizing and submitting the job. |
• |
Restore: To use the Create Selection Set page to select the items that you want to restore, click this button and proceed to the next step. |
5 |
On the Create Selection Set page, select the data that you want to restore. |
NOTE: For User Managed restores, you do not have to set any other options; the Restore Options tab does not contain any fields. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center