nerdexam
Oracle

1Z0-062 · Question #217

Your database is running in NOARCHIVING mode. Examine the following parameters: You execute the following command after performing a STARTUP MOUNT: SQL> ALTER DATABASE ARCHIVELOG; Which statement is…

The correct answer is C. It fails and returns an error about LOG_ARCHIVE_DEST not being set. When the parameters shown indicate no valid archive log destination is configured, Oracle cannot enable ARCHIVELOG mode and the ALTER DATABASE ARCHIVELOG command fails with an error.

Performing Backup and Recovery

Question

Your database is running in NOARCHIVING mode. Examine the following parameters:

You execute the following command after performing a STARTUP MOUNT:

SQL> ALTER DATABASE ARCHIVELOG; Which statement is true about the execution of the command?

Options

  • AIt executes successfully and sets the Fast Recovery Area as the local archive destination.
  • BIt executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the
  • CIt fails and returns an error about LOG_ARCHIVE_DEST not being set.
  • DIt executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

How the community answered

(24 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    75% (18)
  • D
    13% (3)

Why each option

When the parameters shown indicate no valid archive log destination is configured, Oracle cannot enable ARCHIVELOG mode and the ALTER DATABASE ARCHIVELOG command fails with an error.

AIt executes successfully and sets the Fast Recovery Area as the local archive destination.

The Fast Recovery Area is only used as an automatic archive destination when DB_RECOVERY_FILE_DEST is explicitly configured; if it is not set in the parameters shown, Oracle cannot fall back to it.

BIt executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the

Oracle does not issue a warning and continue when enabling ARCHIVELOG mode without a valid destination; the command either succeeds or fails outright based on the archive destination configuration.

CIt fails and returns an error about LOG_ARCHIVE_DEST not being set.Correct

Based on the parameters examined, LOG_ARCHIVE_DEST and DB_RECOVERY_FILE_DEST are not set to valid destinations; Oracle requires at least one mandatory archive destination to be defined before it can switch to ARCHIVELOG mode, and without one it returns an ORA error rather than proceeding.

DIt executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

Oracle does not silently default to $ORACLE_HOME/dbs as the archive destination in this scenario; a valid LOG_ARCHIVE_DEST or DB_RECOVERY_FILE_DEST must be defined for the mode switch to succeed.

Concept tested: Enabling ARCHIVELOG mode with required archive destination parameters

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-log-files.html

Topics

#ARCHIVELOG mode#NOARCHIVELOG mode#LOG_ARCHIVE_DEST#database startup

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice