Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Chapter 5. Recovery Manager Restore and Recovery Techniques

Once a backup has been taken the second part of the process is to perform the restore or recover operation. This is an operation no one wants to have to undertake, but you must be prepared to do so if it is required. This chapter deals with the recovery tasks from the recovery manager point of view.

All the scenarios assume that you have a database in archivelog mode and a valid backup which was taken using recovery manager. The database used to perform the demonstrations is a regular general purpose database created with the DBCA. The scenarios are performed with the SYSDBA role because this role can manage the Oracle instance and it can perform incomplete recovery operations.

Oracle database recovery

There are two situations when a database recovery process will be required, one is after an instance failure, and the other is after a media failure. The recovery process takes information from the redo log files or the archivelog files...