Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-39886

With shared undo, one can only use an SQL command to flashback a pluggable database (PDB) to a clean PDB restore point.

Cause

The command issued did not specify a clean pluggable database restore point. For a pluggable database using shared undo, one can only use the SQL Flashback pluggable database command to flashback to a clean pluggable database restore point.


Action

Do one of the following:

  • Issue flashback pluggable database in RMAN.
  • Issue the SQL flashback pluggable database command to flashback to a clean pluggable database restore point.
  • Turn on local undo mode for the pluggable database. The SQL flashback pluggable database command can always be used to flashback a pluggable database using local undo.