Define Multiple Locations for Archive Log Files using export
Oracle Backup and Recovery Conclusion
By now, you have learned about the other improvements within Oracle, with regard to backup and recovery.
Now that you have completed this module, you should be able to:
Define multiple locations for archive log files
Use DBMS_REPAIR package to detect and repair corrupt blocks
Use LogMiner to query the archive log files
Use the LIST and REPORT commands within RMAN
Query the data dictionary for backup views
Describe the improvements in export and import
Options for Repairing Data Block Corruption
Oracle Database provides different methods for detecting and correcting data block corruption. One method of correction is to drop and re-create an object after the corruption is detected. However, this is not always possible or desirable. If data block corruption is limited to a subset of rows, then another option is to rebuild the table by selecting all data except for the corrupt rows.
Another way to manage data block corruption is to use the DBMS_REPAIR package. You can use DBMS_REPAIR to detect and repair corrupt blocks in tables and indexes. You can continue to use objects while you attempt to rebuild or repair them.
Note: Any corruption that involves the loss of data requires analysis and understanding of how that data fits into the overall database system. Depending on the nature of the repair, you might lose data, and logical inconsistencies can be introduced. You must determine whether the repair approach provided by this package is the appropriate tool for each specific corruption problem.
About the DBMS_REPAIR Package
This section describes the procedures contained in the DBMS_REPAIR package and notes some limitations and restrictions on their use.
The following table lists the procedures included in the DBMS_REPAIR package.
Limitations and Restrictions
DBMS_REPAIR procedures have the following limitations:
Tables with LOB datatypes, nested tables, and varrays are supported, but the out of line columns are ignored.
Clusters are supported in the SKIP_CORRUPT_BLOCKS and REBUILD_FREELISTS procedures, but not in the CHECK_OBJECT procedure.
Index-organized tables and LOB indexes are not supported.
The DUMP_ORPHAN_KEYS procedure does not operate on bitmap indexes or function-based indexes.
The DUMP_ORPHAN_KEYS procedure processes keys that are no more than 3,950 bytes long.
The following terms were introduced in this module:
Optimizer: Optimization is a process of choosing the most efficient way to execute a SQL statement.
A part of Oracle called the optimizer calculates the most efficient way to execute a SQL statement. The optimizer evaluates several factors to select among alternative access paths.
Handle: A handle is a connection to the database server, which completes a transaction for the user.
Deprecated: When a certain feature or functionality is no longer advisable for use or will no longer be supported on the Oracledatabase server, that feature is called deprecated.
Metadata: The system tables and views of Oracle are metadata of the database.
The next module explores using Enterprise Manager for backup and recovery.
Reporting Concepts Data Dictionary Recovery Views - Quiz