How to do a Restore and recovery of Single or multiple datafile from a PDB database on12c
(Doc ID 1565822.1)
Last updated on JANUARY 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
PDB name: pdbtest
PDBTEST path: /cdb1/cdb1/pdbtest
PDBTEST tablespace name: TEST
PDBTEST tablespace test datafile: /cdb1/cdb1/pdbtest/sh.dbf
PDBTEST TNS connect string: pdbtest
RMAN backup location: /cdb1
The 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 service name 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|