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