RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach

CHAPTER 15Duplicating Databases and Transporting Data

Oracle DBAs routinely create duplicate databases by using the source database backup files or by using the new Oracle Database 11g feature active database duplication, which lets you duplicate a database without any prior backups of the source database. You can make an exact replica of the source database or omit some of the tablespaces if you want. These duplicate databases help you test database upgrades and application changes and serve as reporting databases under some circumstances. You also have the option, if you want, of duplicating a database to a past point in time. Duplicating a database comes in handy when you need to test a backup and recovery strategy. You also use the duplicate ...