Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documentation
  • Conventions
• Changes in This Release for Backup and Recovery Reference
  • Changes in Oracle Database Release 19c
  • Changes in Oracle Database Release 18c, Version 18.1
  • Changes in Oracle Database 12c Release 2 (12.2.0.1)
  • 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
  • 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 About RMAN Reserved Words
  • 1.4 Summary of RMAN Commands
  • 1.5 Summary of RMAN Subclauses
• 2 RMAN Commands: @ (at sign) to QUIT
  • 2.1 @ (at sign)
  • 2.2 @@ (double at sign)
  • 2.3 ADVISE FAILURE
  • 2.4 ALLOCATE CHANNEL
  • 2.5 ALLOCATE CHANNEL FOR MAINTENANCE
  • 2.6 BACKUP
  • 2.7 CATALOG
  • 2.8 CHANGE
  • 2.9 CONFIGURE
  • 2.10 CONNECT
  • 2.11 CONVERT
  • 2.12 CREATE CATALOG
  • 2.13 CREATE SCRIPT
  • 2.14 CROSSCHECK
  • 2.15 DELETE
  • 2.16 DELETE SCRIPT
  • 2.17 DESCRIBE
  • 2.18 DROP CATALOG
  • 2.19 DROP DATABASE
  • 2.20 DUPLICATE
  • 2.21 EXECUTE SCRIPT
  • 2.22 EXIT
  • 2.23 FLASHBACK DATABASE
  • 2.24 GRANT
  • 2.25 HOST
  • 2.26 IMPORT CATALOG
  • 2.27 LIST
  • 2.28 PRINT SCRIPT
  • 2.29 QUIT
• 3 RMAN Commands: RECOVER to VALIDATE
  • 3.1 RECOVER
  • 3.2 REGISTER DATABASE
  • 3.3 RELEASE CHANNEL
  • 3.4 REPAIR FAILURE
  • 3.5 REPLACE SCRIPT
  • 3.6 REPORT
  • 3.7 RESET DATABASE
  • 3.8 RESTORE
  • 3.9 RESYNC CATALOG
  • 3.10 REVOKE
  • 3.11 RMAN
  • 3.12 RUN
  • 3.13 SEND
  • 3.14 SET
  • 3.15 SHOW
  • 3.16 SHUTDOWN
  • 3.17 SPOOL
  • 3.18 SQL
  • 3.19 SQL (Quoted)
  • 3.20 STARTUP
  • 3.21 SWITCH
  • 3.22 TRANSPORT TABLESPACE
  • 3.23 UNREGISTER
  • 3.24 UPGRADE CATALOG
  • 3.25 VALIDATE
• 4 RMAN Subclauses
  • 4.1 allocOperandList
  • 4.2 archivelogRecordSpecifier
  • 4.3 completedTimeSpec
  • 4.4 connectStringSpec
  • 4.5 datafileSpec
  • 4.6 dbObject
  • 4.7 deviceSpecifier
  • 4.8 fileNameConversionSpec
  • 4.9 forDbUniqueNameOption
  • 4.10 foreignFileSpec
  • 4.11 foreignlogRecordSpecifier
  • 4.12 formatSpec
  • 4.13 keepOption
  • 4.14 listObjList
  • 4.15 maintQualifier
  • 4.16 maintSpec
  • 4.17 obsOperandList
  • 4.18 recordSpec
  • 4.19 sizeSpec
  • 4.20 tempfileSpec
  • 4.21 toDestSpec
  • 4.22 untilClause
