1Z0-062 Question #164: Real Exam Question with Answer & Explanation

Question

Options

• AThe instance does not start up normally and requires manual media recovery after a shutdown
• BUncommitted transactions are rolled back during the startup of the database instance after a
• CThere is no difference in the underlying mechanics of the startup whether the database is shut
• DMedia recovery is required when the database is shut down by using either the immediate option
• EInstance recovery is not required if the database instance was shut down by using SHUTDOWN

Explanation

Instance recovery is only triggered after an abnormal shutdown like SHUTDOWN ABORT or a crash, not after a clean shutdown using SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL.

Common mistakes.

• A. A clean shutdown leaves the database in a consistent state, so no media recovery is required on the next startup.
• B. Rolling back uncommitted transactions occurs during instance recovery after an abnormal shutdown, not during a normal startup that follows a clean shutdown.
• C. There is a significant difference - SHUTDOWN ABORT leaves the database in an inconsistent state requiring instance recovery, while NORMAL, IMMEDIATE, and TRANSACTIONAL shutdowns do not.
• D. Media recovery is unrelated to clean shutdowns and is only needed to repair physical damage to data files or apply archived redo logs, not as a consequence of SHUTDOWN IMMEDIATE or TRANSACTIONAL.

Concept tested. Oracle instance recovery vs. clean shutdown types

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/starting-up-and-shutting-down.html

No community discussion yet for this question.