(Single) Table Recovery
Every DBA should know this situation. You receive a call from a user or customer. After executing a wrong command, for example, a DELETE without a correct WHERE clause or a script against the production database instead of the test database, the data of one or more tables have now a wrong state.
A rollback can solve this problem quickly, but what are the options when the transaction is already committed? In this presentation, I will explain possible ways to restore the state of a single table.
- Flashback Query/Table/Transaction
- Table Recovery using RMAN
- Export/Import
- LogMiner"
Tagged under
Leave a comment
- Speaker:
- Christian Gohmann
- Podjetje
- Trivadis - Part of Accenture