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.
正确答案
答案解析
相似试题
(单选题)
you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
(多选题)
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
(单选题)
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
(单选题)
For which database operation would you need the database to be in the MOUNT state()
(多选题)
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
(多选题)
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
(单选题)
In which scenario do you use the Flashback Database feature?()
(单选题)
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()
(单选题)
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords?()
(单选题)
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()