Monday, September 24, 2018

Point In time Recovery (PITR) issue with PDB When Local Undo Is Enabled

Bug 27693713 - PDB PITR Does Not Apply Incrementals When Local Undo Is Enabled

DB PITR does not apply incremental backup when PDB is configured with local undo
 (select * from database_properties where property_name = 'LOCAL_UNDO_ENABLED' and PROPERTY_VALUE = 'TRUE');

When restore pluggable database noredo is executed, it is supposed to apply incremental backups. Instead, media recovery is being performed when PDB local undo is enabled. this can take a long time.
Bug info 27693713