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