Redologfilesarenotmultiplexedinyourdatabase.Redologbloc

单项选择题

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）

A.RECOVER LOGFILE BLOCK GROUP 2；
B.ALTER DATABASE DROP LOGFILE GROUP 2；
C.ALTER DATABASE CLEAR LOGFILE GROUP 2；
D.ALTER DATABASE RECOVER LOGFILE GROUP 2；
E.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；

相关考题

单项选择题 Youareusingthefollowingcommandtoclearthelogfilegroup：ALTERDATABASECLEARLOFFILEGROUP2；Inwhichcasewouldthecommandbesuccessful？（）

单项选择题 You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files. How would you recover the database from this situation？（）

单项选择题 IntheinstanceofthePRODdatabase，thecheckpoint（CKPT）processrunsaftereveryminute.AdatabaseuserupdatestherowsoftheORDERStable.Becauseoftheconfiguration，theCKPTprocessgetsinitiatedbeforetheusercommitsthetransaction.WhatwouldhappentothemodifiedblockswhentheCKPTprocessisstarted？（）

1Z0-042