Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control

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