Home Page Icon
Home Page
Table of Contents for
PART III Backup, Recovery, and Database Movement
Close
PART III Backup, Recovery, and Database Movement
by Franck Pachot, Vit Špinka, Anton Els
Oracle Database 12c Release 2 Multitenant
Cover
Title Page
Copyright Page
Dedication
About the Authors
Contents at a Glance
Contents
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
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
6 Security
Next
Next Chapter
7 Backup and Recovery
PART
III
Backup, Recovery, and Database Movement
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset