Oracle 参数 STANDBY_PDB_SOURCE_FILE_DIRECTORY 官方解释，作用，如何配置最优化建议
本站中文解释
STANDBY_PDB_SOURCE_FILE_DIRECTORY参数指定包含Oracle Data Hub（ODH）文件的本地目录。该目录中的每个ODH文件都会在备份数据库上自动创建一个插槽，以方便管理和恢复。
正确设置STANDBY_PDB_SOURCE_FILE_DIRECTORY参数：
1、确保STANDBY_PDB_SOURCE_FILE_DIRECTORY参数被设置为安全的文件系统，没有任何其他用户可以访问该目录。
2、确保STANDBY_PDB_SOURCE_FILE_DIRECTORY目录具有适当的空间，以便存储ODH文件。
3、尝试在LNS过程中将STANDBY_PDB_SOURCE_FILE_DIRECTORY目录作为空文件夹，这样可以避免由于文件被覆盖而导致的问题。
4、将STANDBY_PDB_SOURCE_FILE_DIRECTORY参数链接到一个新的本地文件系统并确保在重启时生效。
5、在ODH文件夹中为每个PDB分配一个子文件夹，以有效地管理ODH文件。该子文件夹内部的文件将自动被ODH检测到并自动分配到与PDB相关联的插槽中。
官方英文解释
STANDBY_PDB_SOURCE_FILE_DIRECTORY specifies a directory location on the standby where source datafiles for instantiating the standby PDB may be found.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
NULL |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Basic |
No |
|
Oracle RAC |
Different values can be set on different instances. |
In Oracle Database releases prior to Oracle Database 18c, if a PDB was plugged into a CDB, on a standby, the datafiles were expected to be in PDB’s Oracle Managed Files (OMF) directory location. If they were not found there, the user had to copy the datafiles to the OMF location and then restart redo apply on the standby.
To address that deficiency, the STANDBY_PDB_SOURCE_FILE_DIRECTORY specifies a directory location on the standby where source datafiles for instantiating the PDB may be found. If the datafiles are not found there, an attempt will be made to locate them in the OMF location on the standby.
This parameter can also be used to try to copy files in cases where the source PDB’s files are not present on the standby. For example, the source PDB could have been created with standbys=NONE. In this case, the STANDBY_PDB_SOURCE_FILE_DIRECTORY parameter can enable the standby to copy files from a location if they are made available.
See Also:
“STANDBY_PDB_SOURCE_FILE_DBLINK”
