Oracle 参数 STANDBY_PDB_SOURCE_FILE_DBLINK 官方解释，作用，如何配置最优化建议
本站中文解释
STANDBY_PDB_SOURCE_FILE_DBLINK 是Oracle备库参数，用于指定从主库复制PDB 数据文件时用到的dblink连接主库。
正确设置方法：
1、创建dblink，如primary_db为主库，standby_db为备库，可以在备库上创建dblink：
CREATE DATABASE LINK primary_db
CONNECT TO sys IDENTIFIED BY [主库SYS用户密码]
USING ‘[主库服务名或IP:端口/服务名]’;
2、在备库上设置参数：
ALTER SYSTEM SET STANDBY_PDB_SOURCE_FILE_DBLINK=’primary_db’;
3、查看当前设置：
SELECT * FROM V$PARAMETER WHERE NAME=’STANDBY_PDB_SOURCE_FILE_DBLINK’;
官方英文解释
STANDBY_PDB_SOURCE_FILE_DBLINK specifies the name of a database link that will be used to try to copy the datafiles from a source PDB to which the database link points.
| 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 created by cloning a PDB from the same CDB (a local clone), on a standby the datafiles were automatically copied from the source PDB. However, when the PDB was created as a remote clone, the user was responsible for copying datafiles to the Oracle Managed Files (OMF) location on the standby.
To address that deficiency, the STANDBY_PDB_SOURCE_FILE_DBLINK parameter specifies the name of a database link that will be used to try to copy the datafiles from a source PDB to which the database link points. The file copy is done only if the database link points to the source PDB and the source PDB is open in read only mode. Otherwise, the user is still responsible for copying datafiles to 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_DBLINK parameter can enable the standby to copy files from the primary if there is a database link set up to the primary.
See Also:
“STANDBY_PDB_SOURCE_FILE_DIRECTORY”
