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 as a database administrator to satisfy the m...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 1st ed. 2015. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630011006719 |
Tabla de Contenidos:
- 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
- Why Use Multiple Services?
