违法和不良信息举报 联系客服
免费注册 登录

You are working on the PROD database， which is in NOARCHIVEL

题目
单选题
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 working on the PROD database， which is in NOARCHIVEL”相关问题
相关内容