• 5 Recovery Catalog Views
  • 5.1 Summary of RMAN Recovery Catalog Views
  • 5.2 RC_ARCHIVED_LOG
  • 5.3 RC_BACKUP_ARCHIVELOG_DETAILS
  • 5.4 RC_BACKUP_ARCHIVELOG_SUMMARY
  • 5.5 RC_BACKUP_CONTROLFILE
  • 5.6 RC_BACKUP_CONTROLFILE_DETAILS
  • 5.7 RC_BACKUP_CONTROLFILE_SUMMARY
  • 5.8 RC_BACKUP_COPY_DETAILS
  • 5.9 RC_BACKUP_COPY_SUMMARY
  • 5.10 RC_BACKUP_CORRUPTION
  • 5.11 RC_BACKUP_DATAFILE
  • 5.12 RC_BACKUP_DATAFILE_DETAILS
  • 5.13 RC_BACKUP_DATAFILE_SUMMARY
  • 5.14 RC_BACKUP_FILES
  • 5.15 RC_BACKUP_PIECE
  • 5.16 RC_BACKUP_PIECE_DETAILS
  • 5.17 RC_BACKUP_REDOLOG
  • 5.18 RC_BACKUP_SET
  • 5.19 RC_BACKUP_SET_DETAILS
  • 5.20 RC_BACKUP_SET_SUMMARY
  • 5.21 RC_BACKUP_SPFILE
  • 5.22 RC_BACKUP_SPFILE_DETAILS
  • 5.23 RC_BACKUP_SPFILE_SUMMARY
  • 5.24 RC_CHECKPOINT
  • 5.25 RC_CONTROLFILE_COPY
  • 5.26 RC_COPY_CORRUPTION
  • 5.27 RC_DATABASE
  • 5.28 RC_DATABASE_BLOCK_CORRUPTION
  • 5.29 RC_DATABASE_INCARNATION
  • 5.30 RC_DATAFILE
  • 5.31 RC_DATAFILE_COPY
  • 5.32 RC_DISK_RESTORE_RANGE
  • 5.33 RC_LOG_HISTORY
  • 5.34 RC_OFFLINE_RANGE
  • 5.35 RC_PDBS
  • 5.36 RC_PLUGGABLE_DATABASE_INC
  • 5.37 RC_PROXY_ARCHIVEDLOG
  • 5.38 RC_PROXY_ARCHIVELOG_DETAILS
  • 5.39 RC_PROXY_ARCHIVELOG_SUMMARY
  • 5.40 RC_PROXY_CONTROLFILE
  • 5.41 RC_PROXY_COPY_DETAILS
  • 5.42 RC_PROXY_COPY_SUMMARY
  • 5.43 RC_PROXY_DATAFILE
  • 5.44 RC_REDO_LOG
  • 5.45 RC_REDO_THREAD
  • 5.46 RC_RESTORE_POINT
  • 5.47 RC_RESTORE_RANGE
  • 5.48 RC_RESYNC
  • 5.49 RC_RMAN_BACKUP_JOB_DETAILS
  • 5.50 RC_RMAN_BACKUP_SUBJOB_DETAILS
  • 5.51 RC_RMAN_BACKUP_TYPE
  • 5.52 RC_RMAN_CONFIGURATION
  • 5.53 RC_RMAN_OUTPUT
  • 5.54 RC_RMAN_STATUS
  • 5.55 RC_SBT_RESTORE_RANGE
  • 5.56 RC_SITE
  • 5.57 RC_STORED_SCRIPT
  • 5.58 RC_STORED_SCRIPT_LINE
  • 5.59 RC_TABLESPACE
  • 5.60 RC_TEMPFILE
  • 5.61 RC_UNUSABLE_BACKUPFILE_DETAILS
• A RMAN Reserved Words
  • A.1 List of RMAN Reserved Words
• B Deprecated RMAN Syntax
• C RMAN Compatibility
  • C.1 About RMAN Compatibility
  • C.2 Determining the Recovery Catalog Schema Version
  • C.3 RMAN Compatibility Matrix
  • C.4 Cross-Version Compatibility of Recovery Catalog Exports and Imports
  • C.5 RMAN Compatibility: Scenario
• D Oracle Database Cloud Backup Module
• E Oracle Secure Backup (OSB) Cloud Module
  • E.1 About Backup on the Cloud Using Oracle Secure Backup Cloud Module
    • E.1.1 Configuration Parameters for the Oracle Secure Backup Cloud Module
  • E.2 Using Oracle Secure Backup Cloud Module on Amazon S3
    • E.2.1 Hardware and Software Prerequisites for Oracle Secure Backup Cloud Module
    • E.2.2 Registering for An Oracle Technology Network (OTN) Account
    • E.2.3 Signing Up For Amazon S3 - AWS Account
    • E.2.4 Getting Your AWS Credentials
    • E.2.5 Installing the OSB Cloud Module Library
    • E.2.6 Running the S3 Backup Installer
    • E.2.7 Storing Configuration Information in the RMAN Repository (Optional)
    • E.2.8 Using the OSB Web Services Library and First Backup
  • E.3 Securing OSB Cloud Module Backups
  • E.4 Helpful Links: Oracle Secure Backup Cloud Module
  • E.5 Troubleshooting the OSB Cloud Module
• Index