I have the following setup

Database is in archive log mode and one particular table got corrupted or dropped. How can I recover that one table ONLY when database is online and people are working?

I have been reading up about point in time recovery I dont think that is what
I want to do. My understanding is that will bring the entire database to a state as of a particular time.

Most of the test cases I see online mention restoring all the datafiles (not control files and logs). I don't think that is what I want to do either since that
will affect the people working.

Can somebody outline the steps I need to follow to test this scenario or point me to some good online documenation that explains how to do this. My gut
feeling tells me this sounds a bit complex.


Thanks in advance to all who answer this post