OCP CBT Question 513

Please solve the following question.

You are managing a production database where the Fast Recovery Area (FRA) is not configured. The database is in ARCHIVELOG mode, and archived redo logs are written to /u01/app/oracle/arch. Due to a disk space issue, the /u01/app/oracle/arch directory became full, preventing further archived redo log generation. Consequently, the database hung. After resolving the disk space issue by adding more space, you are attempting to restart the database.Which statement is true regarding the database state and potential recovery impact?

sql-- Assume the database was force-shutdown due to the hang.-- You resolved the disk space issue.

The database will start successfully, but any transactions committed during the period when archive logs could not be written will be unrecoverable if a media failure occurs.

The database will require media recovery to open successfully, even if no datafiles were lost, because of the missing archive logs.

The database will open successfully without requiring any recovery, as long as no datafiles were lost.

The database will remain in a hung state until all missing archived redo logs are manually created.