RECOVER(恢復) command: Recovers restored files by applying changes recorded in the redo log files.
- 完全恢復(complete recovery)與不完全恢復(incomplete recovery)
- Complete recovery
Bring the database to the state where it is fully up-to-date, including all committed data modifications to the present time. - Incomplete recovery
Bring the database to some point in the past. This means there are missing transactions; any data modifications done between the recovery destination time and the present are lost. In many cases, this is the desirable goal because there may have been some changes made to the database that need to be undone. Recovering to a point in the past is a way to remove the unwanted changes.
沒有留言:
張貼留言