Aug 01

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:1
ORA-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 tracked this down the fact that I’m closing the cloned PDB with ABORT. If I close IMMEDIATE, I do not get the error. Here is an example of where I received the error twice with ABORT but not with IMMEDIATE, so I do have my workaround.

SQL> alter pluggable database dba1 close abort instances=all;
alter pluggable database dba1 close abort instances=all
*
ERROR at line 1:
ORA-65107: Error encountered when processing the current task on instance:1
ORA-16078: media recovery disabled

SQL> alter pluggable database dba1 close immediate instances=all;

Are these physical therapies safe? generic professional viagra Physical therapies are very safe if they are applied by expert hands and at the right times. These side-effects are very common and stay buy cialis go to this pharmacy for very short time but in rare cases, it might develop suddenly. You can cialis sildenafil purchase any of the products that are less effective and fake here; all are approved from the USFDA. However, sometimes it so happens that cialis viagra the organ is too stressed or strained, or even too weak due to medical reasons.

Pluggable database altered.

SQL> alter pluggable database dba1 open instances=all;

Pluggable database altered.

SQL> alter pluggable database dba1 close abort instances=all;
alter pluggable database dba1 close abort instances=all
*
ERROR at line 1:
ORA-65107: Error encountered when processing the current task on instance:1
ORA-16078: media recovery disabled

SQL> alter pluggable database dba1 close immediate instances=all;

Pluggable database altered.

bpeasland