ALTER DATABASE BEGIN BACKUP triggers ORA-65011 (Doc ID 1989773.1)

Last updated on JULY 29, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Prior to "Alter database backup",  If any pdb is dropped , it causes issue

SQL> alter database begin backup;

alter database begin backup
*
ERROR at line 1:
ORA-65011: Pluggable database does not exist.

 

 

== Test Case ==

SQL> SELECT pdb_name, status FROM dba_pdbs ORDER BY pdb_name
PDB_NAME STATUS
-------------------- ---------
PDB$SEED NORMAL
PDB1 NORMAL
PDB2 NORMAL
PDB3 NORMAL <=======
SQL> ALTER PLUGGABLE DATABASE pdb3 CLOSE;
 
SQL> DROP PLUGGABLE DATABASE pdb3 INCLUDING DATAFILES;
 
SQL> SELECT pdb_name, status FROM dba_pdbs ORDER BY pdb_name
PDB_NAME STATUS
-------------------- ---------
PDB$SEED NORMAL
PDB1 NORMAL
PDB2 NORMAL
>>> pdb3 NOT listed in dba_pdbs view
 
SQL> alter database begin backup;
alter database begin backup
*
ERROR at line 1:
ORA-65011: Pluggable database does not exist.
 
 

 

 

 

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms