Master Note For Oracle Recovery Manager (RMAN) [ID 1116484.1]
Modified 14-OCT-2010
Type ANNOUNCEMENT
Status PUBLISHED
In this Document What is being announced? What do you need to do? Introduction Getting started with RMAN Rman compatibility Flash Recovery Area Configuring the Environment for RMAN Backups Recovery Catalog for Rman backups. Backing up Database files using RMAN and Maintainig the backup records. Restore and recovery techiques/scenarios using RMAN. Tablespace point in time recovery Rman Transportable tablespaces and database. Rman Duplicate Database Rman Performance. RMAN and Media managers Rman and Dataguard Rman and Rac Rman and Corruption Related Master Notes Using My Oracle Support Effectively Generic Links
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.1.0 - Release: 10.1 to 11.2 Information in this document applies to any platform.
What is being announced? This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Recovery Manager (RMAN).This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest, within RMAN.This includes the following categories: y y y y y y y y y y y y y y
Getting started with RMAN Rman compatibility Flash Recovery Area Configuring the environment for RMAN backups Recovery catalog for RMAN backups Backing up database files using RMAN and maintaining the backup records Restore and recovery techniques/scenarios using RMAN Tablespace point in time recovery (TSPITR) RMAN Transportable tablespaces and database RMAN Duplicate database RMAN Performance. RMAN and Media managers. RMAN and Dataguard RMAN and Rac
y y y y
RMAN and Corruption Related Master Notes Using My Oracle Support Effectively Generic Links
What do you need to do? Introduction Recovery Manager is Oracle¶s utility to manage the backup, and more importantly the recovery, of the database. It eliminates operational complexity while providing superior performance and availability of the database. Recovery Manager debuted with Oracle8 to provide DBAs an integrated backup and recovery solution. Recovery Manager determines the most efficient method of executing the requested backup, restore, or recovery operation and then executes these operations in concert with the Oracle database server. Recovery Manager and the server automatically identify modifications to the structure of the database and dynamically adjust the required operation to adapt to the changes. This note applies to the following versions of these products: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.x Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.x Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.x
Getting started with RMAN The articles in this section give you a overview of the oracle utility RMAN,the new features of RMAN in Oracle 11 release 1,2 and FAQ on RMAN.
Note.360416.1 Note 809867.1 Note 1115423.1 Note.469777.1
Oracle10g / 11g - Getting Started with Recovery Manager (RMAN) RMAN 11gR1 : New Features Rman Enhancements In Oracle 11g. RMAN - Frequently Asked Question (FAQ)
Rman compatibility Note.73431.1 RMAN Compatibility Matrix
Flash
Recovery Area
The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover a database from a media failure are part of the Flash Recovery Area. Oracle creates archived logs and flashback logs in the flash recovery area. RMAN can store its backup sets and image copies in the flash recovery area, and it uses it when restoring files during media recovery. The flash recovery area also acts as a disk cache for tape. The articles mentioned in the following section help you in understanding the concepts and working of flash recovery area,Rman integration with the flash recovery area,troubleshooting flash recovery area issues
Note.305648.1 Note.305796.1 Note.833663.1 Note.560133.1 Note.315098.1 Example. Note.305812.1 Note.829755.1 Note.305810.1 Precedence Note.305651.1 Note.762934.1
Configuring
What is a Flash Recovery Area and how to configure it ? RMAN and Flash Recovery Area Flash Recovery Area - FAQ Benefits Of Using Flash Recovery Area How is the space pressure managed in the Flash Recovery Area - An Flash Recovery area - Space management Warning & Alerts Space issue in Flash Recovery Area( FRA ) Configuring file creation in Flash recovery area and order of How to change Flash Recovery Area to a new location ? Flash Recovery Area Sizing
the Environment for RMAN Backups
To simplify ongoing use of RMAN, you can set a number of persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations. The articles mentioned in the following section help you in configuring the rman persistent configurations,understanding their behaviour and troubleshooting them.
Note 305565.1 Note.462978.1 Note.463875.1 Note.351455.1
Persistent Controlfile Configurations for RMAN in 9i and 10g Rman backup retention policy Frequently asked questions on Rman backup retention policy Oracle Suggested Strategy & Backup Retention
Recovery Catalog for Rman backups. A recovery catalog is a set of tables and views that Recovery Manager (RMAN) uses to store metadata (information about a database structure, archived redo logs, backup sets, and data file copies) about a target database (database that RMAN backups or restores). RMAN uses this metadata to conduct its backup, recovery, and maintenance operations. Recovery catalog is optional, i.e., if a recovery catalog is not created, RMAN uses the target database¶s control file to store the metadata about the target database. Although RMAN can conduct all major backup and recovery operations by using the control file, some RMAN commands work only if a recovery catalog exists. The articles in the following section describe the configuration,managment of recovery catalog and some of the known issues related to recovery catalog. Note.452529.1 Recovery catalog for RMAN backup Note.467969.1 How To Configure RMAN Recovery Catalog Using Enterprise Manager DB Console.
Backing up Database files using RMAN and Maintainig the backup records. The articles and links in the following section describe the different methods to perform backups and useful rman backup methods. Oracle Database Backup and Recovery Advanced User's Guide y
Rman backup concepts http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#i1006083
y
y
y
Backing up database http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmbckba.htm#i1005689 Advanced backups http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmbckad.htm#CEGHFJ CF Backup maintenance http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmmaint.htm#j1006083
NOTE:388422.1 Note 262853.1 Note.745798.1 Note.735953.1 Managery Note.137181.1
Top 10 Backup and Recovery best practices 10G RMAN Fast Incremental Backups Merged Incremental Backup Strategies How To Configure RMAN Backups To Tape via Oracle Enterprise RMAN Backup Shell Script Example
Restore and recovery techiques/scenarios using RMAN. The articles in this section provide various restore and recovery techniques and scenarios what can be achieved using rman. Note.144911.1 RMAN 9i Block-Level Media Recove ry - Concept & Example NOTE:388422.1 Top 10 Backup and Recovery best practices Note.94114.1 Backup and Recovery Scenarios Note.372996.1 Using RMAN to Restore and Recover a Database When the Repository and Spfile/Init.ora Files Are Also Lost Note.162855.1 RMAN Consistent Backup, Restore and Recovery using RMAN Note.223543.1 How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN Note.403883.1 How To Restore Controlfile From A Backupset Without A Catalog Or Autobackup Note.580414.1 RMAN - How to restore the controlfile using RMAN Note.419137.1 How To Restore Rman Backups On A Different Node When The Di rectory Structures Are Different Note.415579.1 HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node Note.472536.1 10g RMAN Benefits of Simplified Recovery Through Resetlogs. Note.61994.1 Procedures/Restrictions f or Point-In-Time Recovery without a Recovery Catalog Note.246325.1 Automated File Creation During RMAN Recovery Note.358171.1 Oracle10g RMAN will not restore in parallel from tape
Tablespace
point in time recovery
Recovery Manager (RMAN) Automatic TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.Here are a few articles which explain the steps involved in performing a TSPITR:
Note.109979.1 RMAN Tablespace Point In Time Recovery (TSPITR) Procedure. Note.62332.1 TSPITR - An Example Walkthrough
Rman Transportable tablespaces and database. Rman can be used to create transportable tablespace sets and can be used to convert the datafiles for cross platform transportable tablespace and database. Here are a few articles which provide all the required information to understand the procedures: Note.371556.1 How move tablespaces across platforms using Transportable Tablespaces with RMAN Note.455593.1 Creating a transportable tablespace set from RMAN backupsets
Note.831223.1 Note.413586.1 Migration Note.414878.1 Database Note.733205.1
Using Rman Incremental backups To Update Transportable Tablespaces. How To Use RMAN CONVERT DATABASE on Source Host for Cross Platform Cross-Platform Migration on Destination Host Using Rman Convert Migration of Oracle Database Instances Across OS Platfo rms
Rman Duplicate Database Database duplication is the use of the DUPLICATE command to copy all or a subset of the data in a source database. The duplicate database (the copied database) functions entirely independently from the source database (the database being copied).In articles in this section help you in understanding the duplicate procedures and various techinques available for the rman duplicate operation.
Note.228257.1 RMAN 'Duplicate Database' Feature in Oracle9i / 10G and 11G Note.452868.1 RMAN 'Duplicate Database' Feature in 11G Note.1113713.1 Creation Of Rman Duplicate Without Target And Recovery Catalog Connection. Note.388431.1 Creating a Duplicate Database o n a New Host. Note.382669.1 Duplicate database from non ASM to ASM (vise versa) to a different host Note.388424.1 How To Create A Production (Full or Partial) Duplicate On The Same Host Note.293717.1 How to duplicate a database to previous incarnation Note.340848.1 Performing duplicate database with ASM/OMF/RMAN Note 461479.1 RMAN Duplicate Database From RAC ASM To RAC ASM Note.840647.1 Article on How to do Rman Duplicate on ASM/RAC/OMF/SingleInstance Note.360962.1 Manual Completion of a Failed RMAN Duplicate Note.369644.1 Answers To FAQ For Restoring Or Duplicating Between Different Versions And Platforms
Rman Performance. Note.360443.1 Note 740911.1 Note 247611.1 NOTE.360443.1 NOTE.579158.1 NOTE.296985.1 Note.463227.1
RMAN Backup Performance RMAN Restore Performance Known RMAN Performance Problems Analysing RMAN Performance Issues Advise On How To Improve Rman Performance RMAN Performance Data Gathering Oracle10g RMAN Recovery Catalog Known Performance Issues
RMAN and Media managers Oracle designed an architecture that allows RMAN to manage the process of database backup and recovery, yet integrate with industry-leading tape storage management subsystems. The interface between Rman and media management vendor products is keyed on an Oracle design specification. This specification allows Oracle RMAN to use third party media management software to back-up to and restore from tape. Many organizations rely on Oracle to provide solutions for very large or highly distributed mission critical systems. In addition to needing databases capable of handling large amounts of data and complex queries, these organizations also need robu st backup and recovery technology. Recovery of data quickly and reliably is paramount should some aspect of the system fail. To address these needs, Oracle has created the Backup Solutions Program (BSP), a cooperative program designed to facilitate tighter integration between Oracle's backup products and those of third-party media management vendors. Togeth er, Oracle and media manage ment vendors pro vide robust easy-to-use database backup and recovery solutions to customers with high-end requirements.
The link to access the information regarding backup solutions program is: http://www.oracle.com/technetwork/database/features/availability/bsp-088814.html "Under the BSP, vendors are committed to integrating Recovery Manager (RMAN) with their media management software packages and provide first line technical support for the integrated backup and recovery solutions for Oracle RDBMS." So any issues related to the media manager functionality or configuration has to be addressed only by the vendors and not by Oracle. Below are a few articles which help you in understanding the most common issues with rman backups to tape, environment variable used for backups to tape and procedure to check if the media manager installation has been done properly. Note.942418.1 Note 1062824.6 Note 227517.1 NOTE.312737.1
How To Verify A Media Manager Layer Installation ? RMAN: Unable to Backup with Third-Party Storage Ma nager Main Index of Common Caus es for ORA-19511 RMAN and Specific Media Managers Environment Variables.
Rman and Dataguard Data Guard and RMAN were both designed with the Oracle database architecture in mind. Together, they offer the most reliable and tightly integrated solution to achieve superior levels of Oracle database availability supporting your mission critical applications. Data Guard and RMAN are both fully supported features of the Oracle Database Enterprise Edition (RMAN is also provided with Oracle Database Standard Edition).Here are a few articles that help you in effectively using rman with dataguard and some of the known rman issues with dataguard.
Note.848716.1 Using RMAN Effectively In A Dataguard Environment Note.357759.1 Known RMAN - Dataguard Problems Note.368336.1 10gR1 RAC/DataGuard/ASM physical standby deployment procedure
Rman and Rac Note 243760.1 Note.415579.1 Another Node Note 461479.1 Note.840647.1
Rman and
RMAN: RAC Backup and Recovery using RMAN HowTo Restore RMAN Disk backups of RAC Database to Single Instance On RMAN Duplicate Database From RAC ASM To RAC ASM Article on How to do Rman Duplicate on ASM/RAC/OMF/Single Instance
Corruption
Rman is a very effective utility in identifying the database block corruption. Here are are a few article which provides the information about using rman to detect and fix corruption. Note.283053.1 Note 836658.1 Note.561010.1 Backupset? Note 428570.1
How To Use RMAN To Check For Logical & Physical Database Corruption Identify the corruption extension using RMAN/DBV/ANALYZE etc Which Blocks Will RMAN Check For Corruption Or Include In A Best Practices for Avoiding and Detecting Corruption
Related Master Notes
Note 1199803.1 Master Note For Note 1096952.1 Master Note for and Oracle Grid Infrastructure Note 1088018.1 Master Note for Note 1101938.1 Master Note for
Usi
O
Note Note Note Note Note Note Note
374370.1 736737.1 730283.1 747242.5 868955.1 166650.1 199389.1
Gener i
l S
E
i
Oracle Backup And Recovery Real Application Clusters (RAC) Oracle Clusterware Oracle Database Corruption Data Guard
l
New Customers Start Here My Oracle Support - The Next Generation Support Platform Get the most out of My Oracle Support My Oracle Support Configuration Management FAQ My Oracle Support Health Checks Catalog Working Effectively With Global Customer Support Escalating Service Requests with Oracle Support Services
Links
Note 854428.1 Patch Set Updates for Oracle Products Note 1061295.1 Patch Set Upd ates - One-off Patch Conf lict Resolution Note 881382.1 Critical Patch Update October 2009 P atch Availability Document for Oracle Products Note 967472.1 Critical Patch Update January 2010 Patch Availability Document for Oracle Products Note 1060989.1 Critical Patch Update April 2010 Patch Availability Document for Oracle Products Note 756671.1 Oracle Recommended Patches -- Oracle D atabase Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0 Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Rel ed
Products
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server Enterprise Edition
y
K eywords
RAC; DATA GUARD; ENTERPRISE MANAGER ; CONVERT DATABASE; RECOVERY MANAGER ; TRANSPORTAB E; DUPLICATE DATABASE; DATABASE RECOVERY Errors ORA-19511 B
¢
¡
t t £
£
¤
Rate this document
