Sumário Itens Encontrados: 597Contents at a GlancePART IGetting Started with RMAN in Oracle Database 12c1 Quick-Start Guide for RMAN and Oracle Database 12c2 Oracle Database 12c Backup and Recovery Architecture Tour3 Introduction to the RMAN Architecture4 Oracle Database 12c MultitenantPART IIRMAN Configuration, Backup, and Recovery Essentials5 RMAN Setup and Configuration6 The RMAN Recovery Catalog7 RMAN Backups8 RMAN Restore and Recovery9 Advanced RMAN Recovery Topics10 Duplication: Cloning the Target DatabaseRMAN Maintenance and Administration11 Maintaining RMAN12 Monitoring and Reporting in RMAN13 Performance Tuning RMAN Backup and Recovery Operations14 Using Oracle Cloud Control for Backup and RecoveryRMAN in a Highly Available Architecture15 RMAN Best Practices16 Surviving User Errors: Flashback Technologies17 RMAN and Data Guard18 RMAN and Real Application Clusters19 Zero Data Loss Recovery Appliance: Evolution of RMAN to Enterprise-wideDatabase Protection Solution20 RMAN in the Workplace: Case StudiesPART VRMAN Media Management21 Media Management Considerations22 Oracle Secure Backup23 Backing Up to Amazon Web Services Using the Oracle Secure Backup CloudModule24 Enhancing RMAN with Veritas NetBackup for Oracle25 Configuring HP Data Protector for Oracle26 RMAN and Tivoli Storage Manager27 RMAN and CommVault SimpanaPART VIAppendixesA RMAN Scripting ExamplesB Setting Up an RMAN Test EnvironmentIndexAcknowledgmentsIntroductionPreliminary StepsConfiguring the Database for RMAN OperationsDetermine Where the FRA Should Be Located and Create ItLog Into the Database and Configure It to Use the FRAPut the Database in ARCHIVELOG ModeBacking Up the DatabaseRestoring the DatabaseSummaryWhat This Book Is AboutIâm Already an RMAN ExpertâWhy Do I Need This Book or This Chapter?Letâs Kick Off the TourBackup and Recovery EssentialsHigh AvailabilityBackup and RecoveryA Few Oracle Terms to KnowOracle Database Architecture in the Pre-Multitenant AgeThe Oracle ProcessesOracle Memory and RMANThe Oracle DatabaseMore About the Oracle Redo LogsARCHIVELOG Mode vs. NOARCHIVELOG ModeOracle Logical StructuresThe Combined PictureStartup and Shutdown of the DatabaseMore Oracle Database InternalsControlling the Database SoftwareOracle Backup and Recovery PrimerLogical Backup and RecoveryOracle Physical Backup and RecoveryBacking Up Other Oracle ComponentsServer-Managed RecoveryThe RMAN UtilityRMAN and Database PrivilegesThe Network Topology of RMAN BackupsRMAN and ScaleRMAN and Shared ServersRunning RMAN Locally from the Target Databaseâs ORACLE_HOMEThe Database Control FileRecord Reuse in the Control FileThe Snapshot Control FileRebuilding the Control FileThe RMAN Server ProcessesRMAN Channel ProcessesThe SYS Packages Used by RMANSYS.DBMS_RCVMANSYS.DBMS_BACKUP_RESTOREBacking Up the Data BlockThe Data Block Backup OverviewThe Benefits of Block-Level BackupsRMAN in MemoryInput Memory BuffersRMAN Memory Utilization: PGA vs. SGAThe Recovery CatalogThe Auxiliary DatabaseCompatibility IssuesThe RMAN General Compatibility RulesThe RMAN Process: From Start to FinishThe Fast Recovery AreaIntroducing Oracle MultitenantThe CDBPluggable DatabasesHow Does Oracle Multitenant Impact RMAN Backup and Recovery?Administering Container DatabasesStarting and Stopping the CDBCommon UsersThe Pluggable DatabaseThe PDB NameCreating a PDBPDB UsersConnecting to a PDBAsking for Directions: Determining Which PDB You Are InArchitecture of a Pluggable DatabasePDB ConstraintsPDB PerformancePDB Resource ManagementCDBs and PDBs and the Data DictionaryThe Multitenant Database Data DictionaryPDB AdministrationOther CDB-Related TopicsDropping a CDBDropping a PDBPDB Cloning and Plugging and Unplugging PDBsConfiguring Your Database to Run in ARCHIVELOG ModeARCHIVELOG Destination DirectoriesShould You Use the FRA?Switching Between ARCHIVELOG ModesIf You Created Your Database with the Oracle Database ConfigurationAssistantRMAN Workshop: Put the Database in ARCHIVELOG ModeThe Oracle Database Fault Diagnosability InfrastructureThe ADR and Related Fault Diagnosability Infrastructure ComponentsConfiguring the Fault Diagnosability InfrastructureThe RMAN Command LineConnecting via the RMAN Command LineExiting the RMAN ClientSetting Up the Database UserRMAN Workshop: Create the Target Database RMAN Backup AccountSetting Up Database SecuritySetting the CONTROL_FILE_RECORD_KEEP_TIME ParameterConfiguring RMAN Default SettingsIntroducing the configure CommandConfiguring Various RMAN Default SettingsExamples of Using the configure CommandIf You Are Using Shared ServersSummary of RMAN Configuration TasksOther Backup and Recovery Setup and Configuration ConsiderationsWhat Is the Recovery Catalog?Creating the Recovery Catalog Owning Schema in a NonmultitenantDatabaseRMAN Workshop: Create the Recovery Catalog User AccountCreating the Recovery CatalogâOwning Schema in a MultitenantCreating the Recovery Catalog Schema ObjectsRMAN Workshop: Create the Recovery CatalogRMAN Workshop: Register Your Database in the Recovery CatalogUtilizing an RMAN Virtual Private CatalogRMAN Workshop: Create a Virtual Private Catalog for Oracle 12.1.0.1and Earlier DatabasesMerging Multiple Recovery CatalogsRMAN Workshop: Merge Two Recovery CatalogsRMAN Stored ScriptsCreating Stored ScriptsQuerying the Recovery Catalog for Stored Script InformationChanging Stored ScriptsDeleting Stored ScriptsUsing Stored ScriptsPrinting Stored ScriptsRMAN Workshop: Using RMAN Stored ScriptsRecovery Catalog MaintenanceUnregistering a Database in RMANDatabase Migration/Upgrade IssuesManually Resetting the Database Incarnation (reset catalog)Manually Resynchronizing the Recovery Catalog (resync catalog)Purging Recovery Catalog RecordsBacking Up the Recovery CatalogRecovery Catalog ViewsThe Purpose of the Recovery Catalog Views and the Database DataDictionary ViewsThe Recovery Catalog Base Tables, Views, and Database DataExamples of Using the Recovery Catalog Base Tables and ViewsCatalog Views Intended for Use by Oracle Enterprise ManagerUsing the RMAN Backup CommandThe Backup CommandThe Backup Command, Channels, and PerformanceRMAN Backup Command OptionsBacking Up to a Specific Device TypeControlling Attributes of Backup Sets and Backup Set PiecesMultisection BackupsRMAN CompressionTagsRestore PointsThe duration Command: Putting Limits on BackupsArchival BackupsOverriding the Configure Exclude CommandSkipping Offline, Inaccessible, or Read-Only DatafilesOverride Backup OptimizationBacking Up Datafiles Based on Their Last Backup TimeChecking for Logical Corruption during a BackupMaking Copies of Backups on Your RMAN CopierCapturing the Elusive Control FileUsing the RMAN Set CommandOffline RMAN Database BackupsOffline Backups Using Configured SettingsRMAN Workshop: Perform an Offline BackupBreaking Down the Workshop OutputOffline Backups without Using Configured DefaultsOnline RMAN Database BackupsOnline Database BackupsRMAN Workshop: Perform an Online BackupVariations on a Theme: Other Types of RMAN Online BackupsTablespace BackupsDatafile BackupsArchived Redo Log BackupsControl File and Parameter File BackupsBackup Set BackupsFast Recovery Area BackupsCopiesImage CopiesDatabase, Tablespace, and Datafile Image CopiesControl File CopiesARCHIVELOG Image CopiesIncremental RMAN BackupsThe Block Change Tracking FileThe Base BackupDifferential vs. Cumulative Incremental BackupsIncrementally Updated BackupsRMAN Workshop: Perform an Incremental BackupGetting StartedRMAN Workshop: Get Your Database Backed Up!RMAN Best Practices Introduced in This ChapterRMAN Restore and Recovery BasicsTypes of Oracle Database RecoveriesAbout Restoring Multitenant DatabasesPreparing for an RMAN RestoreStaging RMAN Backup Set Pieces for RestoresRestoring the SPFILERMAN Workshop: Recover Your SPFILERestoring the Control FileRMAN Workshop: Recover Your Control FileRestore and Recover the Database in NOARCHIVELOG ModePreparing for the RestoreRestoring to a Different LocationRMAN Workshop: Recover Your NOARCHIVELOG Mode DatabaseDatabase Recoveries in ARCHIVELOG ModePoint-of-Failure Database RecoveriesRMAN Workshop: Complete Recovery of Your ARCHIVELOG ModeTablespace RecoveriesDatafile RecoveriesWhat If I Use Incremental Backups?Recovering from Online Redo Log LossLoss of an Inactive Online Redo Log Group MemberLoss of an Inactive Online Redo Log GroupLoss of an Active but Not Current Online Redo Log GroupLoss of the Current Online Redo Log GroupThe Data Recovery AdvisorUsing the Data Recovery Advisor Through RMANData Recovery Advisor Data Dictionary ViewsRecovery of Pluggable DatabasesRecovering the Root ContainerRecovering the Seed ContainerRecovering PDBsIncomplete Database Recoveries on Non-CDB and Entire CDB DatabasesWhat Is an Incomplete Recovery?Incomplete Recovery: How Does It Work?Establishing a Point to Recover ToTime-Based RecoveriesSCN-Based RecoveriesChange-Based RecoveriesRestore PointâBased RecoveriesPerforming Incomplete Recoveries of Pluggable Databases (PDB)About PDB Point-in-Time RecoveriesRestrictions and Requirements Associated with PDB Point-in-timeRecoveriesPDB Time-Based RecoveryPDB SCN-Based RecoveryPDB Change-Based RecoveryRecovering Based on a Restore PointOther RMAN Recovery TopicsRead-Only Tablespace Recovery ConsiderationsArchived Redo Log RestoresDatafile Copy RestoresRecovering Corrupted Data BlocksRecovering to a Previous IncarnationTable and Partition Point-in-Time RecoveryPrerequisites for Restoring and Recovering Database Tables andPartitionsRestrictions on Restoring and Recovering Database Tables andOptions to Consider when Restoring Tables and PartitionsHow RMAN Implements the Restore and Recovery of Tables andRestoring Tables and Partitions from PDBsUsing RMAN to Restore and Recover a Database Table: An ExampleTablespace Point-in-Time RecoveryPreparing for the TSPITRPerforming the Actual TSPITRCustomized Automated TSPITR with an Automatic InstanceRMAN Duplication: A PrimerWhy Use RMAN Duplication?Different Types of RMAN DuplicationThe Duplication ArchitectureDuplication: Location ConsiderationsDuplication to the Same Server: An OverviewDuplication to the Same Server, Different ORACLE_HOMEDuplication to a Remote Server: An OverviewDuplication and the NetworkRMAN Workshop: Build a Password FileDuplication to the Same ServerRMAN Workshop: Duplication to the Same Server Using Disk BackupsUsing Tape BackupsDuplication to a Remote ServerRMAN Workshop: Duplication to a Remote Server Using Disk BackupsUsing Tape Backups for Remote Server DuplicationTargetless Duplication in 12cIncomplete Duplication: Using the DBNEWID UtilityNew RMAN Cloning Features for 12cUsing CompressionDuplicating Large TablespacesRMAN MaintenanceCrosschecking RMAN BackupsRMAN Workshop: Using the Crosscheck CommandVerifying Your BackupsThe Restoreâ¦Preview CommandUsing the Restoreâ¦Validate and Check Logical CommandsUsing the validate CommandBackup Retention PoliciesArchive Log Retention PoliciesThe Change CommandRMAN Workshop: Using the Change CommandThe Delete CommandRMAN Workshop: Using the Delete CommandCataloging Other Backups in RMANWhen You Just Canât Take It AnymoreThe RMAN List CommandListing IncarnationsListing BackupsListing Image CopiesListing Restore PointsListing the DB_UNIQUE_NAMEThe RMAN Report CommandReporting on Datafiles that Have Not Been Backed Up RecentlyReporting on Backup Redundancy or Recovery WindowReporting on Unrecoverable Operations on DatafilesReporting on the Database SchemaReporting on Obsolete BackupsData Dictionary Views for ReportingBefore You Tune RMANRMAN Performance: What Can Be Achieved?Have the Right Hardware in PlaceUse the Correct Backup StrategyTune the DatabaseTuning RMANTuning RMAN SettingsTuning the MML LayerIdentifying Database-Related RMAN IssuesTracing RMAN SessionsEM12c ArchitectureOracle Management RepositoryOracle Management ServiceOracle Management AgentsThe Cloud Control ConsolePlug-InsInstalling and Configuring Enterprise Manager Cloud Control 12c for DatabaseBackupsInstalling an Enterprise Manager AgentDiscovering TargetsConfiguring Backup and Recovery Settings with EM12cBacking Up a Database with EM12cSchedule Oracle-Suggested BackupSchedule Customized BackupBacking Up Multiple Databases at OnceManaging BackupsBackup ReportsUsing EM12c for RecoveryPerforming RecoveryData ProtectionEnterprise ArchitectureDisaster RecoveryData Governance and SecurityMonitoring and SchedulingBest PracticesService-Level AgreementsStandards and ProcessesRMAN Best PracticesPrepared for the Inevitable: Flashback TechnologyFlashback and the Undo Segment: A Love StoryFlashback QueryFlashback Versions QueryFlashback TablePerforming the Flashback Table Operation from SQLFlashback Table with Oracle Enterprise ManagerFlashback TransactionFlashback DropThe Recycle BinFlashback DatabaseFlashback LogsFlashback Retention TargetRMAN Workshop: Configure for Flashback DatabaseFlashback Database: Tuning and TweakingFlashback Data Archive (Total Recall)Types of Standby DatabasesPhysical Standby DatabaseLogical Standby DatabaseUsing RMAN to Create Standby DatabasesPreparing to Create a Standby DatabaseEstablishing a Naming ConventionPutting the Database in ARCHIVELOG Mode and Forced LoggingModeSetting Database ParametersCreating the Auxiliary Database Password FileConfiguring the Oracle NetworkPreparing and Starting the Auxiliary InstanceStarting RMANCreating the Standby DatabaseAfter the Standby Is CreatedRMAN Workshop: Create a Standby Database Using RMANTaking Backups from the Standby DatabaseOther RMAN and Data Guard TopicsRestoring a Lost Datafile, Tablespace, or Database from a StandbyDatabase with RMANResynchronizing the Standby DatabaseArchive Log Backups from the Standby DatabaseReal Application Clusters: Unique Backup ChallengesArchive Log BackupsRAC Recovery ChallengesRestore OperationsMedia Management Considerations During a RestoreRecovery Considerations After a RestoreAdvanced RMAN/RAC TopicsDuplication to a Single-Node SystemRMAN Workshop: Duplicating a RAC Database to a Single-NodeThe Single-Node Standby DatabaseRMAN Workshop: Creating a Single-Node Standby Database from aRAC DatabaseBacking Up the Multinode RAC DatabaseThe Zero Data Loss Recovery Appliance: An OverviewArchitectureProtected DatabasesDelta PushDelta StoreReplicationAutonomous Tape ArchivalBackup ValidationProtection PolicyCooperative Space ManagementMonitoring and AdministrationScale-out HardwareBefore the RecoveryWhat Is the Exact Nature of the Failure?What Recovery Options Are Available?Might Oracle Support Be Needed?Who Can Act as a Second Pair of Eyes During Recovery?Recovery Case StudiesCase #1: Recovering from Complete Database Loss(NOARCHIVELOG Mode) with a Recovery CatalogCase #2: Recovering from Complete Database Loss(NOARCHIVELOG Mode) Without a Recovery CatalogCase #3: Recovering from Complete Database Loss (ARCHIVELOGMode) Without a Recovery CatalogCase #4: Recovering from Complete Database Loss (ARCHIVELOGMode) with a Recovery CatalogCase #5: Recovering from the Loss of the SYSTEM TablespaceCase #6: Recovering Online from the Loss of a Datafile or TablespaceCase #7: Recovering from Loss of an Unarchived Online Redo LogCase #8: Recovering Through resetlogsCase #9: Completing a Failed Duplication ManuallyCase #10: Using RMAN Duplication to Create a Historical Subset ofthe Target DatabaseCase #11: Recovering from a Lost Datafile (ARCHIVELOG Mode)Using an Image Copy in the Fast Recovery AreaCase #12: Recovering from Running the Production Datafile Out of theFast Recovery AreaCase #13: Using Flashback Database and Media Recovery to Pinpointthe Exact Moment to Open the Database with resetlogsTape Backups in a Disk Backup WorldRMAN and the Media Manager: An OverviewThe Media Manager CatalogThe Media Manager: Other Software ComponentsMedia Management LibraryRMAN Workshop: Test Tape Channels with the Oracle Default SBTInterfaceInterfacing with the MMLThe SBT APIBack Up to Tape: From Start to FinishRestore from Tape: From Start to FinishUsing sbttest and loadsbt.exeMedia Management ErrorsFeatures of Oracle Secure BackupOracle Secure Backup and Recovery ManagerDifferences Between OSB and OSB ExpressBackup EncryptionFast Database Backup CompressionOracle Secure Backup Cloud ModuleOracle Secure Backup InterfacesOracle Secure Backup ComponentsOracle Secure Backup DaemonsHost Access ModesAdministrative DataOracle Secure Backup Users and ClassesOperating System AccountsNDMP HostsOracle Secure Backup Rights and ClassesInstalling and Configuring Oracle Secure BackupRMAN Workshop: Install and Configure Oracle Secure BackupOracle Database and File System Data Backup Using Oracle Secure BackupRMAN Workshop: Schedule Oracle Database and File System DataOracle Database Backup Using Oracle Secure Backup Cloud ModuleRMAN Workshop: Installing OSB Cloud Module and Using It for OSBConventional Backups: Assumptions and LimitationsThe Oracle Secure Backup Cloud ModuleWhat Is Cloud Computing?Oracle and the Amazon CloudElastic Compute Cloud (EC2) and Elastic Block Store (EBS)Simple Storage Service (S3): Oracleâs Cloud Backup SolutionRMAN Backup to S3: The Oracle Secure Backup Cloud ModuleS3 Backup over the Internet or from Amazon EC2Oracle Cloud Backup AdvantagesRMAN Workshop: Deploying RMAN Backups to Amazon S3Performing Backups by Using the OSB Cloud ModuleTo Persistently Store S3 as the Default SBT ChannelTo Specify the OSB Cloud Module Each Time You Allocate a ChannelListing RMAN Backups and Backup Sets Stored on S3Optimizing Backups and Recoveries over the Internet Using the OSBCloud Module and Amazon S3Example with Multiple Channels and Compressed Backup SetsLicensing ConsiderationsKey FeaturesNecessary ComponentsStorage/Media Device ConfigurationNetBackup InstallationPre-Installation Tasks for NetBackup for Oracle AgentNetBackup for Oracle Agent Installation StepsHow to Link Oracle to NetBackup Media ManagerAutomatic Link MethodManual Link MethodConfiguring NetBackup PoliciesAdding New PoliciesDefining SchedulesDefining a Backup SelectionDefining Policy ClientsManaging Expired Backup ImagesDelete Expired Backups Using NetBackup RepositoryDelete Expired Backups Using RMANRMAN Sample ScriptsTroubleshootingUse NetBackup LogsDetermine Which Library Is in UseSecurity Best PracticesCost JustificationIntegration of Oracle and Data ProtectorSupport MatrixIntegration ComponentsIntegration RestrictionsRMAN Workshop: Integration ConfigurationRMAN Backup Configuration on Data ProtectorRMAN WORKSHOP: Backup ConfigurationEditing the RMAN ScriptRunning an RMAN BackupBackup MethodsBackup ProcedureRestoring Oracle Using the Data Protector GUIRestoring Oracle Database ObjectsOracle RMAN Metadata and Data Protector Media Management DatabaseSynchronizationOverview of Tivoli Storage ManagerTSM Server System ObjectsTSM ClientRMAN Workshop: Configuring TDPO for OraclePerforming an RMAN Backup Using TDPODefault ChannelsDeleting Database BackupsTroubleshooting Common Backup ScenariosAdditional TroubleshootingSimpana OverviewInstallationData RetentionSchedule PoliciesCommVault Oracle iDA: What Is It?Configure an Oracle InstanceConfigure the SubclientInitiate a BackupRestoreAdvanced ConfigurationsRMAN InterfaceRMAN Scripts for WindowsCreating a Windows Script to Schedule BackupsScheduling the BackupRMAN Scripts for UnixThe Test BoxMatch Your Production EnvironmentGo CheapâAt a PriceThe Oracle ConfigurationMultiple HomesCreating DatabasesThe RMAN Configuration