Sumário Itens Encontrados: 91hapter 1: Introduction 1Use Cases for Duplicating 2Methods for Replicating 2RMAN Duplicate Advantages 4Ease of Use 5Performance and Security 5Flexible Replication 6RMAN Duplication Overview 6Definition of Terms 6RMAN Duplication Process 8Example Setup Environment 10Summary 11Chapter 2: Manual Duplication Techniques 13Cloning from Cold Backup 13Copying from an RMAN Backup 18Renaming a Database 29Manual 29NID 31Replicating with Data Pump Across a Network Link 33Replicating with Data Pump Transportable Tablespaces 36RMAN Replication Using Transportable Tablespaces 40Same Operating System 40Cross-Platform Replication 43Different Operating System (Convert Tablespace) 43Different Operating System (Convert DataFile) 47Moving Data with External Tables 50Enabling Parallelism 53Enabling Compression 54Summary 54Chapter 3: Backup-Based Duplication 55Basic Troubleshooting 56Checking Syntax 56Monitoring Progress 57Capturing RMAN Output 60Targetless Duplication 62Directory Structure and Database Name Remain Identical 62Directory Structure Identical and Database Name Different 65Directory Structures and Database Names Different, Using SPFILE Clause 68Directory Structures and Database Names Different, Not Using SPFILE 71Shell Scripting the Duplication Process 76Duplicating and Stopping Recovery at a Specific Time 77Restarting Duplication 78Restricting Access after Duplication 78Scenarios Requiring Connections to Target 80UNTIL Sequence 80UNTIL Restore Point 82Summary 84Chapter 4: Active Duplication 85Oracle Net Configuration 86Setting Up the Listener 87Setting Up the Password File 88Same Directory Structure and Database Name 89Different Directory Structure and Database Name Using SPFILE Clause 91Replicating from a Noarchivelog Mode Target 95Same-Host Replication 98Image Copies 102Compression 104Encryption 106Summary 107Chapter 5: Advanced Topics 109Partial Database Duplication 109Excluding Tablespaces 110Including Tablespaces 112Parallelism 113Configuring Parallelism 113Using SECTION SIZE 115Creating Standby Databases 116Creating Standby from Active Target 117Creating Standby from RMAN Backup 125Container and Pluggable Databases 128Duplicating a Container Database 129Duplicating Pluggable Databases 132RAC Databases 134Non-RAC/Non-ASM to RAC/ASM 134RAC/ASM to Non-RAC/Non-ASM 136Summary 138Chapter 6: Oracle Net Primer 139Oracle Net 139Services Default Behavior 141Creating and Registering Services with the Listener 146Setting SERVICE_NAMES 146Statically Registering Services 151Dynamic Registration versus Static Registration 154Why Use Multiple Services? 155Using DBMS_SERVICE 155Displaying Service Information 157Listener 159Starting a Listener 160Modifying the Behavior of the Listener 161Summary 164Index 165