【oracle】oracledba22 cancel-based recovery，cwmbasedrecovery
The current time is 12:00 noon. You want to recover the USERS tablespace
from a failure that occurred at 11:50 a.m. You discover that
the only member of an unarchived redo log group containing information
from 11:40 a.m. onwards is corrupt.
With reference to this scenario, if you are not using Recovery Manager (RMAN),
which recovery method would you use?
A. time-based recovery
B. log sequence recovery
C. cancel-based recovery
D. change-based recovery
Answer: C
使用 recover database until cancel 进行恢复时，可以一直输入回车，直到没有归档
日志文件可用为止（在这种情况下，若已经将所有的在线日志文件归档，那么利用这种情况
可以恢复所有的数据）；也可以在恢复的过程中，输入 CANCEL，利用一部分归档日志文件
进行恢复（这种情况可能只能恢复一部分数据）。
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。