Hello all,
I have a task (no business reason, just for examination) to restore an accidentally dropped table without FLASHBACK technology, using an user-managed hot backup of a primary database and standby.
So, I am confused how can I do that with a standby database, if this is a fully mirrored primary database. All changes in primary are applied to standby, thus dropped table in primary will be dropped in standby too.