100. You database operates in ARCHIVELOG mode and user-managed consis
tent backups are performed every Sunday
night. On Tuesday, at 9:00 a.m. the current log sequence number was
369. Also, on Tuesday you lost the data file belonging to the SYSTEM
tablespace and an achivelog file (sequence number 356) that contained
redo entries between 8:00 a.m. and 8.30 a.m.
With reference to this scenario, what would you do to recover the dat
abase?
A. Restore all the data files from last Sunday's backup, and then per
form. a time-based recovery.
B. Restore all the data files from last Sunday's backup, and then per
form. a cancel-based recovery.
C. Restore all the data files from last Sunday's backup, and then per
form. a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from
last Sunday's backup, and then perform. a complete recovery.
Answer: B
丢失的归档文件,只能用基于cancel 的恢复
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718003/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
