Oracle Dropped PDB database not getting restored when using LOCAL_UNDO_MODE.

book

Article ID: 100048364

calendar_today

Updated On:

Description

Error Message

Restore job will complete and not report any error but PDB database will be missing on completion of restore.

Cause

This issue is caused due to an Oracle Defect - Bug 27966859

This issue will not be seen if the PDB database is in SHARED_UNDO_MODE with auxiliary path defined.

Solution

Workaround:-

PIT restore of dropped pluggable database will work with SHARED_UNDO_MODE and auxiliary path configured.

For databases which are already in LOCAL_UNDO_MODE please check the below Oracle SR or contact Oracle Support team for alternate options to restore the database. 

Reference:- Oracle Support: SR 3-22797947541

Issue/Introduction

Oracle Dropped PDB database not getting restored when using LOCAL_UNDO_MODE.