Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Archive for June, 2019

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB

Posted by Mir Sayeed Hassan on 25th June 2019

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB Connect to the CDB Database Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target / Example: rman target sys/******@ora18c or rman target /  – The result will be same Connect… Read more..

Posted in RMAN | Comments Off on RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB

How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME    STATUS        VERSION —————————————— ora18c           OPEN         18.0.0.0.0 Check… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c

How to export the Pluggable full DB using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export the Pluggable full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME STATUS VERSION —————- ————————————— ora18c OPEN 18.0.0.0.0 Check the number of PDB’S exist in CDB [oracle@oracle18cdb… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Pluggable full DB using expdp utility in Oracle 18c

How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME   STATUS       VERSION ——————————————————— ora18c          OPEN         18.0.0.0.0 Create… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c