August 2019 archive

It’s In The Details

I have an Oracle 12.1.0.2 Multitenant database that I’m trying to remove a PDB from. However, I mistakenly removed the storage from the database server and the PDB cannot access its files. When unplugging the PDB, I get the following error: SQL> alter pluggable database GOLD2019_08_22_125953 unplug into ‘/tmp/GOLD2019_08_22_125953.xml’; alter pluggable database GOLD2019_08_22_125953 unplug into …

Continue reading

PDB Unplug ORA-17528 Error

I am trying to remove a PDB in Oracle 19.3 that is no longer needed. I get the following error: SQL> alter pluggable database DEV_PDB close immediate instances=all; Pluggable database altered. SQL> alter pluggable database DEV_PDB unplug into ‘/tmp/DEV_PDB.xml’; alter pluggable database DEV_PDB unplug into ‘/tmp/DEV_PDB.xml’ * ERROR at line 1: ORA-17500: ODM err:Invalid argument …

Continue reading

19.3 PDB Close ORA-65107 ORA-16078

When closing a cloned PDB in 19.3, I am receiving the following errors: ORA-65107: Error encountered when processing the current task on instance:1ORA-16078: media recovery disabled This may exist in 12.2 or 18c, but I skipped those versions. If anyone has info if this is an issue in the versions I skipped, comment below. I …

Continue reading