You are previewing Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control.
O'Reilly logo
Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control

Book Description

This practical Oracle Press guide teaches cutting-edge techniques for building, configuring, and managing a secure private database cloud with Oracle Enterprise Manager 13c

This hands-on volume lays out ready-to-deploy roadmaps for the design and maintenance of high-performance private database clouds using Oracle Enterprise Manager 13c. Learn best practices for a wide variety of different approaches—Database as a Service, Snap Clone as a Service, Schema as a Service, and Pluggable Database as a Service.

Oracle Private Cloud Cookbook with Enterprise Manager 13c thoroughly explains how to architect, configure, and manage every component in a private database cloud lifecycle. You will get an insider’s solutions for securing your cloud-based infrastructure, generating reliable RMAN backups, and protecting your mission-critical enterprise information using Oracle Data Guard. This comprehensive volume from Oracle Press features detailed, step-by-step instructions with multiple screen shots and diagrams that illustrate each technique along the way.

  • Real-world examples and case studies illustrate applications in various industries
  • Offers essential skills for cloud administrators and DBAs
  • Author is an Oracle Certified Master, previous ACE director, and experienced computing writer

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. Contents at a Glance
  6. Contents
  7. Acknowledgments
  8. Introduction
  9. 1 Consolidation Planning for the Cloud
    1. Introducing Oracle Cloud Computing
    2. Consolidating to Physical Servers
      1. Running the Host Consolidation Planner
      2. Creating a Custom Consolidation Scenario for P2P
    3. Consolidating to Oracle Public Cloud Servers
    4. Consolidating to Virtual Machines
    5. Updating the Benchmark Rates
    6. Database Consolidation Workbench
      1. Creating a D2S Project and Scenario
      2. Creating a D2D Project and Scenario
      3. Implementing the Consolidation
    7. Summary
  10. 2 Database as a Service
    1. Configuring the Self Service Portal
      1. Set Up the Software Library
      2. Set Up Self Update
      3. Deploy the Plug-ins
      4. Create the Portal Role and User
      5. Create the PaaS Infrastructure Zone
      6. Create a Database Pool
      7. Enter Quotas
      8. Create a Data Profile: Single-Instance Database
      9. Create a Data Profile: Snap Clone Database
      10. Create a Service Template: Single-Instance Database
      11. Create a Service Template: Snap Clone Database
      12. Enable Request Settings
      13. Configure Chargeback
    2. Self-Service: Request and Create a Database Service
    3. Self-Service: Request and Create a Snap Clone (CloneDB) Database Service
    4. Summary
  11. 3 Schema as a Service
    1. Create a Schema Pool
    2. Dealing with Quotas
    3. Creating a Data Profile
    4. Creating a Service Template for the HR Schema
    5. Creating a Service Template for User-Defined Schemas
    6. Request Settings
    7. Configuring Chargeback
    8. Self Service: Request and Create a Schema Service
    9. Self Service: Request and Create User-Defined Schemas
    10. Summary
  12. 4 Pluggable Database as a Service
    1. Creating a Pluggable Database Pool
    2. Setting Up Quotas
    3. Creating a Data Profile for PDB
    4. Creating a Service Template from a PDB Profile
    5. Creating a Service Template for an Empty PDB
    6. Setting Up Request Settings
    7. Configuring Chargeback
    8. Self Service: Request and Create a PDB Service for SALES PDB
    9. Self Service: Request and Create a PDB Service for Empty PDB
    10. Viewing Chargeback Results
    11. Administering the Cloud
    12. Summary
  13. 5 Hybrid Database Cloud
    1. Presetup for Hybrid Cloud
      1. Step 1: Register the Agent
      2. Step 2: Generate SSH Keys
      3. Step 3: Create a Named Credential
      4. Step 4: Changing SELINUX to Permissive
      5. Other Requirements
    2. Testing the Hybrid Cloud
      1. Installing the Cloud Agent
      2. Discovering the Database and Listener on the Cloud Server
      3. Comparing On-Premise and Cloud Database Configurations
      4. Cloning PDBs from On-Premise to Cloud
    3. Preserving the Agent Home When Patching the Cloud Database
    4. Cloning to Oracle Cloud
      1. Masking Results
      2. Verifying the APEX Version of CDBs
    5. Cloning from Oracle Cloud
    6. Summary
  14. 6 Using the Cloud REST API
    1. Installing the REST Client
    2. Presteps
    3. Step 1: Viewing Details
    4. Step 2: Creating a Database
      1. Checking the Progress of Database Creation via the Enterprise Manager API
      2. Checking the Progress of Database Creation via the Cloud REST API
    5. Step 3: Refreshing the Database That Was Requested and Created
    6. Step 4: Deleting the Database That Was Requested and Created
    7. Step 5: Creating a Schema
      1. Checking the Progress of the Schema Creation Request via EM13c Screens
      2. Checking the Progress of the Schema Creation Request via the Cloud REST API
    8. Step 6: Deleting the Schema Service That Was Requested and Created
    9. Step 7: Creating a Pluggable Database
      1. Checking the Progress of the PDB Creation Request via EM13c Screens
      2. Checking the Progress of the PDB Creation Request via the Cloud REST API
    10. Step 8: Deleting the Pluggable Database That Was Requested and Created
    11. Importing Postman Collections from JSON Files (Optional)
    12. Summary
  15. 7 Managing Database Backups
    1. Backups in the Past
    2. RMAN Benefits
    3. Initial Backup Steps
    4. Backup Settings
    5. Scheduling a Full Backup
      1. Understanding the Output
    6. Managing Backups
    7. Scheduling an Incremental Backup
      1. Oracle Suggested Backups
    8. Backup Strategies
    9. Database Group Backups
      1. Scheduling Group Backups
    10. Backups of Oracle Database 12c
    11. Creating Backup Reports
    12. Summary
  16. 8 Managing Standby Databases
    1. The Old Days of Oracle Disaster Recovery
    2. Initial Steps
    3. Adding a Standby Database
    4. Menu Options for Data Guard
    5. Data Guard Administration
    6. Editing Standby Database Properties
      1. General Tab Settings
      2. Standby Role Properties Tab Settings
      3. Common Properties Tab Settings
      4. Saving and Checking Your Settings
    7. Editing Primary Database Properties
    8. Converting to Snapshot Standby
    9. Switchover and Failover
      1. Performing a Switchover
      2. Performing a Failover
    10. Far Sync in Oracle Database 12c
    11. Data Guard via Self Service
    12. Summary
  17. Index