nerdexam
Oracle

1Z0-052 · Question #191

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: Which statement is true regarding the archived…

The correct answer is A. It will be created on the local file system. When LOG_ARCHIVE_DEST_1 specifies a local directory and no Flash Recovery Area is configured as an additional destination, archived redo log files are written exclusively to the local file system.

Performing Backup and Recovery

Question

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

Exhibit

1Z0-052 question #191 exhibit

Options

  • AIt will be created on the local file system.
  • BIt will be created only in the Flash Recovery Area.
  • CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default
  • DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location

How the community answered

(50 responses)
  • A
    78% (39)
  • B
    6% (3)
  • C
    12% (6)
  • D
    4% (2)

Why each option

When LOG_ARCHIVE_DEST_1 specifies a local directory and no Flash Recovery Area is configured as an additional destination, archived redo log files are written exclusively to the local file system.

AIt will be created on the local file system.Correct

With LOG_ARCHIVE_DEST_1 pointing to a local filesystem path and no competing destination parameters or db_recovery_file_dest configured, Oracle writes all archived logs to that single local directory, satisfying the archiving requirement without involving a Flash Recovery Area or remote location.

BIt will be created only in the Flash Recovery Area.

Archived logs are written only to the Flash Recovery Area when db_recovery_file_dest is set and no explicit LOG_ARCHIVE_DEST_n parameters are defined; when LOG_ARCHIVE_DEST_1 is set to a local path, the FRA is not used unless also configured as a separate destination.

CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default

A second destination such as the Flash Recovery Area default location would only be active if db_recovery_file_dest were also set alongside LOG_ARCHIVE_DEST_1, which is not indicated by the given parameter configuration.

DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location

A second explicit location would require an additional LOG_ARCHIVE_DEST_n parameter to be configured; without that, only the single destination defined by LOG_ARCHIVE_DEST_1 is used.

Concept tested: Oracle ARCHIVELOG mode archive destination configuration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/LOG_ARCHIVE_DEST_n.html

Topics

#archivelog mode#LOG_ARCHIVE_DEST#archive destination#Flash Recovery Area

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice