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.
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.