RDBMS version: 11.2.0.4
OS : Oracle Linux 6.4
One of my application support team member accidently ran an UPDATE statement without a WHERE clause from SQL*Developer. The table which was being updated was 50GB in size. After realizing the mistake, he informed the DBA and his session was killed.
If that UPDATE (or any bad DMLs) managed to complete and COMMIT was issued, then it would have been a disaster.
How can I undo a bad UPDATE which is COMMITted in the DB? I would like to know the options available to me in such an emergency ? Is RMAN restore the only option ?