ORA-38793: cannot FLASHBACK the database to a future SCN/time

曾春华

ORA-38793: cannot FLASHBACK the database to afuture SCN/time

Cause: The Flashback Database targetSCN/timestamp is greater than the current

database SCN/timestamp and the database incarnation isnot the last opened

incarnation.

Action: If the target SCN/timestamp isin the current incarnation or a child

incarnation whose branch point is after the currentdatabase SCN then RECOVER

DATABASE to the target SCN/time. If the targetSCN/timestamp is in a child

incarnation whose branch point is prior to the current databaseSCN then

FLASHBACK DATABASE to before the branch point. Next useRMAN to reset the

database to the child incarnation. Finally, RECOVERDATABASE to the target

SCN/time.