1/152

Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

Changes in This Release for Backup and Recovery Reference

• Changes in Oracle Database 12c Release 1 (12.1.0.2)
• Changes in Oracle Database 12c Release 1 (12.1.0.1)

1 About RMAN Commands

• 1.1 RMAN Syntax Diagrams
  • 1.1.1 Keywords in RMAN Syntax
  • 1.1.2 Placeholders in RMAN Syntax
  • 1.1.3 Quotes in RMAN Syntax
• 1.2 Format of RMAN Commands
• 1.3 RMAN Reserved Words
• 1.4 Summary of RMAN Commands
• 1.5 Summary of RMAN Subclauses

2 RMAN Commands: @ (at sign) to QUIT

• @ (at sign)
• @@ (double at sign)
• ADVISE FAILURE
• ALLOCATE CHANNEL
• ALLOCATE CHANNEL FOR MAINTENANCE
• BACKUP
• CATALOG
• CHANGE
• CONFIGURE
• CONNECT
• CONVERT
• CREATE CATALOG
• CREATE SCRIPT
• CROSSCHECK
• DELETE
• DELETE SCRIPT
• DESCRIBE
• DROP CATALOG
• DROP DATABASE
• DUPLICATE
• EXECUTE SCRIPT
• EXIT
• FLASHBACK DATABASE
• GRANT
• HOST
• IMPORT CATALOG
• LIST
• PRINT SCRIPT
• QUIT

3 RMAN Commands: RECOVER to VALIDATE

• RECOVER
• REGISTER DATABASE
• RELEASE CHANNEL
• REPAIR FAILURE
• REPLACE SCRIPT
• REPORT
• RESET DATABASE
• RESTORE
• RESYNC CATALOG
• REVOKE
• RMAN
• RUN
• SEND
• SET
• SHOW
• SHUTDOWN
• SPOOL
• SQL
• SQL (Quoted)
• STARTUP
• SWITCH
• TRANSPORT TABLESPACE
• UNREGISTER
• UPGRADE CATALOG
• VALIDATE

4 RMAN Subclauses

• allocOperandList
• archivelogRecordSpecifier
• completedTimeSpec
• connectStringSpec
• datafileSpec
• dbObject
• deviceSpecifier
• fileNameConversionSpec
• forDbUniqueNameOption
• foreignFileSpec
• foreignlogRecordSpecifier
• formatSpec
• keepOption
• listObjList
• maintQualifier
• maintSpec
• obsOperandList
• recordSpec
• sizeSpec
• tempfileSpec
• toDestSpec
• untilClause

5 Recovery Catalog Views

• 5.1 Summary of RMAN Recovery Catalog Views
• RC_ARCHIVED_LOG
• RC_BACKUP_ARCHIVELOG_DETAILS
• RC_BACKUP_ARCHIVELOG_SUMMARY
• RC_BACKUP_CONTROLFILE
• RC_BACKUP_CONTROLFILE_DETAILS
• RC_BACKUP_CONTROLFILE_SUMMARY
• RC_BACKUP_COPY_DETAILS
• RC_BACKUP_COPY_SUMMARY
• RC_BACKUP_CORRUPTION
• RC_BACKUP_DATAFILE
• RC_BACKUP_DATAFILE_DETAILS
• RC_BACKUP_DATAFILE_SUMMARY
• RC_BACKUP_FILES
• RC_BACKUP_PIECE
• RC_BACKUP_PIECE_DETAILS
• RC_BACKUP_REDOLOG
• RC_BACKUP_SET
• RC_BACKUP_SET_DETAILS
• RC_BACKUP_SET_SUMMARY
• RC_BACKUP_SPFILE
• RC_BACKUP_SPFILE_DETAILS
• RC_BACKUP_SPFILE_SUMMARY
• RC_CHECKPOINT
• RC_CONTROLFILE_COPY
• RC_COPY_CORRUPTION
• RC_DATABASE
• RC_DATABASE_BLOCK_CORRUPTION
• RC_DATABASE_INCARNATION
• RC_DATAFILE
• RC_DATAFILE_COPY
• RC_DISK_RESTORE_RANGE
• RC_LOG_HISTORY
• RC_OFFLINE_RANGE
• RC_PDBS
• RC_PLUGGABLE_DATABASE_INC
• 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_RESTORE_RANGE
• 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_SBT_RESTORE_RANGE
• RC_SITE
• RC_STORED_SCRIPT
• RC_STORED_SCRIPT_LINE
• RC_TABLESPACE
• RC_TEMPFILE
• RC_UNUSABLE_BACKUPFILE_DETAILS

A Deprecated RMAN Syntax

B RMAN Compatibility

• B.1 About RMAN Compatibility
• B.2 Determining the Recovery Catalog Schema Version
• B.3 RMAN Compatibility Matrix
• B.4 Cross-Version Compatibility of Recovery Catalog Exports and Imports
• B.5 RMAN Compatibility: Scenario

C Oracle Database Cloud Backup Module

D Oracle Secure Backup (OSB) Cloud Module

• D.1 Backup on the Cloud
• D.2 Getting Started
  • D.2.1 Hardware and Software Prerequisites
  • D.2.2 Registering for An Oracle Technology Network (OTN) Account
  • D.2.3 Signing Up For Amazon S3 - AWS Account
  • D.2.4 Getting Your AWS Identifiers
  • D.2.5 Installing the OSB Cloud Module Library
  • D.2.6 Running the S3 Backup Installer
  • D.2.7 Storing Configuration Information in the RMAN Repository (Optional)
  • D.2.8 Using the OSB Web Services Library and First Backup
• D.3 Securing OSB Cloud Module Backups
• D.4 Helpful Links
• D.5 Troubleshooting the OSB Cloud Module

Index