book

Oracle Database 12c Release 2 Multitenant

by Anton Els, Vit Špinka, Franck Pachot

September 2016

Intermediate to advanced

416 pages

9h 56m

English

McGraw Hill Computing

Read now

Unlock full access

History Lesson: A New Era in ITThe Road to MultitenantSchema ConsolidationTable ConsolidationServer ConsolidationVirtualizationMultiple Databases Managed by One InstanceSummary of Consolidation StrategiesThe System Dictionary and Multitenant ArchitectureThe Past: Non-CDBMultitenant ContainersMultitenant DictionariesWorking with ContainersWhat Is Consolidated at CDB LevelData and Metadata at CDB LevelSummary

Creating a Container Database (CDB)What About OMF?CDB Creation OptionsCreating a Pluggable DatabaseCreate a New PDB from PDB$SEEDCreate a New PDB Using the Local Clone MethodCreate a PDB Using SQL DeveloperCreate a PDB Using the DBCACreate a PDB Using Cloud ControlUsing the catcon.pl ScriptSummary
Multitenant Architecture Is Not an OptionNon-CDB DeprecationNoncompatible FeaturesSingle-Tenant in Standard EditionData MovementSecurityConsolidation with Standard Edition 2Single-Tenant in Enterprise EditionFlashback PDBMaximum Number of PDBsUsing the Multitenant OptionApplication ContainersConsolidation with Multitenant OptionSummary
Choosing a Container to Work WithManaging the CDBCreate the DatabaseDatabase Startup and ShutdownDrop the DatabaseModify the Entire CDBModify the RootManaging PDBsCreate a New PDBOpen and Close a PDBView the State of PDBsView PDB Operation HistoryRun SQL on Multiple PDBsModify the PDBDrop a PDBPatching and UpgradesUpgrade CDBPlugging InPatchingUsing CDB-Level vs. PDB-Level ParametersCDB SPFILEPDB SPFILE EquivalentSCOPE=MEMORYAlter System ResetISPDB_MODIFIABLEContainer=ALLDB_UNIQUE_NAMESummary
Oracle NetThe Oracle Net ListenerThe LREG ProcessNetworking: Multithreaded and MultitenantService NamesDefault Services and Connecting to PDBsCreating ServicesCreate a Dedicated Listener for a PDBSummary
Users, Roles, and PermissionsCommon or Local?What Is a User?CONTAINER=CURRENTCONTAINER=COMMONLocal GrantCommon GrantConflicts ResolutionKeep It Clear and SimpleCONTAINER_DATARolesProxy UsersLockdown ProfilesDisable Database OptionsDisable Alter SystemDisable FeaturesPDB IsolationPDB_OS_CREDENTIALSPATH_PREFIXCREATE_FILE_DESTTransparent Data EncryptionSetting Up TDEPlug and Clone with TDETDE SummarySummary
Back to BasicsHot vs. Cold BackupsRMAN: The Default ConfigurationRMAN Backup RedundancyThe SYSBACKUP PrivilegeCDB and PDB BackupsCDB BackupsPDB BackupsDo Not Forget Archive Logs!Recovery ScenariosInstance RecoveryRestore and Recover a CDBRestore and Recover a PDBRMAN Optimization ConsiderationsThe Data Recovery AdvisorBlock CorruptionUsing Cloud Control for BackupsBack Up to the CloudSummary
Pluggable Database Point-in-TimeRecover PDB Until TimeWhere Is the UNDO?Summary of 12.1 PDBPITRLocal UNDO in 12.2Database PropertiesCreate DatabaseChanging UNDO TablespaceChanging UNDO ModeShared or Local UNDO?PDB Point-in-Time Recovery in 12.2PDBPITR in Shared UNDO ModePDBPITR in Local UNDO ModeFlashback PDBFlashback LoggingFlashback with Local UNDOFlashback in Shared UNDORestore Points at the CDB and PDB LevelsClean Restore PointResetlogsFlashback and PITRWhen Do You Need PITR or Flashback?Impact on the Standby DatabaseAuxiliary Instance CleanupSummary
Grappling with PDB File LocationsPlugging In and UnpluggingUnplug and Plug In a PDBAn Unplugged Database Stays in the SourceWhat Exactly Is in the XML File?Check Compatibility for Plug-InPlug In a PDB as ClonePDB Archive FileCloningCloning a Local PDBCloning a Remote PDBApplication Container ConsiderationsConverting Non-CDB DatabasePlug In a Non-CDBCloning a Non-CDBMoving PDBs to the CloudTriggers on PDB OperationsFull Transportable Export/ImportTransportable TablespacesSummary
Resource Manager BasicsKey Resource Manager TerminologiesResource Manager RequirementsResource Manager LevelsThe CDB Resource PlanResource Allocation and Utilization LimitsDefault and Autotask DirectivesCreating a CDB Resource PlanThe PDB Resource PlanCreating a PDB Resource PlanEnable or Disable a PDB Resource PlanRemoving a PDB Resource PlanManage PDB Memory and I/O via Initialization ParametersPDB Memory AllocationsLimit PDB I/OInstance CagingInstance Caging to Resource ManagerMonitoring Resource ManagerViewing the Resource Plan and Plan DirectivesMonitoring PDBs Managed by Resource ManagerSummary
Active Data Guard OptionCreating a Physical StandbyDuplicate with RMANCreate a Standby with Cloud ControlManaging a Physical Standby in a Multitenant EnvironmentCreating a New PDB on the SourceRemoving PDB from SourceChanging the SubsetCloud ControlStandby in the CloudSummary
Database LinksSharing Common Read-Only DataTransportable TablespacesStorage Snapshots and Copy on WriteCross-PDB ViewsSimple User TablesConsolidated DataCross-Database ReplicationSummary
Oracle LogMinerObsolete FeaturesOracle CDCOracle StreamsOracle Advanced ReplicationOracle GoldenGateMultitenant Support in Oracle GoldenGateBig Data AdaptersOracle XStreamLogical StandbyUse in UpgradeOther Third-Party OptionsDbvisit ReplicateDell SharePlexSummary

Overview

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