Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 About RMAN Commands

• Structure 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

2 RMAN Commands: @ (at sign) to QUIT

• @ (at sign)
• @@ (double at sign)
• ADVISE FAILURE
• ALLOCATE CHANNEL
• ALLOCATE CHANNEL FOR MAINTENANCE
• ALTER DATABASE
• BACKUP
• CATALOG
• CHANGE
• CONFIGURE
• CONNECT
• CONVERT
• CREATE CATALOG
• CREATE SCRIPT
• CROSSCHECK
• DELETE
• DELETE SCRIPT
• 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
• STARTUP
• SWITCH
• TRANSPORT TABLESPACE
• UNREGISTER
• UPGRADE CATALOG
• VALIDATE

4 RMAN Subclauses

• allocOperandList
• archivelogRecordSpecifier
• completedTimeSpec
• connectStringSpec
• datafileSpec
• deviceSpecifier
• fileNameConversionSpec
• forDbUniqueNameOption
• foreignlogRecordSpecifier
• formatSpec
• keepOption
• listObjList
• maintQualifier
• maintSpec
• obsOperandList
• recordSpec
• tempfileSpec
• toDestSpec
• Examples
• 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_LOG_HISTORY
• 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

A Deprecated RMAN Syntax

B 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

C Oracle Secure Backup (OSB) Cloud Module

• Backup 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 Backups
  • Troubleshooting the OSB Cloud Module

Index