New Features

• PLUGGABLE DATABASE clause in GRANT and REVOKE commands

  You can grant and revoke privileges on a specific PDB to a database user. See GRANT and REVOKE.

• Recovery catalog support for PDBs

  You can connect to the recovery catalog when you are connected to a target PDB.

  See CONNECT.

New Features

• Duplicate PDBs to an existing CDB

  The DUPLICATE PLUGGABLE DATABASE command is used to duplicate a PDB to an existing CDB.

  See Also:

  DUPLICATE

• Duplicate databases to Oracle Cloud

  An on-premise database can be duplicated to Oracle Cloud. Similarly, you can duplicate a database in Oracle Cloud as an on-premise database.

  See Also:

  AS ENCRYPTED and AS DECRYPTED clauses in DUPLICATE

• 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 target CDB can be used for recovery operations in the target CDB.

  See Also:

  • BACKUP

  • RESTORE

  • RECOVER

New Features

• Perform flashback on a pluggable database (PDB) to a specified point in time

  You can perform a flashback database operation to rewind an individual PDB to a previous point in time. This enables you to reverse unwanted changes made to a single PDB without impacting the operation of the remaining PDBs.

  See FLASHBACK DATABASE.

• Validation and recovery of nonlogged data blocks

  In a Data Guard environment, you can perform recovery of nonlogged data blocks by fetching data blocks from the primary or physical standby database. You can also perform validation to determine if the data blocks in the nonlogged block ranges are still invalid.

  See RECOVER and VALIDATE.

• Enhancements to table recovery

  You can use the REMAP TABLE clause to recover tables or table partitions into a schema that is different from the schema in which these objects originally existed.

  See RECOVER.

• Enhancements to the DUPLICATE command

  Use the FOR FARSYNC clause of the DUPLICATE command to create an Oracle Data Guard far sync instance by duplicating a target database.

  DUPLICATE

  To duplicate a database that uses transparent encryption with a password-based keystore, the password used to open the keystore is provided to the auxiliary instance using the SET DECRYPTION WALLET OPEN command.

  SET

• Enhancements to cross-platform transport

  RMAN supports cross-platform transport of a PDB into a target CDB. You can perform cross-platform transport of tablespaces over the network. Encrypted tablespaces can also be transported to different platforms.

  See BACKUP, RECOVER, RESTORE, and foreignFileSpec.

• Backup and Recovery of Sparse Databases

  RMAN enables you to backup, restore, recover, and duplicate sparse data files, tablespaces, CDBs, PDBs, and whole databases with the COMPATIBLE initialization parameter set to 12.2 or higher.

  See BACKUP, DUPLICATE, RECOVER, RESTORE