Oracle 12cR2 | Recover PDB$SEED using existing PDB | Without Backup | Recreating PDB$SEED | Part 2

Recover PDB$SEED using existing PDB without backup:

In the previous video, I have explored the method of recovering a seed pluggable database using a VALID seed pluggable database backup. In this video, I will explore the process of recovering or recreating a seed pluggable database when there is no backup available. In the event of seed pluggable database being in a unusable state (corrupted/datafile missing), we can recreate the seed pluggable database using any of the existing pluggable database (local or remote).

Let me demonstrate this method, with a quick example. In the following example, the seed pluggable database file is missing and we are not able to use it for creation of new pluggable databases.

Since, we do not have a backup available for the seed pluggable database, we can't restore the missing files as demonstrated in the earlier video. We need to drop and recreate a fresh seed pluggable database using any of the existing pluggable databases (local or remote)

Let's drop the seed pluggable database PDB$SEED from the container database.

Please follow the blog for complete steps:

Regards,
Ramesh.

Follow Me On:

WhatsApp Channel: Oracle F1

[anujsharma]

You r doing good job this kind of rare topics, so without backup need down time for the existing pdbs because we need to close the existing pdbs and then only we can create pd$seed so this requires downtime. I have one question default backup of entire cdb will be also having the backup of pdb$seed correct? If yes then we can restore pdb$seed from that cdb backup or not?