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…
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)- A81% (21)
- B4% (1)
- C4% (1)
- D12% (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
Community Discussion
No community discussion yet for this question.