Changes in This Release for Backup and Recovery User's Guide

The following are the new features in this release:

• Oracle Virtual Private Database (VPD) for RMAN virtual private catalog

  The RMAN recovery catalog is created and managed using VPD. This provides better performance and scalability when a large number of virtual private catalogs are created.

  See Also:

  • "Creating and Managing Virtual Private Catalogs"

  • "Upgrading Virtual Private Catalogs to Oracle Database 12c Release 1 (12.1.0.2)"

The following are new features in this release:

• Support for multitenant container databases and pluggable databases

  RMAN provides backup and recovery of multitenant container databases (CDBs), which are introduced in Oracle Database 12c Release 1 (12.1). This support includes backup and point-in-time recovery of specified pluggable databases (PDBs).

  See:

  • "Backing Up CDBs and PDBs"

  • "Performing Point-in-Time Recovery of CDBs and PDBs"

  • "Performing Crash and Instance Recovery of CDBs"

• SYSBACKUP Privilege

  The SYSBACKUP administrative privilege encompasses the permissions required for backup and recovery, including the ability to connect to a closed database. System administrators can grant SYSBACKUP instead of SYSDBA to users who perform backup and recovery, thus reducing the proliferation of the SYSDBA privilege. In contrast to SYSDBA, SYSBACKUP does not include data access privileges such as SELECT ANY TABLE.

  See:

  "Making Database Connections with RMAN"

• Storage Snapshot Optimization

  Storage Snapshot Optimization enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  See:

  • "Making Backups with Third-Party Snapshot Technologies"

  • "Recovery Using Storage Snapshot Optimization"

• SQL Interface Improvements

  You can now issue most SQL commands in RMAN without preceding the command with the SQL keyword. For a few commands that exist in both RMAN and SQL and have very different uses, you can specify the SQL keyword to eliminate ambiguity. You no longer need to enclose the SQL command in quotes, which greatly simplifies the syntax when the SQL command itself requires quotation marks. The SQL ALTER command replaces the RMAN command.

  The new RMAN DESCRIBE command provides the functionality of the SQL*Plus DESCRIBE command.

  See:

  Oracle Database Backup and Recovery Reference

• Multisection Backup Improvements

  RMAN provides multisection backup support for incremental backups and image copies. Wherever possible, unused block compression and Block Change Tracking are used in conjunction with multisection incremental backups. This improves backup and restore performance.

  See:

  • "Specifying Multisection Incremental Backups"

  • "Making Multisection Backups Using Image Copies"

• Restoring and Recovering Files Over a Network

  You can now restore or recover a database, data files, tablespaces, or control files by using backup sets from a physical standby database. RMAN transfers the backup sets, over the network, to the destination host. This is useful in a Data Guard environment when you want to synchronize the standby and primary databases.

  See:

  "Restoring and Recovering Files Over the Network"

• Active Database Duplication Improvements

  RMAN can now perform active database duplication using backup sets. When sufficient auxiliary channels are allocated, the auxiliary instance connects to the target instance and retrieves the backup sets over the network, thus reducing the processing load on the target instance. Unused block compression can be used during the duplication process, thus reducing the size of backups transported over the network. You can specify the binary compression level to be used. You can also encrypt backups and use multisection backups while performing active database duplication.

  See:

  "About Active Database Duplication with RMAN"

• Cross-Platform Backup and Restore Improvements

  You can transport data across platforms by using full and incremental backup sets. Incremental backups can reduce overall application downtime during cross-platform data migration.

  See:

  Transporting Data Across Platforms

• Recovering Tables and Table Partitions from RMAN Backups

  RMAN can recover tables and table partitions to a specified point in time from previously-created RMAN backups.

  See:

  Recovering Tables and Table Partitions from RMAN Backups

• Unified auditing and RMAN

  Unified auditing consolidates all the Oracle Database audit records into one single audit trail. To use unified auditing, you must first upgrade your database to Oracle Database 12c Release 1 (12.1) and then migrate your database to use unified auditing.

  See:

  • Oracle Database Upgrade Guide for details about migrating your database to use unified auditing

  • Oracle Database Security Guide for details about how to locate RMAN unified auditing information

• DUPLICATE enhancements

  You can specify that the duplicate database must not be opened using RESETLOGS after it is created. You may prefer not to open the duplicate database if you want to change the initialization parameters of the duplicate database or if opening the duplicate database may start services in the duplicate database that will conflict with the source database.

  See:

  "Specifying the State of the Duplicate Database"

The following chapter has been relocated:

• Chapter "Performing ASM Data Migration": This information is now included in the Oracle Automatic Storage Management Administrator's Guide.