How to do a Restore and recovery of Single or multiple datafile from a PDB database on12c
Last updated on APRIL 21, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 12.1]
Information in this document applies to any platform.
Goal of this Article is do a restore and recovery of a datafile From PDB when one or couple of datafiles associated with PDB are corrupted or lost.
Before we start Please understand the following Terms used in 12c.
What is a multitenant container database ?
A 12c database is either a non-Container Database or a Container Database - referred to as non-CDB or CDB respectively.
A CDB is an Oracle database that includes zero, one, or many customer-created Containers or Pluggable Databases referred to as PDB.
The CDB has:
- one ROOT container (CDB$ROOT) containing SYSTEM, SYSAUX, UNDO, and TEMP tablespaces, Controlfiles and Redologs
- one SEED container (PDB$SEED) containing SYSTEM, SYSAUX, TEMP, EXAMPLE tablespaces, used as a template to create new PDBs
What is a Pluggable Database?
A pluggable Database (PDB) is a user-created container holding the data for any application.
A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.
Change done to Pdb database would be written to the Undo /redo present in the CDB$ROOT.
By Default When you Connect as sysdba without any servicename you connect to Root Container
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms