74.The database is running in ARCHIVELOG mode. Examine the initialization parame

论坛 期权论坛 脚本     
匿名技术用户   2020-12-29 22:23   605   0
74.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正确
分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:7942463
帖子:1588486
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP