問題文
A report fails with an error about a damaged block in one large table, and the rest of the table is being read without trouble. Which statement describes the repair that fits this situation?
選択肢
- The whole data file is restored from a backup and then brought forward, and the data file is taken away from its users for the whole duration of that operation because the file has to be replaced first.
- The damaged blocks are repaired one by one from a backup and the logs, and the data file stays available to its users while that repair runs against the blocks that were reported as damaged.
- The database is rewound to the point before the damage appeared, and the changes that were made to the other tables after that point are applied again from the application side.
- The table is moved to another tablespace so that the damaged blocks are left behind, and the rows that lived in those blocks are reloaded from the application afterwards.