Scenario: A critical table in the database was accidentally deleted. What recovery strategy can the DBA employ to restore the table and minimize data loss?

  • Manually recreate the table structure and insert data from application logs.
  • Perform a table-level restore from the last backup and apply transaction logs to recover data up to the point of deletion.
  • Roll back the entire database to the state before the deletion occurred.
  • Use DB2's flashback feature to recover the table to its state before deletion.
To restore a critical table accidentally deleted in DB2, the DBA can perform a table-level restore from the last backup and apply transaction logs to recover data up to the point of deletion. This strategy helps minimize data loss by selectively restoring only the affected table without affecting the rest of the database. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *