You are previewing Oracle RMAN Database Duplication.
O'Reilly logo
Oracle RMAN Database Duplication

Book Description

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 as a database administrator to satisfy the many requests from developers and testers for database copies and refreshes for use in their work. You’ll learn to make and refresh duplicate databases with a single command, and of course you can automate and schedule that command so that developers and testers are supplied with regular, known good databases without any manual intervention on your part.

Fast and easy provisioning of databases for developers and testers is a driving force in the move to cloud computing and virtualization. RMAN’s robust database duplication feature set plays right into this growing need for ease of provisioning, enabling easy duplication of known-good databases on demand, across operating systems such as between Linux and Solaris, and even across storage environments such as when duplicating from a RAC/ASM environment to a single-node instance using regular file system storage. Oracle RMAN Database Duplication is your thorough guide to providing amazing business value to your organization by way of fast and easy provisioning of database duplicates in service of development and testing projects.

Table of Contents

  1. Cover
  2. Title
  3. Copyright
  4. Dedication
  5. Contents at a Glance
  6. About IOUG Press
  7. Contents
  8. About the Author
  9. About the Technical Reviewers
  10. Acknowledgments
  11. Introduction
  12. Chapter 1: Introduction
    1. Use Cases for Duplicating
    2. Methods for Replicating
    3. RMAN Duplicate Advantages
      1. Ease of Use
      2. Performance and Security
      3. Flexible Replication
    4. RMAN Duplication Overview
      1. Definition of Terms
      2. RMAN Duplication Process
    5. Example Setup Environment
    6. Summary
  13. Chapter 2: Manual Duplication Techniques
    1. Cloning from Cold Backup
    2. Copying from an RMAN Backup
    3. Renaming a Database
      1. Manual
      2. NID
    4. Replicating with Data Pump Across a Network Link
    5. Replicating with Data Pump Transportable Tablespaces
    6. RMAN Replication Using Transportable Tablespaces
      1. Same Operating System
      2. Cross-Platform Replication
      3. Different Operating System (Convert Tablespace)
      4. Different Operating System (Convert DataFile)
    7. Moving Data with External Tables
      1. Enabling Parallelism
      2. Enabling Compression
    8. Summary
  14. Chapter 3: Backup-Based Duplication
    1. Basic Troubleshooting
      1. Checking Syntax
      2. Monitoring Progress
      3. Capturing RMAN Output
    2. Targetless Duplication
      1. Directory Structure and Database Name Remain Identical
      2. Directory Structure Identical and Database Name Different
      3. Directory Structures and Database Names Different, Using SPFILE Clause
      4. Directory Structures and Database Names Different, Not Using SPFILE
      5. Shell Scripting the Duplication Process
      6. Duplicating and Stopping Recovery at a Specific Time
      7. Restarting Duplication
      8. Restricting Access after Duplication
    3. Scenarios Requiring Connections to Target
      1. UNTIL Sequence
      2. UNTIL Restore Point
    4. Summary
  15. Chapter 4: Active Duplication
    1. Oracle Net Configuration
      1. Setting Up the Listener
      2. Setting Up the Password File
    2. Same Directory Structure and Database Name
    3. Different Directory Structure and Database Name Using SPFILE Clause
    4. Replicating from a Noarchivelog Mode Target
    5. Same-Host Replication
    6. Image Copies
    7. Compression
    8. Encryption
    9. Summary
  16. Chapter 5: Advanced Topics
    1. Partial Database Duplication
      1. Excluding Tablespaces
      2. Including Tablespaces
    2. Parallelism
      1. Configuring Parallelism
      2. Using SECTION SIZE
    3. Creating Standby Databases
      1. Creating Standby from Active Target
      2. Creating Standby from RMAN Backup
    4. Container and Pluggable Databases
      1. Duplicating a Container Database
      2. Duplicating Pluggable Databases
    5. RAC Databases
      1. Non-RAC/Non-ASM to RAC/ASM
      2. RAC/ASM to Non-RAC/Non-ASM
    6. Summary
  17. Chapter 6: Oracle Net Primer
    1. Oracle Net
    2. Services Default Behavior
    3. Creating and Registering Services with the Listener
      1. Setting SERVICE_NAMES
      2. Statically Registering Services
      3. Dynamic Registration versus Static Registration
      4. Why Use Multiple Services?
      5. Using DBMS_SERVICE
      6. Displaying Service Information
    4. Listener
      1. Starting a Listener
      2. Modifying the Behavior of the Listener
    5. Summary
  18. Index
  19. General