单选题

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.

正确答案

来源:www.examk.com

答案解析

相似试题
  • 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?()  

    单选题查看答案