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

Test restore


A production environment cannot be conceived without a backup policy. Not having a backup compromises overall productivity directly or indirectly related to the database. It is pretty evident that your job and that of the people responsible for the operation will be compromised as well. Performing a backup is a must do task in all production environments, but testing the backup doesn't seem to be as important for some corporations. Testing a backup is as important as performing the backup itself.

Note

A useless backup is equivalent to not having a backup at all. At the least, it wastes time that could have been used to formulate alternate strategies.

When asked about a backup policy most declare they have one implemented. On the other hand, when asked about a test policy, very few hands are raised. Then, what is the acid test for every backup? Most of the times the answer is: it is required after a real life failure scenario. The reason why most people don't implement a test policy...