After completing this lesson, you should be able to: • Perform complete or incomplete user-managed recovery • Identify situations where incomplete recovery is necessary • Perform complete or incomplete recovery by using RMAN • Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method • Recover an automatically backed up control file • Use Enterprise Manage to perform recovery • Recover read-only tablespaces | Database Recovery Oracle Database 10g: Administration Workshop II 5- Objectives After completing this lesson, you should be able to: Perform complete or incomplete user-managed recovery Identify situations where incomplete recovery is necessary Perform complete or incomplete recovery by using RMAN Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method Recover an automatically backed up control file Use Enterprise Manage to perform recovery Recover read-only tablespaces User man. RMAN CLI EM Complete Incomplete Control file RO TBS Oracle Database 10g: Administration Workshop II 5- Recovery Methods There are two methods for performing recovery: User-managed recovery Files must be maintained and moved into place manually. Use SQL*Plus commands. RMAN recovery Files are managed automatically. Use RMAN functionality including all repository maintenance and reporting capabilities. This can be done by using Enterprise Manager. Oracle . | Database Recovery Oracle Database 10g: Administration Workshop II 5- Objectives After completing this lesson, you should be able to: Perform complete or incomplete user-managed recovery Identify situations where incomplete recovery is necessary Perform complete or incomplete recovery by using RMAN Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method Recover an automatically backed up control file Use Enterprise Manage to perform recovery Recover read-only tablespaces User man. RMAN CLI EM Complete Incomplete Control file RO TBS Oracle Database 10g: Administration Workshop II 5- Recovery Methods There are two methods for performing recovery: User-managed recovery Files must be maintained and moved into place manually. Use SQL*Plus commands. RMAN recovery Files are managed automatically. Use RMAN functionality including all repository maintenance and reporting capabilities. This can be done by using Enterprise Manager. Oracle Corporation recommends using this method. Recovery Methods User-managed recovery requires more manual involvement than RMAN recovery, which is the recommended method and the one covered in more detail in this lesson. Oracle Database 10g: Administration Workshop II 5- User-Managed Recovery: RECOVER Command Restore all database files from a backup and then recover the database: Restore the damaged data files from a backup and then recover the data files: Or: SQL> RECOVER DATABASE SQL> RECOVER TABLESPACE index_tbs SQL> RECOVER DATAFILE 2> '/oradata/' User-Managed Recovery: RECOVER Command The first step in performing user-managed media recovery is to manually restore the data files by copying them from a backup. If you do not restore a data file to its original location, you must update the control file with the new location by using an ALTER DATABASE RENAME FILE command. You must also restore any archived logs files needed to recover the restored data files. For RMAN restorations,
