报错:
ORA-01516: nonexistent log file, data file, or temporary file
ORA-65054: Cannot open a pluggable database in the desired mode. ORA-01109: database not open ERROR at line 1: ORA-01157: cannot identify/lock data file 13 - see DBWR trace file ORA-01110: data file 13: '/oradata/esb/system01.dbf' ERROR at line 1: ORA-01516: nonexistent log file, data file, or temporary file "/oradata/esb/system01.dbf" in the current container
错误挺多的,最后还是因为没有弄清cdb和pdb,如果需要把损坏的dbf文件下线,需要切换到Pdb库里面才能进行drop操作。
切记切记。
SQL> alter database open; alter database open * ERROR at line 1: ORA-01157: cannot identify/lock data file 15 - see DBWR trace file ORA-01110: data file 15: '/oradata/esb/undotbs01.dbf' SQL> alter session set container=esb; Session altered. SQL> alter database datafile '/oradata/esb/undotbs01.dbf' offline drop; Database altered. SQL> alter session set container=CDB$ROOT;
------------正 文 已 结 束, 感 谢 您 的 阅 读 (折雨的天空)--------------------
转载请注明本文标题和链接:《oracle 18c在CentOS下,因为PDB数据库的数据文件损坏而无法启动的问题》
发表评论