With reference to this scenario, what would you do to recover the database?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *