RMAN 12c Restrictions on PDB(Pluggable DataBase)

From Oracle Documentation:

Making RMAN Connections to a CDB

This section describes how to connect the RMAN client to multitenant container databases (CDBs) and pluggable databases (PDBs). It contains the following topics:

• About Backup and Recovery of CDBs
• Restrictions When Connected to a PDB
• Connecting as Target to the Root
• Connecting as Target to a PDB

About Backup and Recovery of CDBs

You can perform RMAN operations on a whole CDB, the root only, or one or more PDBs. You make RMAN connections to CDBs according to the following rules:

• To perform operations on the whole CDB (for example, to back up the whole CDB) you connect as target to the root.
• To perform operations on the root only (for example, to back up the root) you connect as target to the root.
• To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
  • If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use theBACKUP PLUGGABLE DATABASE command.
  • If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
• To perform operations on two or more PDBs with a single command, you connect as target to the root.
  For example, to back up both the sales and hr PDBs, you connect to the root and submit the following command:

  BACKUP PLUGGABLE DATABASE sales, hr;
  

Note:

If you connect as target to a CDB with operating system authentication, you are connected to the root.

Restrictions When Connected to a PDB

The following operations are not available when you connect as target directly to a PDB:

• Back up archived logs
• Delete archived logs
• Delete archived log backups
• Restore archived logs (RMAN does restore archived logs when required during media recovery.)
• Point-in-time recovery (PITR)
• TSPITR
• Table recovery
• Duplicate database
• Flashback operations
• Running Data Recovery Advisor
• Report/delete obsolete
• Register database
• Import catalog
• Reset database
• Configuring the RMAN environment (using the CONFIGURE command)

Note:

When you connect as TARGET to a PDB, you cannot connect to a recovery catalog.

Connecting as Target to the Root

There are several ways to connect as target to the root. The three most common ways are as follows:

• Connecting locally as a common user, as shown in Example 4-16
• Connecting with operating system authentication, as shown in Example 4-17
• Connecting as a common user through Oracle Net Services, using a net service name, as shown in Example 4-18

In all cases, you must connect as a user with the SYSDBA or SYSBACKUP privilege.

Example 4-16 connects locally to the root using the SYS user, which is a common user. The connection is established using the SYSDBA privilege.

Example 4-16 Connecting Locally to the Root

rman target sys

target database Password: password
connected to target database: CDB (DBID=659628168)

Example 4-17 connects locally to the root using operating system authentication. The connection is established as the SYS user with SYSDBA privilege.

Example 4-17 Connecting to the Root with Operating System Authentication

rman target /
 
connected to target database: CDB (DBID=659628168)

Example 4-18 assumes that there is a sales net service name that resolves to a database service for the root, and that there is a common user namedc##bkuser that has the SYSBACKUP privilege.

Example 4-18 Connecting to the Root with a Net Service Name

rman target c##bkuser@sales
 
target database Password: password
connected to target database: CDB (DBID=659628168)

Connecting as Target to a PDB

To connect as target to a PDB, you must:

• Connect with a net service name that resolves to a database service for that PDB.
• Connect as a local user or common user with the SYSDBA privilege.

Example 4-19 illustrates a connection to a PDB. It assumes the following

• You want to perform RMAN operations on a PDB named hrpdb.
• The net service name hrpdb resolves to a database service for the hrpdb PDB.
• The local user hrbkup was created in the hrpdb PDB and granted the SYSDBA privilege.

Example 4-19 Connecting As Target to a PDB

rman target hrbkup@hrpdb
 
target database Password: password
connected to target database: CDB (DBID=659628168)