Hello everyone,
On Saturday night we ingested a bunch of data that corrupted several tables in different database files. We have been trying to manually fix the data all week but have now come to the conclusion that we need to restore.
Unfortunately we do not have flashback enabled and our only backups are RMAN full backups. We cannot do a full RMAN backup however though as it will overwrite the data in other production tables which will not work.
My plan right now is to take a VMWARE snapshot of the database, load the RMAN backup from Friday night, export the respective tables using sql loader to an external drive, revert the snapshot back then load the old data into the tables using sql loader import.
However our lead DBA seems to think that there is another solution but will not say what that is.
So I was wondering if anyone has any other ideas that I might try,
Thanks in advance.