Chat now with support
Chat with Support

NetVault Plug-in for Oracle 12.3 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the plug-in with Oracle RAC Using the plug-in in a failover cluster environment Using the plug-in with Oracle Data Guard Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

Oracle PDBs: an overview

With Oracle Multitenant Architecture, you can create an Oracle database that functions as a multitenant Container Database (CDB). You also can create non-CDB databases. In a CDB, you can create one or more Pluggable Databases (PDBs) or you can opt not to create any. A PDB is a portable collection of Oracle schemas, schema objects, and nonschema objects that are presented to an Oracle client as a non-CDB database. Prior to Oracle Database 12c, all Oracle databases were non-CDBs. For more information, see the Oracle 12c Multitenant Architecture documentation.

Enabling connection to a PDB

To connect to a PDB that you have created, you must ensure that an entry is added in the Oracle “tnsnames.ora” file and the status of the PDB is in read-write mode. When a PDB is created, a default Oracle service with the same name as the Pluggable Database name is created automatically. However, an entry to the “tnsnames.ora” file might not have been added.

The following is an example of a “tnsnames.ora” file with only an entry of a CDB called salesdb:

If not, add the entry manually. The following example shows a manually edited “tnsnames.ora” file after two PDBs, sales_region200_pdb and sales_region300_pdb, have been created:

Querying CDB, PDB, and non-CDB databases

You can perform various queries of the databases by using SQL*Plus.

The following is an example of the query and response for a non-CDB database:

The following is an example of the query and response for a CDB database:

You can list the containers in a CDB. For example:

You can list the PDBs and their status in a CDB. For example:

Restrictions for backing up and restoring a PDB

If you intend to target a PDB for backup and restore jobs, be aware that the following operations are not available:

Using the CONFIGURE command
Using the IMPORT CATALOG command
Using the REGISTER DATABASE command
Using the RESET DATABASE command
Related Documents