试题详情
单项选择题You database operates in ARCHIVELOG mode and user-managed consistent 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 database?()

A、 Restore all the data files from last Sunday’s backup, and then perform a time-based recovery.

B、 Restore all the data files from last Sunday’s backup, and then perform a cancel-based recovery.

C、 Restore all the data files from last Sunday’s backup, and then perform 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.

  • B
  • 关注下方微信公众号,在线模考后查看

热门试题