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?
A.
They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
B.
They are created only in the Fast Recovery Area.
C.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default
location $ORACLE_HOME/dbs/arch.
D.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location
specified by the DB_RECOVERY_FILE_DEST parameter.
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_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization 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.