Oracle RMAN database duplication / Darl Kuhn.
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 m...
Saved in:
| Online Access: |
Full Text (via Skillsoft) |
|---|---|
| Main Author: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
New York :
IOUG : Apress,
[2015]
|
| Series: | Expert's voice in Oracle.
|
| Subjects: |
Table of Contents:
- At a Glance; Introduction; Chapter 1: Introduction; Use Cases for Duplicating; Methods for Replicating; RMAN Duplicate Advantages; Ease of Use; Performance and Security; Flexible Replication; RMAN Duplication Overview; Definition of Terms; RMAN Duplication Process; Example Setup Environment; Summary; Chapter 2: Manual Duplication Techniques; Cloning from Cold Backup; Copying from an RMAN Backup; Renaming a Database; Manual; NID; Replicating with Data Pump Across a Network Link; Replicating with Data Pump Transportable Tablespaces; RMAN Replication Using Transportable Tablespaces
- Same Operating SystemCross-Platform Replication; Different Operating System (Convert Tablespace); Different Operating System (Convert DataFile); Moving Data with External Tables; Enabling Parallelism; Enabling Compression; Summary; Chapter 3: Backup-Based Duplication; Basic Troubleshooting; Checking Syntax; From the Command Line; From a Script; Monitoring Progress; Operating System Approach; SQL Approach; Capturing RMAN Output; RMAN Logging; Script Command; Tee Command; RMAN Command Output View; Targetless Duplication; Directory Structure and Database Name Remain Identical
- Directory Structure Identical and Database Name DifferentDirectory Structures and Database Names Different, Using SPFILE Clause; Directory Structures and Database Names Different, Not Using SPFILE; Transforming Directory Names via Initialization File; Transforming Directory Names using SET NEWNAME; Shell Scripting the Duplication Process; Duplicating and Stopping Recovery at a Specific Time; Restarting Duplication; Restricting Access after Duplication; Scenarios Requiring Connections to Target; UNTIL Sequence; UNTIL Restore Point; Summary; Chapter 4: Active Duplication
- Oracle Net ConfigurationSetting Up the Listener; Setting Up the Password File; Same Directory Structure and Database Name; Different Directory Structure and Database Name Using SPFILE Clause; Replicating from a Noarchivelog Mode Target; Same-Host Replication; Image Copies; Compression; Encryption; Summary; Chapter 5: Advanced Topics; Partial Database Duplication; Excluding Tablespaces; Including Tablespaces; Parallelism; Configuring Parallelism; Using SECTION SIZE; Creating Standby Databases; Creating Standby from Active Target; Creating Standby from RMAN Backup
- Container and Pluggable DatabasesDuplicating a Container Database; Duplicating Pluggable Databases; Including Pluggable Databases; Excluding Pluggable Databases; RAC Databases; Non-RAC/Non-ASM to RAC/ASM; RAC/ASM to Non-RAC/Non-ASM; Summary; Chapter 6: Oracle Net Primer; Oracle Net; Services Default Behavior; Creating and Registering Services with the Listener; Setting SERVICE_NAMES; Setting the LOCAL_LISTENER to contain host and port information; Setting LOCAL_LISTENER to point to an entry in tnsnames.ora; Statically Registering Services; Dynamic Registration versus Static Registration