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

Migrate to and from an ASM environment


RMAN is the only available method to migrate from and to ASM environments. ASM is an efficient and reliable storage mechanism that first appeared in 10g Rel. 1. There are two ways to backup an ASM environment, one is by means of a low level disk dump, which performs a complete raw device dump and does not allow the DBA to select individual storage structures such as tablespaces or datafiles; the other method is by means of Recovery Manager. Today, ASM seems pretty complex and abstract for several DBAs, but once it is setup and is up and working, it is seamless to work with it, and it is quite the same as if it was a regular storage unit with tablespaces and datafiles. The flash recovery area, redologs, backups, and datafiles live in there and are managed just like any other regular database file.

The database could have been created in an ASM environment since the very beginning, but what about if this was not the case? Is there a means to move datafiles...