Backup And Recovery User's Guide - Oracle
Oracle DatabaseBackup and Recovery User's Guide21cF31836-04April 2021
Oracle Database Backup and Recovery User's Guide, 21cF31836-04Copyright 2003, 2021, Oracle and/or its affiliates.Primary Author: Padmaja PotineniContributors: K. Weill, L. Ashdown, T. Bednar, A. Beldalker, T. Chien, M. Dilman, S. Fogel, R. Guzman, S.Haisley, W. Hu, A. Hwang, A. Joshi, V. Krishnaswamy, J. W. Lee, V. Moore, M. Olagappan, V. Panteleenko,S. Ranganathan, F. Sanchez, Kelly D. Smith, V. Srihari, M. Susairaj, M. Stewart, S. Wertheimer, W. Yang, R.ZijlstraThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Governmentend users are "commercial computer software" or "commercial computer software documentation" pursuantto the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works,and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will notbe responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPrefaceAudiencexxxivDocumentation AccessibilityxxxivRelated DocumentationxxxivConventionsxxxvPart I1Overview of Backup and RecoveryIntroduction to Backup and Recovery1.1Purpose of Backup and Recovery1-11.1.1About Data Protection1-11.1.2About Failures that Require Database Recovery1-31.1.3About Data Archival1-41.1.4About Data Transfer1-41.2Oracle Backup and Recovery Solutions1-41.3Comparison of Oracle Backup Techniques1-51.4About Oracle Flashback Technology1-61.4.1Logical Flashback Features1-61.4.2Flashback Database1-81.5About Data Recovery Advisor1-81.6RMAN and Oracle Enterprise Manager Cloud Control1-91.71.6.1About Oracle Enterprise Manager Cloud Control1.6.2Accessing the Database Home Page Using Cloud Control1-101.6.3Performing Backup and Recovery Tasks with Cloud Control1-10About Zero Data Loss Recovery Appliance1.7.11.8Using RMAN with Recovery ApplianceBackup and Recovery Documentation Roadmap1-91-111-121-121.8.1Recovery Manager Documentation Roadmap1-131.8.2User-Managed Backup and Recovery Documentation Roadmap1-14iii
2Getting Started with RMAN2.1Overview of the RMAN Environment2-12.2Starting RMAN and Connecting to a Database: Quick Start2-22.3Showing the Default RMAN Configuration2-32.4Backing Up a Database: Quick Start2-42.52.62.7About Typical RMAN Backup Options2-52.4.2Backing Up a Database in ARCHIVELOG Mode2-52.4.3Backing Up a Database in NOARCHIVELOG Mode2-62.4.4Making Incremental Backups: Quick Start2-62.4.5Making Incrementally Updated Backups2-72.4.6Validating Database Files and Backups: Quick Start2-92.4.7Scripting RMAN Operations2-9Reporting on RMAN Operations: Quick Start2-102.5.1Listing Backups: Quick Start2-102.5.2Reporting on Database Files and Backups: Quick Start2-11Maintaining RMAN Backups2-122.6.1Cross-checking Backups: Quick Start2-132.6.2Deleting Obsolete Backups: Quick Start2-13Diagnosing and Repairing Failures with Data Recovery Advisor: Quick Start2-142.7.1Listing Failures and Determining Repair Options2-142.7.2Repairing Failures: Quick Start2-152.8Rewinding a Database with Flashback Database: Quick Start2-162.9Restoring and Recovering Database Files: Quick Start2-17Part II32.4.12.9.1Preparing to Restore and Recover Database Files: Quick Start2-172.9.2Recovering the Whole Database: Quick Start2-182.9.3Recovering Tablespaces: Quick Start2-192.9.4Recovering Individual Data Blocks: Quick Start2-20Starting and Configuring RMAN and Flashback DatabaseRecovery Manager Architecture3.1About the RMAN Environment3-13.2About RMAN Command-Line Client3-33.3About RMAN Channels3-33.3.1About RMAN Channels and Devices3-43.3.2About RMAN Automatic and Manual Channels3-53.4About the RMAN Repository3-53.5About Media Management Using RMAN3-63.5.1About RMAN Interaction with a Media Manager3-7iv
3.5.2About RMAN and Oracle Secure Backup3-73.5.3About the Backup Solutions Program3-73.6About the Fast Recovery Area3-83.7About RMAN in a Data Guard Environment3-83.83.7.1About RMAN Configuration in a Data Guard Environment3-93.7.2About RMAN File Management in a Data Guard Environment3-93.7.2.1About Interchangeability of Backups in a Data Guard Environment3.7.2.2About Association of Backups in a Data Guard Environment3-103.7.2.3About Accessibility of Backups in a Data Guard Environment3-10About RMAN in a Recovery Appliance Environment3.8.14Creating RMAN Backups to Recovery Appliance3-93-113-11Starting and Interacting with the RMAN Client4.1Starting and Exiting RMAN4-14.2Making Database Connections with RMAN4-14.2.1About RMAN Database Connection Types4-14.2.2About Authentication for RMAN Database Connections4-24.2.2.1Authentication Using the Operating System4-34.2.2.2Authentication Using a Password File4-3Methods of Making RMAN Database Connections4-44.2.34.2.3.1Making Database Connections from the RMAN Prompt4-44.2.3.2Making RMAN Connections from the Operating SystemCommand Line4-54.2.4About Performing Operations on CDBs and PDBs4-64.2.5Connecting as Target to the Root4-74.2.6Connecting as Target to a PDB4-94.2.6.14.34.4Restrictions When Connected to a PDB4-94.2.7Connecting RMAN to an Auxiliary Database4-104.2.8Making RMAN Database Connections Within Command Files4-11Diagnosing RMAN Connection Problems4-114.3.1Diagnosing Target and Auxiliary Database Connection Problems4-124.3.2Diagnosing Recovery Catalog Connection Problems4-12Entering RMAN Commands4-124.4.1Entering RMAN Commands at the RMAN Prompt4-124.4.2Using Command Files with RMAN4-134.4.3Entering Comments in RMAN Command Files4-144.4.4Using Substitution Variables in Command Files4-144.5Setting Globalization Support Environment Variables for RMAN4-154.6Specifying the Location of RMAN Output4-164.7Checking RMAN Syntax4-164.7.1Checking RMAN Syntax at the Command Line4-17v
4.7.24.8Using the RMAN Pipe Interface4.8.14.8.25Checking RMAN Syntax in Command Files4-174-18Executing Multiple RMAN Commands in Succession Through a Pipe:Example4-19Executing RMAN Commands in a Single Job Through a Pipe: Example4-20Configuring the RMAN Environment5.1About Configuring the Environment for RMAN Backups5-15.2Showing and Clearing Persistent RMAN Configurations5-25.3Configuring the Default Device for Backups: Disk or SBT5-35.4Configuring the Default Type for Backups: Backup Sets or Copies5-45.5Configuring Channels5-55.5.1About Channel Configuration5-55.5.2Configuring Channels for Disk5-65.5.3Configuring Parallel Channels for Disk and SBT Devices5-75.5.4Manually Overriding Configured Channels5-85.6Configuring Control File and Server Parameter File Autobackups5.6.1Configuring the Control File Autobackup Format5.6.2Overriding the Configured Control File Autobackup Format5.7Configuring RMAN to Make Backups to a Media Manager5-95-95-115-115.7.1Prerequisites for Using a Media Manager with RMAN5-125.7.2Determining the Location of the Media Management Library5-125.7.3Configuring Media Management Software for RMAN Backups5-145.7.4Testing Whether the Media Manager Library Is Integrated Correctly5-145.7.4.1Testing ALLOCATE CHANNEL on the Media Manager5-155.7.4.2Testing Backup and Restore Operations on the Media Manager5-165.7.55.8Configuring SBT Channels for Use with a Media Manager5-175.7.5.1About Media Manager Backup Piece Names5-175.7.5.2Configuring Automatic SBT Channels5-18Configuring RMAN to Make Backups to Recovery Appliance5-195.8.1Prerequisites for Using Recovery Appliance5-195.8.2Steps to Configure RMAN for Backups to Recovery Appliance5-195.8.3Determining the Location of the Recovery Appliance Backup Module5-205.8.4Specifying Recovery Appliance Configuration Settings for RMANBackups5-215.9Configuring Locations for Control Files and Redo Logs5-215.9.1Configuring Online Redo Log Locations5-215.9.2Configuring Control File Locations5-225.9.3Configuring Archived Redo Log Locations5-225.10Configuring the Fast Recovery Area5.10.1Overview of Files in the Fast Recovery Area5-235-24vi
5.10.1.15.10.1.25.10.25-25How Oracle Manages Disk Space in the Fast Recovery Area5-26Enabling the Fast Recovery Area5-265.10.2.1Considerations When Setting the Size of the Fast Recovery Area5-285.10.2.2Considerations When Setting the Location of the Fast RecoveryArea5-29Setting the Fast Recovery Area Location and Initial Size5-295.10.2.35.10.3Disabling the Fast Recovery Area5-315.10.4Configuring RMAN File Creation in the Fast Recovery Area5-315.11Configuring the Backup Retention Policy5-325.11.1Configuring a Redundancy-Based Retention Policy5-335.11.2Configuring a Recovery Window-Based Retention Policy5-335.11.3Disabling the Retention Policy5-345.12Backup Optimization and the CONFIGURE command5-345.12.1Overview of Backup Optimization5-355.12.2Effect of Retention Policies on Backup Optimization for SBT Backups5-365.12.2.15.12.2.25.12.35.135-36About Backup Optimization for SBT Backups With RedundancyRetention Policy5-37Configuring Backup OptimizationAbout Archived Redo Log Deletion Policies5-385-395-395.13.1.1When the Archived Redo Log Deletion Policy Is Disabled5-395.13.1.2When the Archived Redo Log Deletion Policy Is Enabled5-405.13.25.14About Backup Optimization for SBT Backups with RecoveryWindow Retention PolicyConfiguring an Archived Redo Log Deletion Policy5.13.16Fast Recovery Area with Oracle Managed Files and AutomaticStorage ManagementEnabling an Archived Redo Log Deletion PolicyConfiguring RMAN in a Data Guard Environment5-405-41Configuring the RMAN Environment: Advanced Topics6.16.2Configuring Advanced Channel Options6-16.1.1About Channel Control Options6-16.1.2Configuring Specific Channel Parameters6-26.1.2.1Configuring Specific Channels: Examples6-36.1.2.2Relationship Between CONFIGURE CHANNEL and ParallelismSetting6-3Configuring Advanced Backup Options6-46.2.1Configuring the Maximum Size of Backup Sets6-46.2.2Configuring the Maximum Size of Backup Pieces6-56.2.3Configuring Backup Duplexing6-66.2.4Configuring Tablespaces for Exclusion from Whole Database Backups6-76.2.5Configuring Compression Options6-8vii
6.2.5.1About RMAN Precompression Block Processing6-86.2.5.2About RMAN Supported Compression Levels6-86.2.67Configuring Backup Encryption6-106.2.6.1About Backup Encryption6-106.2.6.2Configuring RMAN Backup Encryption Modes6-136.2.6.3Configuring the Backup Encryption Algorithm6-146.3Configuring Auxiliary Instance Data File Names6-146.4Configuring the Snapshot Control File Location6-156.4.1Viewing the Configured Location of the Snapshot Control File6-166.4.2Setting the Location of the Snapshot Control File6-166.5Configuring RMAN for Use with a Shared Server6-176.6Enabling Lost Write Detection6-186.7Enabling Shadow Lost Write Protection6-19Using Flashback Database and Restore Points7.1Overview of Flashback Database, Restore Points and Guaranteed RestorePoints7.1.1About Flashback Database7-27.1.2About Flashback Database Window7-27.1.3Limitations of Flashback Database7-37.1.4About Normal Restore Points7-47.1.5About Guaranteed Restore Points7-57.1.5.17.1.67.27-1Guaranteed Restore Points versus Storage SnapshotsOverview of Restore Points in a Multitenant Environment7-57-67.1.6.1About CDB Restore Points7-67.1.6.2About Restore Points in PDBs7-77.1.6.3About the Namespace for PDB Restore Points7-8About Logging for Flashback Database and Guaranteed Restore Points7-87.2.1Guaranteed Restore Points and Fast Recovery Area Space Usage7.2.2About Logging for Guaranteed Restore Points with Flashback LoggingDisabled7-10About Logging for Flashback Database with Guaranteed Restore PointsDefined7-107.2.37-87.3Prerequisites for Flashback Database and Restore Points7-117.4Using Normal and Guaranteed Restore Points7-117.57.4.1Creating CDB Restore Points7-127.4.2Creating PDB Restore Points7-127.4.3Listing Restore Points Using the LIST Command7-147.4.4Listing Restore Points Using the V RESTORE POINT View7-157.4.5Dropping Restore Points7-16Using Flashback Database7-17viii
Part III87.5.1Enabling Flashback Database7-177.5.2Disabling Flashback Database Logging7-197.5.3Configuring the Environment for Optimal Flashback DatabasePerformance7-197.5.4Monitoring the Effect of Flashback Database on Performance7-197.5.5About Flashback Writer (RVWR) Behavior with I/O Errors7-21Backing Up and Archiving DataRMAN Backup Concepts8.1About Consistent and Inconsistent RMAN Backups8-18.1.1About Consistent RMAN Backups8-18.1.2About Inconsistent RMAN Backups8-28.2About Online Backups and Backup Mode8-28.3About Backup Sets8-38.3.1About Backup Sets and Backup Pieces8-38.3.2About RMAN Block Compression for Backup Sets8-48.3.2.1About Unused Block Compression8-48.3.2.2About Null Block Compression8-58.3.3About Binary Compression for RMAN Backup Sets8-58.3.4About RMAN Backup Undo Optimization8-58.3.5About Encryption for RMAN Backup Sets8-68.3.6About File Names for RMAN Backup Pieces8-68.3.7About Number and Size of RMAN Backup Pieces8-78.3.8About Number and Size of RMAN Backup Sets8-88.3.9About Multiplexed RMAN Backup Sets8-88.3.108.4About RMAN Proxy CopiesAbout RMAN Image Copies8-108-108.4.1About RMAN-Created Image Copies8-118.4.2About User-Managed Image Copies8-128.5About Sparse Backups8-128.6About Preplugin Backups8-138.7About Multiple Copies of RMAN Backups8-148.88.7.1About Duplexed Backup Sets8-148.7.2About Backups of RMAN Backups8-158.7.2.1Backups of Backup Sets8-158.7.2.2Backups of Image Copies8-16About RMAN Control File and Server Parameter File Autobackups8-168.8.1When RMAN Performs Control File Autobackups8-178.8.2How RMAN Performs Control File Autobackups8-17ix
8.9About RMAN Incremental Backups8.9.18-188.9.1.1About Differential Incremental Backups8-198.9.1.2About Cumulative Incremental Backups8-208.9.2About Block Change Tracking8-218.9.3About the Incremental Backup Algorithm8-228.9.4About Recovery with Incremental Backups8-228.9.5About the Incremental-Forever Backup Strategy for Recovery Appliance8-238.109About Multilevel Incremental Backups8-18About Backup Retention Policies8-238.10.1About the Recovery Window8-248.10.2About Backup Redundancy8-268.10.3About Batch Deletes of Obsolete Backups8-278.10.4About Backup Retention Policy and Fast Recovery Area DeletionRules8-27Backing Up the Database9.19.2Overview of RMAN Backups9.1.1Purpose of RMAN Backups9-19.1.2Basic Concepts of RMAN Backups9-1Specifying Backup Output Options9-29.2.1Specifying the Device Type for an RMAN Backup9-39.2.2Specifying Backup Set or Copy for an RMAN Backup to Disk9-39.2.3Specifying a Format for RMAN Backups9-49.2.3.19.2.49.39-1Specifying Multiple Formats for Disk BackupsSpecifying Tags for an RMAN Backup9-59-59.2.4.1About Backup Tags9-69.2.4.2Specifying Tags for Backup Sets and Image Copies9-69.2.5Making Compressed Backups9-79.2.6Specifying Multisection Incremental Backups9-89.2.7Making Multisection Backups Using Image CopiesBacking Up Database Files with RMAN9-109-109.3.1Backing Up a Whole CDB9-119.3.2Backing Up the Root with RMAN9-129.3.3Backing Up the Root with Oracle Enterprise Manager Cloud Control9-129.3.4Backing Up PDBs with RMAN9-139.3.5Backing Up PDBs with Oracle Enterprise Manager Cloud Control9-149.3.6Backing Up Tablespaces and Data Files with RMAN9-149.3.7Backing Up Tablespaces and Data Files in a PDB9-159.3.8Backing Up Control Files with RMAN9-169.3.8.1About Manual Backups of the Control File9-179.3.8.2Making a Manual Backup of the Control File9-18x
9.3.9Backing Up Server Parameter Files with RMAN9.3.10Backing Up a Database in NOARCHIVELOG Mode9-199.3.11Creating a Preplugin Backup of the Whole Database9-209.3.12Creating Preplugin Backups of PDBs Using RMAN9-219.3.12.19.49.59.69-229-239.4.1About Backing Up Application Containers9-239.4.2Backing Up the Application Root9-249.4.3Backing Up the Application Root and its Application PDBs9-249.4.4Backing Up Application PDBs9-25Backing Up Sparse Databases with RMAN9-259.5.1Backing Up a Sparse Database with RMAN9-269.5.2Backing Up Sparse Tablespaces and Data Files with RMAN9-279.5.3Backing Up a Sparse PDB with RMAN9-28Backing Up Archived Redo Logs with RMAN9-29About Backups of Archived Redo Logs9-299.6.1.1About Archived Redo Log Failover9-299.6.1.2About Online Redo Log Switching9-309.6.2Backing Up Archived Redo Log Files9-319.6.3Backing Up Only Archived Redo Logs That Need Backups9-319.6.4Deleting Archived Redo Logs After Backups9-32Making and Updating RMAN Incremental Backups9-339.7.1Purpose of RMAN Incremental Backups9-349.7.2Planning an Incremental Backup Strategy9-349.7.3Making Incremental Backups9-359.7.3.19.7.49.8Example: Creating a Preplugin Backup of a PDB with RMANBacking Up Application Containers9.6.19.79-19Making Incremental Backups of a VSS SnapshotIncrementally Updating Backups9-369-379.7.4.1Incrementally Updating Backups: Basic Example9-379.7.4.2Incrementally Updated Backups: Advanced Example9-399.7.5Creating a Base Backup of New Data Files9-409.7.6Using Block Change Tracking to Improve Incremental BackupPerformance9-419.7.6.1About Block Change Tracking9-419.7.6.2Enabling and Disabling Block Change Tracking9-439.7.6.3Disabling Block Change Tracking9-449.7.6.4Checking Whether Change Tracking Is Enabled9-449.7.6.5Changing the Location of the Block Change Tracking File9-44Making Database Backups for Long-Term Storage9-459.8.1Purpose of Archival Backups9-469.8.2Basic Concepts of Archival Backups9-469.8.3Making an Archival Backup for Long-Term Storage9-47xi
9.8.3.19.8.49.9Making a Temporary Archival BackupBacking Up RMAN Backups9.9.110Making an Archival BackupAbout Backups of RMAN Backups9-479-499-499-499.9.1.1About Multiple Copies of RMAN Backup Sets9-509.9.1.2Viewing the Effect of a Backup Retention Policy on Backups ofBackups9-509.9.2Backing Up Backup Sets with RMAN9-529.9.3Backing Up Image Copy Backups with RMAN9-53Backing Up the Database: Advanced Topics10.1Limiting the Size of RMAN Backup Sets10-110.1.1About Backup Set Size10-110.1.2Limiting the Size of Backup Sets with BACKUP . MAXSETSIZE10-210.1.3Dividing the Backup of a Large Data File into Sections10-310.2Using Backup Optimization to Skip Files10-410.2.1Optimizing a Daily Archived Log Backup to a Single Tape: Scenario10-510.2.2Optimizing a Daily Archived Log Backup to Multiple Media Families:Scenario10-5Creating a Weekly Secondary Backup of Archived Logs: Example10-610.2.310.3Skipping Offline, Read-Only, and Inaccessible Files10-710.4Duplexing Backup Sets10-810.4.1Duplexing Backup Sets with CONFIGURE BACKUP COPIES10.4.2Duplexing Backup Sets with BACKUP . COPIES10-910-1010.5Making Split Mirror Backups with RMAN10-1010.6Encrypting RMAN Backups10-1210.6.1About RMAN Backup Encryption Settings10-1210.6.2Making Transparent-Mode Encrypted Backups10-1410.6.3Making Password-Mode Encrypted Backups10-1410.6.4Making Dual-Mode Encrypted Backups10-1510.7Restarting RMAN Backups10-1510.7.1About Restartable Backups10-1510.7.2Restarting a Backup After It Partially Completes10-1610.8Managing Backup Windows10-1710.8.1About Backup Windows10-1710.8.2Specifying a Backup Duration10-1710.8.3Permitting Partial Backups in a Backup Window10-1810.8.4Minimizing Backup Load and Duration10-18xii
Part IV11Managing RMAN BackupsReporting on RMAN Operations11.1Overview of RMAN Reporting11.1.1Purpose of RMAN Reporting11-111.1.2Basic Concepts of RMAN Reporting11-111.1.3Reporting in a Data Guard Environment11-311.2Listing Backups and Recovery-Related Objects11-311.2.1About the LIST Command11-411.2.2Listing All Backups and Copies11-611.2.3Listing Selected Backups and Copies11-911.2.4Listing Backups of Dropped PDBs11-1111.2.5Listing Preplugin Backups11-1111.2.6Listing Database Incarnations11-1211.3Reporting on Backups and Database Schema11-1311.3.1About Reports of RMAN Backups11-1311.3.2Reporting on Files Needing a Backup Under a Retention Policy11-1411.3.2.111.3.2.211.3.2.3Using RMAN REPORT NEED BACKUP with Different RetentionPolicies11-15Using RMAN REPORT NEED BACKUP with Tablespaces andData Files11-15Using REPORT NEED BACKUP with Backups on Tape or DiskOnly11-1611.3.3Reporting on Data Files Affected by Unrecoverable Operations11-1611.3.4Reporting on Obsolete Backups11-1711.3.5Reporting on the Database Schema11-1811.4Using V Views to Query Backup Metadata11-2011.4.1Querying Details of Past and Current RMAN Jobs11-2011.4.2Determining the Encryption Status of Backup Pieces11-2211.5Querying Recovery Catalog Views11.5.11211-1About Recovery Catalog Views11-2311-2311.5.1.1About Unique Identifiers for Registered Databases11-2411.5.1.2About Unique Identifiers in a Data Guard Environment11-2411.5.2Querying Catalog Views for the Target DB KEY or DBID Values11-2511.5.3Querying RC BACKUP FILES11-26Maintaining RMAN Backups and Repository Records12.1Overview of RMAN Backup and Repository Maintenance12-112.1.1Purpose of Backup and Repository Maintenance12-112.1.2Basic Concepts of Backup and Repository Maintenance12-2xiii
12.212.1.2.1About Maintenance Commands and RMAN Repository Metadata12-212.1.2.2About Maintenance Commands in a Data Guard Environment12-2Maintaining the Control File Repository12.2.1About Control File Records12.2.1.1About Fast Recovery Area and Control File Records12-312-412-512.2.2Preventing the Loss of Control File Records12-612.2.3Protecting the Control File12-612.3Maintaining the Fast Recovery Area12-712.3.1Deletion Rules for the Fast Recovery Area12-712.3.2Monitoring Fast Recovery Area Space Usage12-812.3.3Managing Space for Flashback Logs in the Fast Recovery Area12-912.3.4Responding to a Full Fast Recovery Area12-1012.3.5Changing the Fast Recovery Area to a New Location12-1112.3.6Disabling the Fast Recovery Area12-1212.3.7Responding to an Instance Crash During File Creation12-1212.4Updating the RMAN Repository12.4.112-1212.4.1.1About RMAN Crosschecks12-1312.4.1.2Crosschecking All Backups and Copies12-1412.4.1.3Crosschecking Specific Backup Sets and Copies12-1512.4.1.4Crosschecking Preplugin Backups12-1612.4.2Changing the Repository Status of Backups and Copies12-1612.4.2.1Updating a Backup to Status AVAILABLE or UNAVAILABLE12-1712.4.2.2Changing the Status of an Archival Backup12-1812.4.2.3Changing the Status of Backups for Dropped PDBs12-1912.4.2.4Changing the Status of Preplugin Backups12-1912.4.3Adding Backup Records to the RMAN Repository12-2012.4.3.1About Cataloging Operations12-2012.4.3.2Cataloging User-Managed Data File Copies12-2112.4.3.3Cataloging Backup Pieces12-2212.4.3.4Cataloging All Files in a Disk Location12-2212.4.3.5Cataloging Preplugin Archived Redo Logs12-2312.4.412.5Crosschecking the RMAN Repository12-12Removing Records from the RMAN Repository12-2412.4.4.1About Uncataloging Operations in the RMAN Repository12-2412.4.4.2Removing Records for Files Deleted with Operating SystemUtilities12-24Deleting RMAN Backups and Archived Redo Logs12.5.1Overview of Deleting RMAN Backups12-2512-2512.5.1.1About RMAN Deletion Commands12-2612.5.1.2About Deletion of Archived Redo Logs12-2712.5.2Deleting All Backups and Copies12-28xiv
12.5.3Deleting Specified Backups and Copies12.5.3.112-3012.5.4Deleting Expired RMAN Backups and Copies12-3012.5.5Deleting Obsolete RMAN Backups Based on Retention Policies12-3112.5.5.1DELETE OBSOLETE Behavior When KEEP UNTIL TIMEExpires12-3112.5.6Deleting Backups of Dropped PDBs12-3112.5.7Deleting Preplugin Backups12-3212.613Deleting Specified Files with BACKUP . DELETE12-29Dropping a Database12-33Managing a Recovery Catalog13.1Overview of the RMAN Recovery Catalog13-113.1.1Purpose of the RMAN Recovery Catalog13-113.1.2Basic Concepts for the RMAN Recovery Catalog13-213.1.2.1About Database Registration in an RMAN Recovery Catalog13-213.1.2.2About Centralization of Metadata in a Base RMAN RecoveryCatalog13-213.1.2.3About RMAN Recovery Catalog Resynchronization13-313.1.2.4About Stored Scripts13-313.1.2.5Recovery Catalog in a Data Guard Environment13-313.1.313.2Basic Steps of Managing a Recovery CatalogCreating a Recovery Catalog13.2.1Configuring the Recovery Catalog Database13-413-513-513.2.1.1Planning the Size of the Recovery Catalog Schema13-513.2.1.2Allocating Disk Space for the Recovery Catalog Database13-613.2.2Creating the Recovery Catalog Schema Owner13-613.2.3Executing the CREATE CATALOG Command13-813.3Registering a Database in the Recovery Catalog13.3.1About Registration of a Database in the Recovery Catalog13.3.1.113.3.2About Standby Database RegistrationRegistering a Database with the REGISTER DATABASE Command13-913-913-913-1013.4Cataloging Backups in the Recovery Catalog13-1113.5Creating and Managing Virtual Private Catalogs13-1213.5.1Overview of Virtual Private Catalogs13-1213.5.2About Using the VPD Model for Virtual Private Catalogs13-1313.5.3Creating Virtual Private Catalogs13-1413.5.4Registering a Database with a Virtual Private Catalog13-1513.5.5Revoking Privileges from a Virtual Private Catalog Owner13-1613.5.6Upgrading Virtual Private Catalogs13-1713.6Protecting the Recovery Catalog13.6.1Backing Up the Recovery Catalog13-1813-18xv
13.6.1.1Backing Up the Recovery Catalog Frequently13-1813.6.1.2Choosing the Appropriate Technique for Physical Backups13-1813.6.1.3Separating the Recovery Catalog from the Target Database13-1913.6.1.4Exporting the Recovery Catalog Data for Logical Backups13-2013.6.213.7Recovering the Recovery CatalogManaging Stored Scripts13-2013-2113.7.1About Stored Scripts13-2113.7.2Creating Stored Scripts13-2213.7.3Replacing Stored Scripts13-2313.7.4Executing Stored Scripts13-2413.7.5Creating and Executing Dynamic Stored Scripts13-2513.7.6Printing Stored Scripts13-2613.7.7Listing Stored Script Names13-2713.7.8Deleting Stored Scripts13-2713.7.9Executing a Stored Script at RMAN Startup13-2813.8Maintaining a Recovery Catalog13-2813.8.1About Recovery Catalog Maintenance13-2913.8.2Resynchronizing the Recovery Catalog13-2913.8.2.1About Resynchronization of the Recovery Catalog13-2913.8.2.2Deciding When to Resynchronize the Recovery Catalog13-3013.8.2.3Manually Resynchronizing the Recovery Catalog13-3213.8.3Updating the Recovery Catalog After Changing a DB UNIQUE NAME13.8.4Unregistering a Target Database from the Recovery Catalog13.8.4.113-3313-34Unregistering a Target Database When Not in a Data GuardEnvironment13-3413.8.4.2Unregistering a Standby Database13-3513.8.4.3Unregistering a Target Database in a Recovery ApplianceEnvironment13-3613.8.5Resetting the Database Incarnation in the Recovery Catalog13-3713.8.6Upgrading the Recovery Catalog13-3913.8.6.1About Recovery Catalog Upgrades13-3913.8.6.2Determining the Schema Version of the Recovery Catalog13-4013.8.6.3Using the UPGRADE CATALOG Command13-4113.8.713.9Importing and Moving a Recovery Catalog13-4213.8.7.1About Recovery Catalog Imports13-4213.8.7.2About Importing Recovery Catalogs in a Recovery ApplianceEnvironment13-4313.8.7.3Prerequisites for Importing a Recovery Catalog13-4313.8.7.4Importing a Recovery Catalog13-4413.8.7.5Moving a Recovery Catalog13-44Dropping a Recovery Catalog13-45xvi pag
1.2 Oracle Backup and Recovery Solutions 1-4 1.3 Comparison of Oracle Backup Techniques 1-5 1.4 About Oracle Flashback Technology 1-6 1.4.1 Logical Flashback Features 1-6 1.4.2 Flashback Database 1-8 1.5 About Data Recovery Advisor 1-8
Acer provides Acer Recovery Management, which allows you to create a recovery backup, a drivers and applications backup, and to start recovery options, either using Windows tools, or the recovery backup. Creating a recovery backup To reinstall from a USB storage drive, you must first create a recovery backup.
Features Acronis Cyber Protect Cloud Backup Workstations, Servers (Windows, Linux, Mac) backup PAYG Virtual machine backup PAYG File backup PAYG Image backup PAYG Standard applications backup (Microsoft 365, Google Workspace, Microsoft Exchange, Microsoft SQL) PAYG Network shares backup PAYG Backup to local storage PAYG Backup to cloud storage PAYG
Acronis Cloud Backup USER GUIDE APPLIES TO THE FOLLOWING PRODUCTS Acronis Backup for Windows Server Acronis Backup for Linux Server . Full and incremental backup methods are available through several backup schemes. Regardless of the backup scheme, the first task run produces a full backup; subsequent task runs produce .
Jun 11, 2015 · Veeam Backup vs. Acronis Backup and Recovery Backup Exec vs. Acronis Backup and Recovery ARCserve Backup vs. Acronis Backup and Recovery Compared 21% of the time. Compared 15% of the time. Compared 3% of the time. Top Industries:* Software R&D Company Transportation Company Media Company Gov
What is Consolidated Backup? Consolidated Backup is a new, backup solution for ESX Server SAN Backup is offloaded to a dedicated physical host Supports different backup flavors File-level backup (Windows guests) Full virtual machine backup (all guests) under evaluation Integration with major 3rd party backup software,
Features Acronis Cyber Protect Cloud Backup Workstations, Servers (Windows, Linux, Mac) backup PAYG Virtual machine backup PAYG File backup PAYG Image backup PAYG Immutable backups PAYG Standard applications backup (Microsoft 365, Google Workspace, Microsoft Exchange, Microsoft SQL) PAYG Network shares backup PAYG Backup to local storage PAYG
Oracle Database Backup and Recovery Advanced User’s Guide 10g Release 2 (10.2) B14191-02 November 2005 A guide to advanced backup and recovery of Oracle databases and advanced uses of Recovery Manager (RMAN), including advanced RMAN database backup and recovery concepts and scenarios, using RMAN for data migration,
1. Hyper-V VM replication 2. Backup configuration for multiple hosts and hypervisors in a single backup job 3. Pre/Post backup scripts to support running custom scripts at the job level, VM level, etc. 4. Parallel VM Processing during backup for improved performance 5. Configuring VM order during backup VMware/Hyper-V Backup 1.
