User deleted prod data 12/9 it's now 12/22
Greetings,
History:
I have 12.1 EE standalone database that I'm in the process of upgrading. Lots of ppl working on it.
User deleted data out of table1 12/9 @ ~noon. I restored table1 from 12/8 backup into non-prod database.
The goal is to recover table until 12/9 @ 20:00, I have archive logs for prod.
However, I can't use prod logs on non-prod DB. So this is of no use.
Action Plan:
So I have to restore table1 to table2 on prod, then "recover table2 until time." Lastly, drop table1 and rename table2 to table1.
Questions:
How to "recover table2 until time"? Table2 did not exist when I did the backup. So I don't have a backup of table2.