How to do a Restore and recovery of Single or multiple datafile from a PDB database on12c
(Doc ID 1565822.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Step1 :- Check the status of the file|
|Step 2 :- Restore the datafile 20 from backup.|
|Step 3 : Recover the datafile|