I need to recover a dropped table, I have a RMAN backup of midnight and the table was dropped at 7:00 PM today. I do not have flash back enabled on the database. I am thinking of restoring mifnight backup adn applying the archives just before the table was dropped and opening the database in resetlogs method.
Is there any other way?
What, exactly, do you mean when you say " I do not have flash back enabled on the database"? Are you talking about flashback logging? Because that is not relevant here. Are you saying that you disabled the recycle bin?
Unless you proactively disabled the recycle bin, you should be able to
FLASHBACK TABLE table_name TO BEFORE DROP
which will recover the table from the recycle bin.
To recover from a dropped or truncated table, a dummy database (copy of primary) will be restored and recovered to point in time so the table can be exported.
Once the table export is complete, the table can be imported into the primary database. This dummy database can be a subset of the primary database.
please refer below MOS note for more info.
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [ID 223543.1]