Exam 1z0-062 topic 1 question 231 discussion

Answer: B. – https://docs.oracle.com/cd/B19306_01/backup.102/b14191/recoscen.htm#BRADV229

I think B should be correct. Because "active and current redo log files is needed for instance reoovey"

Both Active and current logs are required for instance recovery.

https://docs.oracle.com/database/121/ADMIN/onlineredo.htm#ADMIN11302 11.1.3.1 Active (Current) and Inactive Redo Log Files Oracle Database uses only one redo log file at a time to store redo records written from the redo log buffer. The redo log file that LGWR is actively writing to is called the current redo log file. Redo log files that are required for instance recovery are called active redo log files. Redo log files that are no longer required for instance recovery are called inactive redo log files. If you have enabled archiving (the database is in ARCHIVELOG mode), then the database cannot reuse or overwrite an active online log file until one of the archiver background processes (ARCn) has archived its contents. If archiving is disabled (the database is in NOARCHIVELOG mode), then when the last redo log file is full, LGWR continues by overwriting the next log file in the sequence when it becomes inactive.

It's B look at : https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm

B is right answer

B • CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed. • ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived. • INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.

C is right answer... since the information in active logs is already been reflected in data files. so no need to recover them..

Correct: B https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89046

active redo log is corrupted so how it can be used for recovery?