| 1. |
Have You Faced Any Recovery Scenario? Explain How You Resolved It? |
|
Answer» 2 months BACK, a potential table was dropped by an APPLICATION developer on our large 24/7 RUNNING production database. Immediately he informed US. We have standby database for our production database. We checked that archives didn’t apply to standby database up to dropped timing. We stopped archive applying on standby immediately and open database read only. Took export of dropped table and imported in production database. After finishing appropriate CHECKING of table, again we started archive applying in standby database for refreshing. 2 months back, a potential table was dropped by an application developer on our large 24/7 running production database. Immediately he informed us. We have standby database for our production database. We checked that archives didn’t apply to standby database up to dropped timing. We stopped archive applying on standby immediately and open database read only. Took export of dropped table and imported in production database. After finishing appropriate checking of table, again we started archive applying in standby database for refreshing. |
|