ORA-38793: cannot FLASHBACK the database to a future SCN or time
Cause: The Flashback Database target SCN or timestamp is greater than the current database SCN or timestamp and the database incarnation is not the last opened incarnation.
Action: If the target SCN or timestamp is in the current incarnation or a child incarnation whose branch point is after the current database SCN then RECOVER DATABASE to the target SCN or time. If the target SCN or timestamp is in a child incarnation whose branch point is prior to the current database SCN then FLASHBACK DATABASE to before the branch point. Next use RMAN to reset the database to the child incarnation. Finally, RECOVER DATABASE to the target SCN or time.
Cause: The Flashback Database target SCN or timestamp is greater than the current database SCN or timestamp and the database incarnation is not the last opened incarnation.
Action: If the target SCN or timestamp is in the current incarnation or a child incarnation whose branch point is after the current database SCN then RECOVER DATABASE to the target SCN or time. If the target SCN or timestamp is in a child incarnation whose branch point is prior to the current database SCN then FLASHBACK DATABASE to before the branch point. Next use RMAN to reset the database to the child incarnation. Finally, RECOVER DATABASE to the target SCN or time.
No comments:
Post a Comment