(Single) Table Recovery

Petek, 2. junij 9:00 - 9:45
Težavnost: Intermediate
Dvorana: A
Področje: Database development
Jezik: Angleščina

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"

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Christian Gohmann
Trivadis - Part of Accenture