In this scenario, we will show how to restore / recover the pluggable database;
The procedure of restore / recover of the database from Oracle 12c has changed compared to the previous versions of Oracle.
In this example, I will leave all the ORA/ RMAN errors I had to show how is different the restore from previous versions of Oracle database.
1- Create Table for test from :
2- Backup pluggable DB:
NOTE: here connect to pluggable DB;
3- Let’s Try to restore the pluggable database:
So, we need to run the restore from the Container DB session?
Ok let’s use rman backup through the container DB:
Ok that means we need to shutdown pluggable DB?
Let’s shutdown the pluggable DB and see.
Ok, Even with user “wissem” has sysdba privilege we got insufficient privileges error.
Let’s do it from COntainer DB and try ?
Ok, now DB shutdown; let ‘s try to restore the pluggable DB;
Note the syxtax of “restore pluggable database”, this is new in 12c.
Pluggable DB restored, let’s try the recover.
Note the syxtax of “recover pluggable database”; , this is new in 12c.
Good, we recovered the PDB; Let’s open the PDB;
From the output above, we restored / recovered the pluggable DB and we opened it READ WRITE Mode.