74.The database is running in ARCHIVELOG mode. Examine the initialization parameters and their value

最新推荐文章于 2024-05-08 04:12:28 发布

原创最新推荐文章于 2024-05-08 04:12:28 发布 · 1.9k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

1z0-052

本文探讨了数据库运行在ARCHIVELOG模式下归档日志的相关配置参数及其影响。通过分析LOG_ARCHIVE_FORMAT、LOG_ARCHIVE_DEST_1等参数的设置，明确了归档日志文件的创建位置及格式。

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正确

标签

#1z0-052