1/152

Contents

Title and Copyright Information

Preface

• Audience
• Related Documentation
• Conventions

Changes in This Release for Backup and Recovery Reference

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

1 About RMAN Commands

• 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

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

• 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 RMAN Reserved Words

• List of RMAN Reserved Words

B Deprecated RMAN Syntax

C RMAN Compatibility

• About RMAN Compatibility
• Determining the Recovery Catalog Schema Version
• RMAN Compatibility Matrix
• Cross-Version Compatibility of Recovery Catalog Exports and Imports
• RMAN Compatibility: Scenario

D Oracle Database Cloud Backup Module

E Oracle Secure Backup (OSB) Cloud Module

• About Backup on the Cloud Using Oracle Secure Backup Cloud Module
  • Configuration Parameters for the Oracle Secure Backup Cloud Module
• Using Oracle Secure Backup Cloud Module on Amazon S3
  • Hardware and Software Prerequisites for Oracle Secure Backup Cloud Module
  • Registering for An Oracle Technology Network (OTN) Account
  • Signing Up For Amazon S3 - AWS Account
  • Getting Your AWS Credentials
  • Installing the OSB Cloud Module Library
  • Running the S3 Backup Installer
  • Storing Configuration Information in the RMAN Repository (Optional)
  • Using the OSB Web Services Library and First Backup
• Securing OSB Cloud Module Backups
• Helpful Links: Oracle Secure Backup Cloud Module
• Troubleshooting the OSB Cloud Module

Index