Sumário Itens Encontrados: 233PART IWhat Multitenant Means1 Introduction to Multitenant2 Creating the Database3 Single-Tenant, Multitenant, and Application ContainersPART IIMultitenant Administration4 Day-to-Day Management5 Networking and Services6 SecurityPART IIIBackup, Recovery, and Database Movement7 Backup and Recovery8 Flashback and Point-in-time-Recovery9 Moving DataPART IVAdvanced Multitenant10 Oracle Database Resource Manager11 Data Guard12 Sharing Data Across PDBs13 Logical ReplicationIndexIntroductionHistory 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 LevelSummaryCreating 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 ScriptMultitenant 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 OptionChoosing 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_NAMEOracle NetThe Oracle Net ListenerThe LREG ProcessNetworking: Multithreaded and MultitenantService NamesDefault Services and Connecting to PDBsCreating ServicesCreate a Dedicated Listener for a PDBUsers, 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 SummaryBack 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 Cloud8 Flashback and Point-in-time RecoveryPluggable 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 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 CleanupGrappling 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 TablespacesResource 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 ManagerActive 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 CloudDatabase LinksSharing Common Read-Only DataStorage Snapshots and Copy on WriteCross-PDB ViewsSimple User TablesConsolidated DataCross-Database ReplicationOracle LogMinerObsolete FeaturesOracle CDCOracle StreamsOracle Advanced ReplicationOracle GoldenGateMultitenant Support in Oracle GoldenGateBig Data AdaptersOracle XStreamLogical StandbyUse in UpgradeOther Third-Party OptionsDbvisit ReplicateDell SharePlex