Oracle 参数 STANDBY_FILE_MANAGEMENT 官方解释，作用，如何配置最优化建议
本站中文解释
STANDBY_FILE_MANAGEMENT：用于控制应用日志文件的处理，如果设置为AUTO时，此参数将用于控制应用日志文件是被自动删除、备份或迁移，以满足物理备份恢复要求。
设置正确的方法：
1. 在Oracle实例中，使用ALTER SYSTEM 命令将STANDBY_FILE_MANAGEMENT参数的值设置为AUTO：
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=SPFILE;
2. 使用V$PARAMETER视图查看参数设置是否生效：
SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = ‘STANDBY_FILE_MANAGEMENT’;
3. 如果设置生效，则参数值会变为AUTO；如果没有生效，则重启数据库可以使参数正确设置。
官方英文解释
STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Basic |
No |
When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. STANDBY_FILE_MANAGEMENT is only applicable to physical standby databases.
Values
-
MANUALDisables automatic standby file management
-
AUTOEnables automatic standby file management
Setting STANDBY_FILE_MANAGEMENT to AUTO causes Oracle to automatically create files on the standby database and, in some cases, overwrite existing files. Care must be taken when setting STANDBY_FILE_MANAGEMENT and DB_FILE_NAME_CONVERT so that existing standby files will not be accidentally overwritten.
If the standby database is on the same system as the primary database, then ensure that the primary and standby systems do not point to the same files.
See Also:
Oracle Data Guard Concepts
and Administration for more information about setting this parameter
