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_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.
A
A.
They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
I believe it should be D.
A. Tested
Note : The parameter DB_RECOVERY_FILE is incorrect, would be DB_RECOVERY_FILE_DEST.
A – OK – tested
if 2 parameter exist then arch only be created in LOG_ARCHIVE_DEST_1 no in FRA
ORACLE dont have that parameter DB_RECOVERY_FILE
A
A
I think there is an typing error in the question
DB_RECOVERY_FILE_DEST_SIZE = 50G
DB_RECOVERY_FILE = ‘/u01/oradata’
should be
DB_RECOVERY_FILE_DEST_SIZE = 50G
DB_RECOVERY_FILE_DEST = ‘/u01/oradata’
with this assumptin it is : D
Normally you will get an LRM-00101: unknown parameter name ‘DB_RECOVERY_FILE’
at instance startup with the unknown parameter DB_RECOVERY_FILE.
A
D is wrong :
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11338
If you configure a Fast Recovery Area (by setting the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters) and do not specify any local archive destinations, the database automatically selects the Fast Recovery Area as a local archive destination and sets LOG_ARCHIVE_DEST_1 to USE_DB_RECOVERY_FILE_DEST.
——————–
If you use the LOCATION keyword, specify one of the following:
…
The keyword USE_DB_RECOVERY_FILE_DEST to indicate the Fast Recovery Area
A is correct. Tested . 12c db on Linux.
You are so awesome! I don’t believe I’ve truly read through something like that before. So wonderful to discover somebody with some unique thoughts on this subject. Really.. thank you for starting this up. This site is one thing that’s needed on the internet, someone with some originality!|