QUESTION 18 LOG_ARCHIVE_DEST_1与DB_RECOVERY_FILE

QUESTION 18
Your database is running an ARCHIVELOG mode. The following parameters are set in your database instance:
LOG_ARCHIVE_FORMAT = arch_%t_%s_%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 because configuring the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters automatically enables flashback for the database.
C. They are created in the location specified by the LOG_ARCHIVE_DEST_1parameter and in the default location $ORACLE_HOME/dbs/arch.
D. They are created in the location specified by the LOG_ARCHIVE_DEST_1parameter and in the location specified by the DB_RECOVERY_FILE_DEST parameter.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
Explanation:
您可以选择将重做日志归档到单个目标或多个目标。目的地可以是本地的——在本地文件系统或Oracle自动存储管理(Oracle ASM)磁盘组中，也可以是远程的(在备用数据库上)。当您归档到多个目的地时，每个已填满的重做日志文件的副本将写入每个目的地。这些冗余副本有助于确保归档日志在目标之一出现故障时始终可用。若要仅归档到单个目的地，请使用LOG_ARCHIVE_DEST和LOG_ARCHIVE_DUPLEX_DEST初始化参数指定该目的地。ARCHIVE_DEST初始化参数。要将文件归档到多个目的地，可以选择使用LOG_ARCHIVE_DEST_n初始化参数将文件归档到两个或多个位置，或者使用LOG_ARCHIVE_DEST和LOG_ARCHIVE_DUPLEX_DEST初始化参数仅将文件归档到一个主目的地和一个辅助目的地。

最后

以上就是纯情手套最近收集整理的关于QUESTION 18 LOG_ARCHIVE_DEST_1与DB_RECOVERY_FILE的全部内容，更多相关QUESTION内容请搜索靠谱客的其他文章。