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

Recovery Manager basics


Recovery Manager(RMAN) is a tool that efficiently and reliably performs backup, restoration, and recovery tasks on Oracle Databases. It can be used from a Command Line Interface(CLI) or from the Enterprise Manager Web Console. It is still available in 10g from the Enterprise Manager Java Console. However, its usage is discouraged as this console has become obsolete and it is no longer available in 11g.

RMAN is a utility that works in a client-server fashion when launched in CLI mode, or in a three-tier fashion when launched from the EM Console. It commands actions from the client side and the entire backup and restore operations take place on the server side using the server storage resources. The database to be managed is known as the TARGET database. RMAN may optionally use a database to keep track of the backups. This database is known as the recovery catalog database, and is an independent database that stores information about the backup operations for different...