Oracle RMAN Database Duplication

RMAN is Oracle’s flagship backup and recovery tool, but did you know it’s also an effective database duplication tool? Oracle RMAN Database Duplication is a deep dive into RMAN’s duplication feature set, showing how RMAN can make it so much easier for you

  • PDF / 10,108,406 Bytes
  • 183 Pages / 438.765 x 666 pts Page_size
  • 69 Downloads / 309 Views

DOWNLOAD

REPORT


Contents at a Glance About the Author������������������������������������������������������������������������������xi About the Technical Reviewers������������������������������������������������������xiii Acknowledgments���������������������������������������������������������������������������xv Introduction�����������������������������������������������������������������������������������xvii ■■Chapter 1: Introduction������������������������������������������������������������������1 ■■Chapter 2: Manual Duplication Techniques����������������������������������13 ■■Chapter 3: Backup-Based Duplication������������������������������������������55 ■■Chapter 4: Active Duplication�������������������������������������������������������85 ■■Chapter 5: Advanced Topics�������������������������������������������������������109 ■■Chapter 6: Oracle Net Primer������������������������������������������������������139 Index����������������������������������������������������������������������������������������������165

v

Introduction Companies often have the requirement to provision copies of databases. These replicated databases are used for a wide variety of business purposes, such as reporting, testing Oracle upgrades, testing new application releases, troubleshooting, performance tuning, and so on. There are a wide variety of techniques for making copies of databases. Oracle provides many tools that can assist with database duplication. One such tool is the RMAN DUPLICATE functionality. With just a few lines of code DBAs can efficiently and easily create copies of databases. The focus of this book is database duplication using RMAN. If you find yourself frequently replicating databases then consider using RMAN duplication to automate what would otherwise be a sometimes complicated process.

What This Book Covers Chapter 1 introduces you to the topic of database duplication. The groundwork for the other chapters is provided here. Chapter 2 covers background information on manual techniques for making copies of databases. These methods are important to understand as they’re widely used and will allow you to compare and contrast the manual methods with the RMAN duplication functionality. Backup-based RMAN duplication is the focus of Chapter 3. This simplest way to duplicate a database is using an RMAN backup as the source. The targetless duplication feature is covered extensively here. Chapter 4 moves on to active duplication. This type of replication uses the live database as the source for duplicating a database. Chapter 5 then covers advanced topics such as duplicating subsets of tablespaces, enabling parallelism, container/pluggable database duplication, and RAC/ASM to non-RAC/non-ASM duplication. Chapter 6 is an introduction to Oracle Net. Many of the duplication scenarios require you to connect to the source and destination databases over Oracle Net. This chapter serves as an introduction to Oracle Net implementation and management. These six chapters will provide you with a solid foundation for Oracle RMAN