Oracle 参数 BACKGROUND_DUMP_DEST 官方解释，作用，如何配置最优化建议

本站中文解释

BACKGROUND_DUMP_DEST参数设置了在Oracle出现故障情况下的转储文件的存储路径。本参数通常设置在 trace 文件，报告文件，警告日志，故障检测文件及调试日志等文件的存储路径。

设置方法：

1、首先检查你的存储路径，确保路径存在并且拥有足够的空间；

2、使用以下SQL命令设置BACKGROUND_DUMP_DEST参数：

ALTER SYSTEM SET BACKGROUND_DUMP_DEST = path name ；

3、重启Oracle数据库：

SQL SHUTDOWN IMMEDIATE
SQL STARTUP

注意：在设置任何系统参数时，应该考虑设置的有效性，对可能导致性能受损的参数，要尤其小心，并考虑备份当前的参数设置。

官方英文解释

BACKGROUND_DUMP_DEST specifies the pathname (directory or disc) where debugging trace files for the background processes (LGWR, DBWn, and so on) are written during Oracle operations.

Note:

The BACKGROUND_DUMP_DEST parameter is deprecated in Oracle Database 12c Release 1 (12.1.0.1).

An alert log in the directory specified by BACKGROUND_DUMP_DEST logs significant database events and messages. Anything that affects the database instance or global database is recorded here. The alert log is a normal text file. Its file name is operating system-dependent. For platforms that support multiple instances, it takes the form alert_sid.log, where sid is the system identifier. This file grows slowly, but without limit, so you might want to delete it periodically. You can delete the file even when the database is running.

Note:

This parameter is ignored by the diagnosability infrastructure introduced in Oracle Database 11g Release 1 (11.1), which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.

See Also:

Oracle Database
Administrator’s Guide for more information on the DIAGNOSTIC_DEST initialization parameter

USER_DUMP_DEST for information on setting a destination for server process trace files

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 参数 BACKGROUND_DUMP_DEST 官方解释，作用，如何配置最优化建议