In Backup Exec, the pluggable database (PDB) recovery fails with MISSING datafile error, when the tablespace is removed

book

Article ID: 100044277

calendar_today

Updated On:

Description

Error Message

PDB Point In Time recovery fails with the following errors:

ORA-00376: file 13 cannot be read at this time
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/MISSING00013'

Resolution

To resolve this issue do one of the following:

  • Use recovery catalog for Pluggable database restore.
  • Restore entire (CDB) database.
  • Refer Oracle knowledge base link:- Document link- 2435452.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=436253616165202&id=2435452.1&_afrWindowMode=0&_adf.ctrl-state=889tsx17v_4

Note: This issue is reported for Oracle 12.2 and the fix will be included from Oracle in 18.1.

Issue/Introduction

In a multitenant environment on 12c (12.2) the pluggable database (PDB) point in time recovery fails when the tablespace is removed after backup.
Powered by Wolken Software