Flashback Oracle Database - Shutdown abort

255 Views Asked by At

If I killed a long transaction that is rolling back millions of deleted records, is there any risk to use SHUTDOWN ABORT on the DB before issuing a flashback command on it? Since the Database needs only to be in MOUNT state for the flashback, I would expect that there is no harm to do this instead of waiting for the rollback to complete.

0

There are 0 best solutions below