The database is running in ARCHIVELOG mode. Examine the initialization parameters and their
values set to enable archiving on your database server:
LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
DB_RECOVERY_FILE_DEST_SIZE = 20G
Which statement is true regarding the archived redo log files?
A.It will be created on the local file system.
B.It will be created only in the Flash Recovery Area.
C.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
D.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.
答案：A
解析：
1.LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOCATION表示归档文件存放在本地磁盘上
2.DB_RECOVERY_FILE_DEST = '/u01/oradata'
表名fra的路径,这里表明归档文件没有放在fra中
3.DB_RECOVERY_FILE_DEST_SIZE = 20G
表明fra的限制为20g
4.LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc
表明归档的格式为arch_%t_%s_%r.arc
%t：表示的是thread
%s：表示的是log sequence
%r：表示的是resetlogs id
因此A正确。
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2019-9-18 14:37:38 |
赞(
操作
