Sumário Itens Encontrados: 607PrefaceWhat's New in Backup and Recovery?Part I Overview of Backup and Recovery1 Introduction to Backup and RecoveryPurpose of Backup and RecoveryData ProtectionData PreservationData TransferOracle Backup and Recovery SolutionsOracle Flashback TechnologyLogical Flashback FeaturesFlashback DatabaseData Recovery AdvisorBackup and Recovery Documentation RoadmapRecovery Manager Documentation RoadmapUser-Managed Backup and Recovery Documentation Roadmap2 Getting Started with RMANOverview of the RMAN EnvironmentStarting RMAN and Connecting to DatabaseShowing the Default RMAN ConfigurationBacking Up a DatabaseBacking Up a Database in ARCHIVELOG ModeBacking Up a Database in NOARCHIVELOG ModeTypical Backup OptionsMaking Incremental BackupsValidating Database Files and BackupsScripting RMAN OperationsReporting on RMAN OperationsListing BackupsReporting on Database Files and BackupsMaintaining RMAN BackupsCrosschecking BackupsDeleting Obsolete BackupsDiagnosing and Repairing Failures with Data Recovery AdvisorListing Failures and Determining Repair OptionsRepairing FailuresRewinding a Database with Flashback DatabaseRestoring and Recovering Database FilesPreparing to Restore and Recover Database FilesRecovering the Whole DatabaseRecovering TablespacesRecovering Individual Data BlocksPart II Starting and Configuring RMAN3 Recovery Manager ArchitectureAbout the RMAN EnvironmentRMAN Command-Line ClientRMAN ChannelsChannels and DevicesAutomatic and Manual ChannelsRMAN RepositoryMedia ManagementRMAN Interaction with a Media ManagerOracle Secure BackupBackup Solutions ProgramFlash Recovery AreaRMAN in a Data Guard EnvironmentRMAN Configuration in a Data Guard EnvironmentRMAN File Management in a Data Guard Environment4 Starting and Interacting with the RMAN ClientStarting and Exiting RMANSpecifying the Location of RMAN OutputSetting Globalization Support Environment Variables for RMANEntering RMAN CommandsEntering RMAN Commands at the RMAN PromptUsing Command Files with RMANEntering Comments in RMAN Command FilesUsing Substitution Variables in Command FilesChecking RMAN SyntaxMaking Database Connections with RMANAbout RMAN Database ConnectionsMaking RMAN Database Connections from the Operating System Command LineMaking Database Connections from the RMAN PromptConnecting RMAN to an Auxiliary DatabaseMaking RMAN Database Connections Within Command FilesDiagnosing RMAN Connection ProblemsUsing the RMAN Pipe InterfaceExecuting Multiple RMAN Commands In Succession Through a Pipe: ExampleExecuting RMAN Commands In a Single Job Through a Pipe: Example5 Configuring the RMAN EnvironmentConfiguring the Environment for RMAN BackupsShowing and Clearing Persistent RMAN ConfigurationsConfiguring the Default Device for Backups: Disk or SBTConfiguring the Default Type for Backups: Backup Sets or CopiesConfiguring ChannelsConfiguring Control File and Server Parameter File AutobackupsConfiguring RMAN to Make Backups to a Media ManagerPrerequisites for Using a Media Manager with RMANDetermining the Location of the Media Management LibraryConfiguring Media Management Software for RMAN BackupsTesting Whether the Media Manager Library Is Integrated CorrectlyConfiguring SBT Channels for Use with a Media ManagerConfiguring the Flash Recovery AreaOverview of the Flash Recovery AreaEnabling the Flash Recovery AreaConfiguring Locations for Control Files and Redo LogsConfiguring RMAN File Creation in the Flash Recovery AreaConfiguring the Backup Retention PolicyConfiguring a Redundancy-Based Retention PolicyConfiguring a Recovery Window-Based Retention PolicyDisabling the Retention PolicyConfiguring Backup OptimizationOverview of Backup OptimizationEffect of Retention Policies on Backup Optimization for SBT BackupsConfiguring an Archived Redo Log Deletion PolicyAbout Archived Redo Log Deletion PoliciesEnabling an Archived Redo Log Deletion PolicyConfiguring Oracle Flashback Database and Restore PointsAbout Restore Points and Flashback DatabasePrerequisites for Flashback Database and Guaranteed Restore PointsEnabling Flashback DatabaseCreating Normal and Guaranteed Restore PointsConfiguring the Environment for Optimal Flashback Database PerformanceConfiguring RMAN in a Data Guard Environment6 Configuring the RMAN Environment: Advanced TopicsConfiguring Advanced Channel OptionsAbout Channel Control OptionsConfiguring Specific Channel ParametersConfiguring Advanced Backup OptionsConfiguring the Maximum Size of Backup SetsConfiguring the Maximum Size of Backup PiecesConfiguring Backup DuplexingConfiguring Tablespaces for Exclusion from Whole Database BackupsConfiguring the Backup Compression AlgorithmConfiguring Backup EncryptionConfiguring Auxiliary Instance Datafile NamesConfiguring the Snapshot Control File LocationViewing the Configured Location of the Snapshot Control FileSetting the Location of the Snapshot Control FileConfiguring RMAN for Use with a Shared ServerEnabling Lost Write DetectionPart III Backing Up and Archiving Data7 RMAN Backup ConceptsConsistent and Inconsistent RMAN BackupsConsistent BackupsInconsistent BackupsOnline Backups and Backup ModeBackup SetsBackup Sets and Backup PiecesCompression for Backup SetsEncryption for Backup SetsFilenames for Backup PiecesNumber and Size of Backup PiecesNumber and Size of Backup SetsMultiplexed Backup SetsProxy CopiesImage CopiesRMAN-Created Image CopiesUser-Managed Image CopiesMultiple Copies of RMAN BackupsDuplexed Backup SetsBackups of BackupsControl File and Server Parameter File AutobackupsWhen RMAN Performs Control File AutobackupsHow RMAN Performs Control File AutobackupsIncremental BackupsMultilevel Incremental BackupsBlock Change TrackingIncremental Backup AlgorithmRecovery with Incremental BackupsBackup Retention PoliciesRecovery WindowBackup RedundancyBatch Deletes of Obsolete BackupsBackup Retention Policy and Flash Recovery Area Deletion Rules8 Backing Up the DatabaseOverview of RMAN BackupsPurpose of RMAN BackupsBasic Concepts of RMAN BackupsSpecifying Backup Output OptionsSpecifying the Device Type for an RMAN BackupSpecifying Backup Set or Copy for an RMAN Backup to DiskSpecifying a Format for RMAN BackupsSpecifying Tags for an RMAN BackupMaking Compressed BackupsBacking Up Database Files with RMANMaking Whole Database Backups with RMANBacking Up Tablespaces and Datafiles with RMANBacking Up Control Files with RMANBacking Up Server Parameter Files with RMANBacking Up Archived Redo Logs with RMANAbout Backups of Archived Redo LogsBacking Up Archived Redo Log FilesBacking Up Only Archived Redo Logs That Need BackupsDeleting Archived Redo Logs After BackupsMaking and Updating Incremental BackupsPurpose of Incremental BackupsPlanning an Incremental Backup StrategyIncrementally Updating BackupsUsing Block Change Tracking to Improve Incremental Backup PerformanceMaking Database Backups for Long-Term StoragePurpose of Archival BackupsBasic Concepts of Archival BackupsMaking an Archival Backup for Long-Term StorageMaking a Temporary Archival BackupBacking Up RMAN BackupsAbout Backups of BackupsBacking Up Backup Sets with RMANBacking Up Image Copy Backups with RMAN9 Backing Up the Database: Advanced TopicsLimiting the Size of RMAN Backup SetsAbout Backup Set SizeLimiting the Size of Backup Sets with BACKUP MAXSETSIZEDividing the Backup of a Large Datafile into SectionsUsing Backup Optimization to Skip FilesOptimizing a Daily Archived Log Backup to a Single Tape: ScenarioOptimizing a Daily Archived Log Backup to Multiple Media Families: ScenarioCreating a Weekly Secondary Backup of Archived Logs: ExampleSkipping Offline, Read-Only, and Inaccessible FilesDuplexing Backup SetsDuplexing Backup Sets with CONFIGURE BACKUP COPIESDuplexing Backup Sets with BACKUP COPIESMaking Split Mirror Backups with RMANEncrypting RMAN BackupsAbout RMAN Backup Encryption SettingsMaking Transparent-Mode Encrypted BackupsMaking Password-Mode Encrypted BackupsMaking Dual-Mode Encrypted BackupsRestarting RMAN BackupsAbout Restartable BackupsRestarting a Backup After It Partially CompletesManaging Backup WindowsAbout Backup WindowsSpecifying a Backup DurationPermitting Partial Backups in a Backup WindowMinimizing Backup Load and DurationPart IV Managing RMAN Backups10 Reporting on RMAN OperationsOverview of RMAN ReportingPurpose of RMAN ReportingBasic Concepts of RMAN ReportingListing Backups and Recovery-Related ObjectsAbout the LIST CommandListing Backups and CopiesListing Selected Backups and CopiesListing Database IncarnationsListing Restore PointsReporting on Backups and Database SchemaAbout Reports of RMAN BackupsReporting on Files Needing a Backup Under a Retention PolicyReporting on Datafiles Affected by Unrecoverable OperationsReporting on Obsolete BackupsReporting on the Database SchemaUsing V$ Views to Query Backup MetadataQuerying Details of Past and Current RMAN JobsDetermining the Encryption Status of Backup PiecesQuerying Recovery Catalog ViewsAbout Recovery Catalog ViewsQuerying Catalog Views for the Target DB_KEY or DBID ValuesQuerying RC_BACKUP_FILES11 Maintaining RMAN Backups and Repository RecordsOverview of RMAN Backup and Repository MaintenancePurpose of Backup and Repository MaintenanceBasic Concepts of Backup and Repository MaintenanceMaintaining the Control File RepositoryAbout Control File RecordsPreventing the Loss of Control File RecordsProtecting the Control FileMaintaining the Flash Recovery AreaDeletion Rules for the Flash Recovery AreaMonitoring Flash Recovery Area Space UsageManaging Space For Flashback Logs in the Flash Recovery AreaResponding to a Full Flash Recovery AreaDropping Restore PointsChanging the Flash Recovery Area to a New LocationDisabling the Flash Recovery AreaResponding to an Instance Crash During File CreationMonitoring Flashback Database Performance ImpactFlashback Writer (RVWR) Behavior With I/O ErrorsUpdating the RMAN RepositoryCrosschecking the RMAN RepositoryChanging the Repository Status of Backups and CopiesAdding Backup Records to the RMAN RepositoryRemoving Records from the RMAN RepositoryDeleting RMAN Backups and Archived Redo LogsOverview of RMAN DeletionDeleting All Backups and CopiesDeleting Specified Backups and CopiesDeleting Expired RMAN Backups and CopiesDeleting Obsolete RMAN Backups Based on Retention PoliciesDropping a Database12 Managing a Recovery CatalogOverview of the Recovery CatalogPurpose of the Recovery CatalogBasic Concepts for the Recovery CatalogBasic Steps of Managing a Recovery CatalogCreating a Recovery CatalogConfiguring the Recovery Catalog DatabaseCreating the Recovery Catalog Schema OwnerExecuting the CREATE CATALOG CommandRegistering a Database in the Recovery CatalogAbout Registration of a Database in the Recovery CatalogRegistering a Database with the REGISTER DATABASE CommandCataloging Backups in the Recovery CatalogCreating and Managing Virtual Private CatalogsAbout Virtual Private CatalogsCreating and Granting Privileges to a Virtual Private Catalog OwnerCreating a Virtual Private CatalogRevoking Privileges from a Virtual Private Catalog OwnerDropping a Virtual Private CatalogProtecting the Recovery CatalogBacking Up the Recovery CatalogRecovering the Recovery CatalogManaging Stored ScriptsAbout Stored ScriptsCreating Stored ScriptsReplacing Stored ScriptsExecuting Stored ScriptsCreating and Executing Dynamic Stored ScriptsPrinting Stored ScriptsListing Stored Script NamesDeleting Stored ScriptsExecuting a Stored Script at RMAN StartupMaintaining a Recovery CatalogAbout Recovery Catalog MaintenanceResynchronizing the Recovery CatalogUpdating the Recovery Catalog After Changing a DB_UNIQUE_NAMEUnregistering a Target Database from the Recovery CatalogResetting the Database Incarnation in the Recovery CatalogUpgrading the Recovery CatalogImporting and Moving a Recovery CatalogDropping a Recovery CatalogPart V Diagnosing and Responding to Failures13 RMAN Data Repair ConceptsOverview of RMAN Data RepairProblems Requiring Data RepairRMAN Data Repair TechniquesRMAN Restore OperationsBackup SelectionRestore FailoverRestore OptimizationRMAN Media RecoverySelection of Incremental Backups and Archived Redo LogsDatabase Incarnations14 Diagnosing and Repairing Failures with Data Recovery AdvisorOverview of Data Recovery AdvisorPurpose of Data Recovery AdvisorBasic Concepts of Data Recovery AdvisorBasic Steps of Diagnosing and Repairing FailuresListing FailuresListing All FailuresListing a Subset of FailuresChecking for Block Corruptions by Validating the DatabaseDetermining Repair OptionsDetermining Repair Options for All FailuresDetermining Repair Options for a Subset of FailuresAbout Repairing FailuresRepairing a FailureChanging Failure Status and Priority15 Validating Database Files and BackupsOverview of RMAN ValidationPurpose of RMAN ValidationBasic Concepts of RMAN ValidationChecking for Block Corruption with the VALIDATE CommandParallelizing the Validation of a DatafileValidating Database Files with BACKUP VALIDATEValidating Backups Before Restoring Them16 Performing Flashback and Database Point-in-Time RecoveryOverview of Flashback Technology and Database Point-in-Time RecoveryPurpose of Flashback and Database Point-in-Time-RecoveryBasic Concepts of Point-in-Time Recovery and Flashback FeaturesRewinding a Table with Flashback TablePrerequisites for Flashback TablePerforming a Flashback Table OperationRewinding a DROP TABLE Operation with Flashback DropAbout Flashback DropPrerequisites of Flashback DropPerforming a Flashback Drop OperationPrerequisites of Flashback DatabasePerforming a Flashback Database OperationPerforming Database Point-in-Time RecoveryPrerequisites of Database Point-in-Time RecoveryFlashback and Database Point-in-Time Recovery ScenariosRewinding an OPEN RESETLOGS Operation with Flashback DatabaseRewinding the Database to an SCN in an Abandoned Incarnation BranchRecovering the Database to an Ancestor Incarnation17 Performing Complete Database RecoveryOverview of Complete Database RecoveryPurpose of Complete Database RecoveryScope of This ChapterPreparing for Complete Database RecoveryIdentifying the Database Files to Restore or RecoverDetermining the DBID of the DatabasePreviewing Backups Used in Restore OperationsRestoring Archived Redo Logs Needed for RecoveryPerforming Complete Database RecoveryAbout Complete Database RecoveryPerforming Complete Recovery of the Whole DatabasePerforming Complete Recovery of a TablespacePerforming Complete Recovery After Switching to a Copy18 Performing Block Media RecoveryOverview of Block Media RecoveryPurpose of Block Media RecoveryBasic Concepts of Block Media RecoveryPrerequisites for Block Media RecoveryRecovering Individual BlocksRecovering All Blocks in V$DATABASE_BLOCK_CORRUPTION19 Performing RMAN Recovery: Advanced ScenariosRecovering a NOARCHIVELOG Database with Incremental BackupsRestoring the Server Parameter FileRestoring the Server Parameter File from a Control File AutobackupCreating an Initialization Parameter File with RMANPerforming Recovery with a Backup Control FileAbout Recovery with a Backup Control FilePerforming Recovery with a Backup Control File and No Recovery CatalogPerforming Disaster RecoveryPrerequisites of Disaster RecoveryRecovering the Database After a DisasterRestoring a Database on a New HostPreparing to Restore a Database on a New HostTesting the Restore of a Database on a New Host20 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)Overview of RMAN TSPITRPurpose of RMAN TSPTIRBasic Concepts of RMAN TSPITRBasic Steps of RMAN TSPITRPrerequisites and Consequences of TSPITRConsequences of TSPITRSpecial Considerations When Not Using a Recovery CatalogPlanning and Preparing for TSPITRChoosing the Right Target Time for TSPITRDetermining the Recovery SetIdentifying and Preserving Objects That Will Be Lost After TSPITRPerforming Fully Automated RMAN TSPITRPerforming Customized RMAN TSPITR with an RMAN-Managed Auxiliary Instance 20-10Renaming Oracle Managed Files in TSPITRRenaming TSPITR Recovery Set Datafiles with SET NEWNAMENaming TSPITR Auxiliary Set DatafilesUsing Image Copies for Faster RMAN TSPITR PerformanceCustomizing Initialization Parameters for the Automatic Auxiliary Instance in TSPITRPerforming RMAN TSPITR Using Your Own Auxiliary InstancePreparing Your Own Auxiliary Instance for RMAN TSPITRPreparing RMAN Commands for TSPITR with Your Own Auxiliary InstanceExecuting TSPITR with Your Own Auxiliary InstancePerforming TSPITR with Your Own Auxiliary Instance: ScenarioTroubleshooting RMAN TSPITRTroubleshooting Filename ConflictsTroubleshooting Identification of Tablespaces with Undo SegmentsTroubleshooting the Restart of a Manual Auxiliary Instance After TSPITR FailurePart VI Tuning and Troubleshooting21 Tuning RMAN PerformancePurpose of RMAN Performance TuningBasic Concepts of RMAN Performance TuningRead PhaseCopy PhaseWrite Phase for SBTWrite Phase for DiskUsing V$ Views to Diagnose RMAN Performance ProblemsMonitoring RMAN Job Progress with V$SESSION_LONGOPSIdentifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IOTuning RMAN Backup PerformanceStep 1: Remove the RATE Parameter from Channel SettingsStep 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVESStep 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZEStep 4: Tune the Read, Write, and Copy Phases22 Troubleshooting RMAN OperationsInterpreting RMAN Message OutputIdentifying Types of Message OutputRecognizing RMAN Error Message StacksIdentifying Error CodesInterpreting RMAN Error StacksIdentifying RMAN Return CodesUsing V$ Views for RMAN TroubleshootingMonitoring RMAN Interaction with the Media ManagerCorrelating Server Sessions with RMAN ChannelsTesting the Media Management APIObtaining the sbttest UtilityObtaining Online Documentation for the sbttest UtilityUsing the sbttest UtilityTerminating an RMAN CommandTerminating the Session with ALTER SYSTEM KILL SESSIONTerminating the Session at the Operating System LevelTerminating an RMAN Session That Is Hung in the Media ManagerPart VII Transferring Data with RMAN23 Duplicating a DatabaseOverview of RMAN Database DuplicationPurpose of Database DuplicationBasic Concepts of Database DuplicationBasic Steps of Database DuplicationMaking Backups and Archived Logs Accessible to the Duplicate InstanceMaking SBT Backups Accessible to the Duplicate InstanceMaking Disk Backups Accessible to the Duplicate InstanceChoosing a Strategy for Naming Duplicate FilesPreparing the Auxiliary InstanceStep 1: Create an Oracle Password File for the Auxiliary InstanceStep 2: Establish Oracle Net Connectivity to the Auxiliary InstanceStep 3: Create an Initialization Parameter File for the Auxiliary InstanceStep 4: Start the Auxiliary Instance with SQL*PlusStarting and Configuring RMAN Before DuplicationStep 1: Start RMAN and Connect to the Database InstancesStep 2: Mount or Open the Source DatabaseStep 3: Configure RMAN Channels for Use in the DuplicationDuplicating a DatabaseDuplicating a Database to a Remote Host with the Same Directory StructureDuplicating a Database to a Remote Host with a Different Directory StructureCreating a Duplicate Database on the Local HostDuplicating a Database with Oracle Managed Files or Automatic Storage ManagementNaming Duplicate Files with Alternative TechniquesNaming Duplicate Control FilesNaming Duplicate Online Redo Log FilesNaming Duplicate DatafilesNaming Duplicate TempfilesRMAN Duplication ScenariosDuplicating a Subset of the Source Database TablespacesUsing DUPLICATE to Restore an Archival BackupUsing SET NEWNAME to Name Duplicate FilesUsing CONFIGURE AUXNAME to Name Duplicate Files24 Creating Transportable Tablespace SetsOverview of Creating Transportable Tablespace SetsPurpose of Creating Transportable Tablespace SetsBasic Concepts of Transportable Tablespace SetsBasic Steps of Creating Transportable Tablespace SetsCustomizing Initialization Parameters for the Auxiliary InstanceSetting Initialization Parameters for the Auxiliary InstanceSetting the Location of the Auxiliary Instance Parameter FileCreating a Transportable Tablespace SetTroubleshooting Creation of Transportable Tablespace SetsTransportable Tablespace Set ScenariosCreating a Transportable Tablespace Set at a Specified Time or SCNSpecifying Locations for Data Pump FilesSpecifying Auxiliary File Locations25 Transporting Data Across PlatformsOverview of Cross-Platform Data TransportationPurpose of Cross-Platform Data TransportationBasic Concepts of Cross-Platform Data TransportationPerforming Cross-Platform Tablespace Conversion on the Source HostPerforming Cross-Platform Datafile Conversion on the Destination HostAbout Cross-Platform Datafile Conversion on the Destination HostUsing CONVERT DATAFILE to Convert Datafile FormatsChecking the Database Before Cross-Platform Database ConversionConverting Datafiles on the Source Host When Transporting a DatabaseConverting Datafiles on the Destination Host When Transporting the DatabasePerforming Preliminary Datafile Conversion Steps on the Source HostConverting Datafiles on the Destination Host26 Performing ASM Data MigrationOverview of ASM Data MigrationPurpose of ASM Data MigrationBasic Concepts of ASM Data MigrationBasics Steps of Data Migration to ASMPreparing to Migrate the Database to ASMMigrating the Database to ASMMigrating a Database from ASM to Alternative StorageMoving Datafiles Between ASM Disk Groups27 Making User-Managed Database BackupsQuerying V$ Views to Obtain Backup InformationListing Database Files Before a BackupDetermining Datafile Status for Online Tablespace BackupsMaking User-Managed Backups of the Whole DatabaseMaking Consistent Whole Database BackupsMaking User-Managed Backups of Tablespaces and DatafilesMaking User-Managed Backups of Offline Tablespaces and DatafilesMaking User-Managed Backups of Online Tablespaces and DatafilesMaking User-Managed Backups of the Control FileBacking Up the Control File to a Binary FileBacking Up the Control File to a Trace FileMaking User-Managed Backups of Archived Redo LogsMaking User-Managed Backups in SUSPEND ModeAbout the Suspend/Resume FeatureMaking Backups in a Suspended DatabaseMaking User-Managed Backups to Raw DevicesBacking Up to Raw Devices on Linux and UNIXBacking Up to Raw Devices on WindowsMaking Backups with the Volume Shadow Copy Service (VSS)Verifying User-Managed Datafile BackupsTesting the Restore of Datafile BackupsRunning the DBVERIFY Utility28 Performing User-Managed Database Flashback and RecoveryPerforming Flashback Database with SQL*PlusOverview of User-Managed Media RecoveryAbout User-Managed Restore and RecoveryAutomatic Recovery with the RECOVER CommandRecovery When Archived Logs Are in the Default LocationRecovery When Archived Logs Are in a Nondefault LocationRecovery CancellationParallel Media RecoveryPerforming Closed Database RecoveryPerforming Open Database RecoveryPerforming Incomplete Database RecoveryPerforming Cancel-Based Incomplete RecoveryPerforming Time-Based or Change-Based Incomplete RecoveryRecovering a Database in NOARCHIVELOG ModeTroubleshooting Media RecoveryAbout User-Managed Media Recovery ProblemsInvestigating the Media Recovery Problem: Phase 1Trying to Fix the Recovery Problem Without Corrupting Blocks: Phase 2Deciding Whether to Allow Recovery to Corrupt Blocks: Phase 3Allowing Recovery to Corrupt Blocks: Phase 4Performing Trial Recovery29 Performing User-Managed Recovery: Advanced ScenariosResponding to the Loss of a Subset of the Current Control FilesCopying a Multiplexed Control File to a Default LocationCopying a Multiplexed Control File to a Nondefault LocationRecovering After Loss of All Current Control FilesRecovering with a Backup Control File in the Default LocationRecovering with a Backup Control File in a Nondefault LocationRecovering Through an Added Datafile with a Backup Control FileRecovering Read-Only Tablespaces with a Backup Control FileRe-Creating a Control FileRecovering Through a RESETLOGS with a Created Control FileRecovery of Read-Only Files with a Re-Created Control FileRe-Creating Datafiles When Backups Are UnavailableRecovering NOLOGGING Tables and IndexesRecovering Transportable TablespacesRecovering After the Loss of Online Redo Log FilesRecovering After Losing a Member of a Multiplexed Online Redo Log GroupRecovering After the Loss of All Members of an Online Redo Log GroupRecovering from a Dropped Table Without Using Flashback FeaturesDropping a Database with SQL*Plus