Oracle Database Backup And Recovery Reference - ULisboa

Oracle DatabaseBackup and Recovery Reference11g Release 2 (11.2)E10643-01July 2009A guide to backup and recovery of Oracle databases,including RMAN backup and recovery, RMAN data transfer,Oracle Flashback Technology, and user-managed backup andrecovery

Oracle Database Backup and Recovery Reference, 11g Release 2 (11.2)E10643-01Copyright 2003, 2009, Oracle and/or its affiliates. All rights reserved.Primary Author: Lance AshdownContributors: Katherine Weill, Tammy Bednar, Anand Beldalker, Timothy Chien, Mark Dilman, SenadDizdar, Bill Fisher, Raymond Guzman, Stephan Haisley, Wei Hu, Alex Hwang, Ashok Joshi, VasudhaKrishnaswamy, J. William Lee, Valarie Moore, Muthu Olagappan, Vsevolod Panteleenko, CrisPedregal-Martin, Samitha Samaranayake, Francisco Sanchez, Vivian Schupmann, Vinay Srihari, MargaretSusairaj, Mike Stewart, Steven Wertheimer, Wanli Yang, Rob 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 software or related documentation is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical datadelivered to U.S. Government customers are "commercial computer software" or "commercial technical data"pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. Assuch, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions andlicense terms set forth in the applicable Government contract, and, to the extent applicable by the terms ofthe Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer SoftwareLicense (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is notdeveloped or intended for use in any inherently dangerous applications, including applications which maycreate a risk of personal injury. If you use this software in dangerous applications, then you shall beresponsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe useof this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use ofthis software in dangerous applications.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarksof their respective owners.This software and documentation may provide access to or information on content, products, and servicesfrom third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim allwarranties of any kind with respect to third-party content, products, and services. Oracle Corporation andits affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use ofthird-party content, products, or services.

ContentsPreface . ixAudience.Documentation Accessibility .Related Documentation .Conventions .ixixxx1 About RMAN CommandsStructure of RMAN Command Entries.RMAN Syntax Diagrams .Keywords in RMAN Syntax .Placeholders in RMAN Syntax.Quotes in RMAN Syntax.Format of RMAN Commands .RMAN Reserved Words .Summary of RMAN Commands .Summary of RMAN Subclauses.21-11-21-21-21-31-31-41-61-8RMAN Commands: @ (at sign) to QUIT@ (at sign) . 2-2@@ (double at sign) . 2-4ADVISE FAILURE . 2-6ALLOCATE CHANNEL . 2-10ALLOCATE CHANNEL FOR MAINTENANCE . 2-13ALTER DATABASE . 2-17BACKUP. 2-19CATALOG. 2-52CHANGE . 2-57CONFIGURE. 2-65CONNECT . 2-86CONVERT . 2-89CREATE CATALOG. 2-102CREATE SCRIPT . 2-105CROSSCHECK . 2-109DELETE . 2-113DELETE SCRIPT . 2-119iii

DROP CATALOG.DROP DATABASE.DUPLICATE .EXECUTE SCRIPT.EXIT.FLASHBACK DATABASE .GRANT.HOST .IMPORT CATALOG .LIST.PRINT SCRIPT .QUIT 642-1852-187RMAN Commands: RECOVER to VALIDATERECOVER . 3-2REGISTER DATABASE . 3-16RELEASE CHANNEL. 3-18REPAIR FAILURE . 3-21REPLACE SCRIPT. 3-25REPORT . 3-28RESET DATABASE. 3-35RESTORE. 3-37RESYNC CATALOG . 3-53REVOKE. 3-57RMAN. 3-59RUN. 3-65SEND . 3-68SET . 3-70SHOW. 3-82SHUTDOWN . 3-85SPOOL . 3-87SQL. 3-88STARTUP . 3-90SWITCH . 3-92TRANSPORT TABLESPACE . 3-96UNREGISTER. 3-102UPGRADE CATALOG . 3-105VALIDATE . 3-1074 RMAN SubclausesallocOperandList . 4-2archivelogRecordSpecifier . 4-6completedTimeSpec. 4-11connectStringSpec . 4-13datafileSpec . 4-15deviceSpecifier. 4-16fileNameConversionSpec . 4-17iv

forDbUniqueNameOption .foreignlogRecordSpecifier .formatSpec .keepOption .listObjList .maintQualifier .maintSpec.obsOperandList .recordSpec.tempfileSpec.toDestSpec .Examples 4-394-404-414-42Recovery Catalog ViewsSummary of RMAN Recovery Catalog Views. 5-1RC ARCHIVED LOG . 5-4RC BACKUP ARCHIVELOG DETAILS. 5-6RC BACKUP ARCHIVELOG SUMMARY . 5-7RC BACKUP CONTROLFILE . 5-8RC BACKUP CONTROLFILE DETAILS. 5-10RC BACKUP CONTROLFILE SUMMARY . 5-11RC BACKUP COPY DETAILS. 5-12RC BACKUP COPY SUMMARY . 5-13RC BACKUP CORRUPTION. 5-14RC BACKUP DATAFILE. 5-15RC BACKUP DATAFILE DETAILS . 5-17RC BACKUP DATAFILE SUMMARY. 5-18RC BACKUP FILES. 5-19RC BACKUP PIECE . 5-22RC BACKUP PIECE DETAILS . 5-24RC BACKUP REDOLOG. 5-26RC BACKUP SET . 5-28RC BACKUP SET DETAILS. 5-30RC BACKUP SET SUMMARY . 5-32RC BACKUP SPFILE . 5-33RC BACKUP SPFILE DETAILS. 5-34RC BACKUP SPFILE SUMMARY . 5-35RC CHECKPOINT . 5-36RC CONTROLFILE COPY . 5-37RC COPY CORRUPTION. 5-39RC DATABASE . 5-40RC DATABASE BLOCK CORRUPTION . 5-41RC DATABASE INCARNATION . 5-42RC DATAFILE . 5-43RC DATAFILE COPY. 5-45RC LOG HISTORY . 5-47v

RC OFFLINE RANGE .RC PROXY ARCHIVEDLOG .RC PROXY ARCHIVELOG DETAILS .RC PROXY ARCHIVELOG SUMMARY.RC PROXY CONTROLFILE.RC PROXY COPY DETAILS .RC PROXY COPY SUMMARY.RC PROXY DATAFILE .RC REDO LOG .RC REDO THREAD .RC RESTORE POINT.RC RESYNC .RC RMAN BACKUP JOB DETAILS .RC RMAN BACKUP SUBJOB DETAILS .RC RMAN BACKUP TYPE .RC RMAN CONFIGURATION .RC RMAN OUTPUT .RC RMAN STATUS .RC SITE .RC STORED SCRIPT .RC STORED SCRIPT LINE.RC TABLESPACE .RC TEMPFILE.RC UNUSABLE BACKUPFILE DETAILS.ADeprecated RMAN SyntaxBRMAN CompatibilityAbout RMAN Compatibility .Determining the Recovery Catalog Schema Version .RMAN Compatibility Matrix.Cross-Version Compatibility of Recovery Catalog Exports and Imports.RMAN Compatibility: Scenario .CB-1B-1B-2B-3B-3Oracle Secure Backup (OSB) Cloud ModuleBackup On the Cloud .Getting Started.Hardware and Software Prerequisites .Registering for An Oracle Technology Network (OTN) Account .Signing Up For Amazon S3 - AWS Account .Getting Your AWS Identifiers .Installing the OSB Cloud Module Library.Running the S3 Backup Installer .Storing Configuration in RMAN Repository - optional.Using the OSB Web Services Library and First Backup .Securing OSB Cloud Module 765-78C-1C-1C-2C-2C-2C-3C-3C-4C-6C-6C-7

Troubleshooting the OSB Cloud Module . C-7Indexvii

viii

PrefaceThis preface contains these topics: Audience Documentation Accessibility Related Documentation ConventionsAudienceBackup and Recovery Reference is intended for database administrators who perform thefollowing tasks: Use Recovery Manager (RMAN) to back up, restore, and recover Oracle databases Perform maintenance on RMAN backups of database filesTo use this document, you must know the following: Relational database concepts and basic database administration as described inOracle Database Concepts and the Oracle Database Administrator's GuideRMAN concepts and tasks as described in Oracle Database Backup and RecoveryUser's GuideThe operating system environment under which you are running Oracle DatabaseDocumentation AccessibilityOur goal is to make Oracle products, services, and supporting documentationaccessible to all users, including users that are disabled. To that end, ourdocumentation includes features that make information available to users of assistivetechnology. This documentation is available in HTML format, and contains markup tofacilitate access by the disabled community. Accessibility standards will continue toevolve over time, and Oracle is actively engaged with other market-leadingtechnology vendors to address technical obstacles so that our documentation can beaccessible to all of our customers. For more information, visit the Oracle AccessibilityProgram Web site at http://www.oracle.com/accessibility/.Accessibility of Code Examples in DocumentationScreen readers may not always correctly read the code examples in this document. Theconventions for writing code require that closing braces should appear on anix

otherwise empty line; however, some screen readers may not always read a line of textthat consists solely of a bracket or brace.Accessibility of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies ororganizations that Oracle does not own or control. Oracle neither evaluates nor makesany representations regarding the accessibility of these Web sites.Deaf/Hard of Hearing Access to Oracle Support ServicesTo reach Oracle Support Services, use a telecommunications relay service (TRS) to callOracle Support at 1.800.223.1711. An Oracle Support Services engineer will handletechnical issues and provide customer support according to the Oracle service requestprocess. Information about TRS is available athttp://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phonenumbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.Related DocumentationFor more information, see these Oracle resources: Oracle Database Backup and Recovery User's Guide Oracle Database Reference Oracle Database UtilitiesMany of the examples in this book use the sample schemas of the seed database, whichis installed by default when you install Oracle. Refer to Oracle Database Sample Schemasfor information on how these schemas were created and how you can use themyourself.ConventionsThe text in this reference adheres to the following conventions: UPPERCASE monospaceCalls attention to RMAN keywords, SQL keywords, column headings in tablesand views,

For more information, see these Oracle resources: Oracle Database Backup and Recovery User's Guide Oracle Database Reference Oracle Database Utilities Many of the examples in this book use the sample schemas of the seed database, which is installed by default when you install Oracle. Refer to Oracle Database Sample Schemas