How to Recover CDB and PDBs After Restore

You can recover the CDB and PDBs only after restoring the full database manually or using advanced agent options.

Follow these steps:

  1. After the CDB recovery, restart the database and open PDBs.
  2. Connect to CDB.
  3. Execute the following SQL command to open PDBs:
  4. alter pluggable database all open;
  5. To view PDBs status, execute the following command:
  6. SELECT name, open_mode from v$pdbs;

For more information, refer Recover Complete Databases.