nerdexam
Oracle

1Z0-060 · Question #6

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = LOCATION = /disk1/archive'…

The correct answer is A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter. You can choose to archive redo logs to a single destination or to multiple destinations. Destinations can be local--within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group--or remote (on a standby database). When you archive to multiple…

New Features for Availability

Question

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance:

LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = LOCATION = /disk1/archive' DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = /u01/oradata' Which statement is true about the archived redo log files?

Options

  • AThey are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
  • BThey are created only in the Fast Recovery Area.
  • CThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the
  • DThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location

How the community answered

(26 responses)
  • A
    81% (21)
  • B
    4% (1)
  • C
    4% (1)
  • D
    12% (3)

Explanation

You can choose to archive redo logs to a single destination or to multiple destinations. Destinations can be local--within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group--or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations. To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DESTandLOG_ARCHIVE_DUPLEX_DESTinitialization parameters. ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

Topics

#ARCHIVELOG mode#LOG_ARCHIVE_DEST#Fast Recovery Area#archive destination precedence

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice