nerdexam
Oracle

1Z0-032 · Question #51

When starting up the test database, you encounter the following error after mounting the database: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1…

The correct answer is D. Cancel-Based incomplete recovery. See the full explanation below for the reasoning.

Question

When starting up the test database, you encounter the following error after mounting the database:

ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/oracle/app/oradata/log2.log' ORA-27037: unable to obtain file status While investigating the reason, you find that the status of the redo log group 2 is CURRENT. Oracle 1Z0-032 Exam Which type of recovery would you perform to ensure that the database is functional?

Options

  • AOpen Database recovery
  • BTime-Based incomplete recovery
  • Crecovery using the backup control file
  • DCancel-Based incomplete recovery
  • EChange-Based incomplete recovery

How the community answered

(21 responses)
  • A
    5% (1)
  • C
    10% (2)
  • D
    81% (17)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice