My Oracle Support Banner

OPEN中のPDBでメディア障害が発生した場合にPDB単体をクローズできない(KROWN:166311) (Doc ID 1768322.1)

Last updated on MARCH 10, 2019


Oracle Database - Enterprise Edition - バージョン から [リリース 12.1]
Oracle Database Cloud Schema Service - バージョン N/A 以降
Oracle Database Exadata Cloud Machine - バージョン N/A 以降
Oracle Cloud Infrastructure - Database Service - バージョン N/A 以降
Oracle Database Backup Service - バージョン N/A 以降



SQL> alter pluggable database pdb1 close immediate;
alter pluggable database close immediate
ERROR at line 1:
ORA-1116: error in opening database file 8
ORA-1110: data file 8: '/XXX/system01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


RMAN> restore pluggable database pdb1;

ORA-19573: cannot obtain exclusive enqueue for datafile 9

SQL> alter session set container=pdb1;
SQL> recover automatic database;

ORA-01126: database must be mounted in this instance and not open in any instance.



To view full details, 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 a vibrant support community of peers and Oracle experts.