Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()
A open the database with the RESTRICTED option
B open the database with the RESETLOGS option
C recover to the required SCN only that data file in which the error occurred
D recover all the data files to the same system change number (SCN)
正确答案
答案解析
相似试题
(单选题)
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?()