O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Database 12c Release 2 Multitenant

Book Description

Master the Powerful Multitenant Features of Oracle Database 12c

Govern a scalable, extensible, and highly available enterprise database environment using the practical information contained in this Oracle Press guide. Written by a team of Oracle Masters, Oracle Database 12c Release 2 Multitenant shows, step-by-step, how to deploy and manage multitenant configurations across IT frameworks of all types and sizes. Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are covered in complete detail.

Learn how to:

• Build high-performance multitenant Oracle databases
• Create single-tenant, multitenant, and application containers
• Establish network connections and manage services
• Handle security using authentication, authorization, and encryption
• Back up and restore your mission-critical data
• Work with point-in-time recovery and Oracle Flashback
• Move data and replicate and clone databases
• Work with Oracle’s Resource Manager and Data Guard


Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. About the Authors
  6. Contents at a Glance
  7. Contents
  8. Introduction
  9. PART I What Multitenant Means
    1. 1 Introduction to Multitenant
      1. History Lesson: A New Era in IT
        1. The Road to Multitenant
        2. Schema Consolidation
        3. Table Consolidation
        4. Server Consolidation
        5. Virtualization
        6. Multiple Databases Managed by One Instance
        7. Summary of Consolidation Strategies
      2. The System Dictionary and Multitenant Architecture
        1. The Past: Non-CDB
        2. Multitenant Containers
        3. Multitenant Dictionaries
        4. Working with Containers
      3. What Is Consolidated at CDB Level
        1. Data and Metadata at CDB Level
      4. Summary
    2. 2 Creating the Database
      1. Creating a Container Database (CDB)
        1. What About OMF?
      2. CDB Creation Options
        1. Creating a Pluggable Database
        2. Create a New PDB from PDB$SEED
        3. Create a New PDB Using the Local Clone Method
        4. Create a PDB Using SQL Developer
        5. Create a PDB Using the DBCA
        6. Create a PDB Using Cloud Control
      3. Using the catcon.pl Script
      4. Summary
    3. 3 Single-Tenant, Multitenant, and Application Containers
      1. Multitenant Architecture Is Not an Option
        1. Non-CDB Deprecation
        2. Noncompatible Features
      2. Single-Tenant in Standard Edition
        1. Data Movement
        2. Security
        3. Consolidation with Standard Edition 2
      3. Single-Tenant in Enterprise Edition
        1. Flashback PDB
        2. Maximum Number of PDBs
      4. Using the Multitenant Option
        1. Application Containers
        2. Consolidation with Multitenant Option
      5. Summary
  10. PART II Multitenant Administration
    1. 4 Day-to-Day Management
      1. Choosing a Container to Work With
      2. Managing the CDB
        1. Create the Database
        2. Database Startup and Shutdown
        3. Drop the Database
        4. Modify the Entire CDB
        5. Modify the Root
      3. Managing PDBs
        1. Create a New PDB
        2. Open and Close a PDB
        3. View the State of PDBs
        4. View PDB Operation History
        5. Run SQL on Multiple PDBs
        6. Modify the PDB
        7. Drop a PDB
      4. Patching and Upgrades
        1. Upgrade CDB
        2. Plugging In
        3. Patching
      5. Using CDB-Level vs. PDB-Level Parameters
        1. CDB SPFILE
        2. PDB SPFILE Equivalent
        3. SCOPE=MEMORY
        4. Alter System Reset
        5. ISPDB_MODIFIABLE
        6. Container=ALL
        7. DB_UNIQUE_NAME
      6. Summary
    2. 5 Networking and Services
      1. Oracle Net
      2. The Oracle Net Listener
      3. The LREG Process
      4. Networking: Multithreaded and Multitenant
      5. Service Names
        1. Default Services and Connecting to PDBs
        2. Creating Services
      6. Create a Dedicated Listener for a PDB
      7. Summary
    3. 6 Security
      1. Users, Roles, and Permissions
        1. Common or Local?
        2. What Is a User?
        3. CONTAINER=CURRENT
        4. CONTAINER=COMMON
        5. Local Grant
        6. Common Grant
        7. Conflicts Resolution
        8. Keep It Clear and Simple
        9. CONTAINER_DATA
        10. Roles
        11. Proxy Users
      2. Lockdown Profiles
        1. Disable Database Options
        2. Disable Alter System
        3. Disable Features
      3. PDB Isolation
        1. PDB_OS_CREDENTIALS
        2. PATH_PREFIX
        3. CREATE_FILE_DEST
      4. Transparent Data Encryption
        1. Setting Up TDE
        2. Plug and Clone with TDE
        3. TDE Summary
      5. Summary
  11. PART III Backup, Recovery, and Database Movement
    1. 7 Backup and Recovery
      1. Back to Basics
        1. Hot vs. Cold Backups
        2. RMAN: The Default Configuration
        3. RMAN Backup Redundancy
        4. The SYSBACKUP Privilege
      2. CDB and PDB Backups
        1. CDB Backups
        2. PDB Backups
        3. Do Not Forget Archive Logs!
      3. Recovery Scenarios
        1. Instance Recovery
        2. Restore and Recover a CDB
        3. Restore and Recover a PDB
      4. RMAN Optimization Considerations
      5. The Data Recovery Advisor
      6. Block Corruption
      7. Using Cloud Control for Backups
        1. Back Up to the Cloud
      8. Summary
    2. 8 Flashback and Point-in-time Recovery
      1. Pluggable Database Point-in-Time
        1. Recover PDB Until Time
        2. Where Is the UNDO?
        3. Summary of 12.1 PDBPITR
      2. Local UNDO in 12.2
        1. Database Properties
        2. Create Database
        3. Changing UNDO Tablespace
        4. Changing UNDO Mode
        5. Shared or Local UNDO?
      3. PDB Point-in-Time Recovery in 12.2
        1. PDBPITR in Shared UNDO Mode
        2. PDBPITR in Local UNDO Mode
      4. Flashback PDB
        1. Flashback Logging
        2. Flashback with Local UNDO
        3. Flashback in Shared UNDO
        4. Restore Points at the CDB and PDB Levels
        5. Clean Restore Point
      5. Resetlogs
      6. Flashback and PITR
        1. When Do You Need PITR or Flashback?
        2. Impact on the Standby Database
        3. Auxiliary Instance Cleanup
      7. Summary
    3. 9 Moving Data
      1. Grappling with PDB File Locations
      2. Plugging In and Unplugging
        1. Unplug and Plug In a PDB
        2. An Unplugged Database Stays in the Source
        3. What Exactly Is in the XML File?
        4. Check Compatibility for Plug-In
        5. Plug In a PDB as Clone
        6. PDB Archive File
      3. Cloning
        1. Cloning a Local PDB
        2. Cloning a Remote PDB
      4. Application Container Considerations
      5. Converting Non-CDB Database
        1. Plug In a Non-CDB
        2. Cloning a Non-CDB
      6. Moving PDBs to the Cloud
      7. Triggers on PDB Operations
      8. Full Transportable Export/Import
      9. Transportable Tablespaces
      10. Summary
  12. PART IV Advanced Multitenant
    1. 10 Oracle Database Resource Manager
      1. Resource Manager Basics
        1. Key Resource Manager Terminologies
        2. Resource Manager Requirements
        3. Resource Manager Levels
      2. The CDB Resource Plan
        1. Resource Allocation and Utilization Limits
        2. Default and Autotask Directives
        3. Creating a CDB Resource Plan
      3. The PDB Resource Plan
        1. Creating a PDB Resource Plan
        2. Enable or Disable a PDB Resource Plan
        3. Removing a PDB Resource Plan
      4. Manage PDB Memory and I/O via Initialization Parameters
        1. PDB Memory Allocations
        2. Limit PDB I/O
      5. Instance Caging
        1. Instance Caging to Resource Manager
      6. Monitoring Resource Manager
        1. Viewing the Resource Plan and Plan Directives
        2. Monitoring PDBs Managed by Resource Manager
      7. Summary
    2. 11 Data Guard
      1. Active Data Guard Option
      2. Creating a Physical Standby
        1. Duplicate with RMAN
        2. Create a Standby with Cloud Control
      3. Managing a Physical Standby in a Multitenant Environment
        1. Creating a New PDB on the Source
        2. Removing PDB from Source
        3. Changing the Subset
        4. Cloud Control
      4. Standby in the Cloud
      5. Summary
    3. 12 Sharing Data Across PDBs
      1. Database Links
      2. Sharing Common Read-Only Data
        1. Transportable Tablespaces
        2. Storage Snapshots and Copy on Write
      3. Cross-PDB Views
        1. Simple User Tables
        2. Consolidated Data
      4. Cross-Database Replication
      5. Summary
    4. 13 Logical Replication
      1. Oracle LogMiner
      2. Obsolete Features
        1. Oracle CDC
        2. Oracle Streams
        3. Oracle Advanced Replication
      3. Oracle GoldenGate
        1. Multitenant Support in Oracle GoldenGate
        2. Big Data Adapters
      4. Oracle XStream
      5. Logical Standby
        1. Use in Upgrade
      6. Other Third-Party Options
        1. Dbvisit Replicate
        2. Dell SharePlex
      7. Summary
  13. Index