This preface contains:
Changes in Oracle Database Release 18c, Version 18.1
The following are changes in Oracle Database Backup and Recovery User’s Guide for Oracle Database release 18c, version 18.1.
Duplicate PDBs into an existing CDB
DUPLICATEcommand can be used to duplicate a PDB to an existing CDB.
Duplicate databases to Oracle Cloud
An on-premise Oracle database can be duplicated to Oracle Cloud Infrastructure Classic. Similarly, you can duplicate an Oracle database in Oracle Cloud Infrastructure Classic as an on-premise database.
Roll forward a physical standby
Improvements to the functionality for rolling forward a standby database result in a simplified procedure for performing this task.
RMAN backups usable after migration
RMAN backups of a non-CDB or PDB that were created before the non-CDB or PDB was migrated and plugged in to a different CDB can be used for recovery operations in the new CDB.
Shadow lost write protection
Data loss is minimized by fast detection and immediate response to data block lost rewrites.
Changes in Oracle Database 12c Release 2 (220.127.116.11)
The following are changes in the Oracle Database Backup and Recovery User’s Guide for Oracle Database 12c Release 2 (18.104.22.168).
Support for restore points in PDBs
You can create a PDB restore point, which is a restore point that is specific to a single pluggable database (PDB). Creating a PDB restore point for a particular PDB ensures that there are no name conflicts with restore points defined for other PDBs in the multitenant container database (CDB).
Flashback Database support for PDBs
You can perform a Flashback Database operation for a single PDB without impacting other PDBs in the multitenant container database (CDB). This enables you to rewind only the specified PDB, instead of the entire CDB, to a previous point in time. A Flashback Database operation on a particular PDB does not impact other PDBs in the CDB.
In Oracle Database 12c Release 1 (12.1), to perform a flashback database operation for a CDB across PDB point-in-time recovery (PITR), you had to make all data files in the PDB for which PITR was performed offline. This restriction is now removed. You can perform a flashback database operation on a CDB across PDB PITR or PDB flashback with
COMPATIBLEset to 12.2 or higher.
Enhancements to recovering tables and table partitions
Before performing table recovery, RMAN checks if there is sufficient space on the target host to create the auxiliary instance that is used during recovery. You can also recover tables and table partitions into a schema that is different from the source schema in which they originally existed.
Enhancements to cross-platform transport
You can perform cross-platform transport of a PDB into a new CDB. Encrypted tablespaces can be transported across platforms. You can also restore and recover files across platforms and over the network.
Enhancements to database duplication
You can use the
DUPLICATEcommand to create an Oracle Data Guard far sync instance.
Backup and recovery support for application containers
You can use RMAN to perform backup, complete recovery, and point-in-time recovery of application containers. This includes the application root and one or more application PDBs.
Backup and Recovery of Sparse Databases
RMAN enables you to perform backup, recovery, and backup-based duplication for sparse databases with the
COMPATIBLEinitialization parameter set to 12.2 or higher. You can also backup and recover individual sparse data files, tablespaces, CDBs, and PDBs.
Changes in Oracle Database 12c Release 1 (22.214.171.124)
The following are changes in Backup and Recovery User's Guide for Oracle Database 12c Release 1 (126.96.36.199).
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.
Changes in Oracle Database 12c Release 1 (188.8.131.52)
The following are changes in Backup and Recovery User's Guide for Oracle Database 12c Release 1 (184.108.40.206).
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).
SYSBACKUPadministrative privilege encompasses the permissions required for backup and recovery, including the ability to connect to a closed database. System administrators can grant
SYSDBAto users who perform backup and recovery, thus reducing the proliferation of the
SYSDBAprivilege. In contrast to
SYSBACKUPdoes not include data access privileges such as
SELECT ANY TABLE.
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
BACKUPmode. You can then use the snapshot to recover all or part of the database.
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
SQLkeyword 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
ALTERcommand replaces the RMAN command.
The new RMAN
DESCRIBEcommand provides the functionality of the SQL*Plus
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.
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.
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.
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.
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.
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.
You can specify that the duplicate database must not be opened using
RESETLOGSafter 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.