My Oracle Support Banner

Pluggable database (PDB) recovery fails with ORA-01113 ORA-01110 (Doc ID 2783610.1)

Last updated on MAY 02, 2024

Applies to:

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

Symptoms

Recovery of pluggable database has been completed but "alter pluggable database <PDB_NAME> open" fails with an error.

ORA-01113: file <FILE_NUMBER> needs media recovery
ORA-01110: data file <FILE_NUMBER> : '<PATH/FILE_NAME>'

Failure seen in RMAN and SQLPLUS session as well:

SQL> alter session set container= <CONTAINER_NAME>;

Session altered.

SQL> show pdbs

   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
       18 <CONTAINER_NAME>             MOUNTED


SQL> recover datafile <FILE_NUMBER>;
Media recovery complete.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file <FILE_NUMBER> needs media recovery
ORA-01110: data file <FILE_NUMBER> : '<PATH/FILE_NAME>'

 

Checkpoint_time in v$datafile_header and v$datafile shows no issues.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.