You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()
A Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.
B Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
C Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
D Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.
正确答案
答案解析
相似试题
(单选题)
You are configuring for Oracle Shared Server. Which service is required? ()
(多选题)
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
(单选题)
How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()
(单选题)
In which situation are you NOT required to perform an incomplete recovery?()
(单选题)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
(单选题)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
(单选题)
You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()
(多选题)
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()
(单选题)
Which command would you use to determine what database backups are currently available for restore?()
(单选题)
Which command would you use to determine what database backups are currently available for restore?()