Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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?()
Arestore all the data files from last Sunday’s backup, and then perform a timebased recovery
Brestore all the data files from last Sunday’s backup, and then perform a cancelbased recovery
Crestore all the data files from last Sunday’s backup, and then perform a changebased recovery
Drestore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery
正确答案
答案解析
相似试题
(单选题)
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()
(单选题)
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
(多选题)
Which are the prerequisites for performing flashback transactions on your database?()
(单选题)
If you create your database using Oracle Managed Files (OMF), what is 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?()
(单选题)
If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()
(单选题)
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
(单选题)
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
(单选题)
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()
(多选题)
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?()