Standby_pdb_source_file_directory

参考手册：Doc ID 2274735.1

在dataguard环境下需要插入数据库的时候需要使用此参数。

手册参考步骤：

 alter pluggable database <PDB_NAME> close instances=all;

alter pluggable database <PDB_NAME> unplug into '/<PATH>/<PDB_NAME>.xml';

backup as copy pluggable database chewie format '/<PATH>/<PDB_NAME>/%U';

standby数据库需要设置参数：

alter system set standby_pdb_source_file_directory='/<PATH>/<PDB_NAME>';

在主数据库插入pdb:

create pluggable database <PDB_NAME> as clone using '/<PATH>/<PDB_NAME>.xml' copy;

参数说明：

STANDBY_PDB_SOURCE_FILE_DIRECTORY ：

参数用于制定备数据源数据文件的位置， 用于安装PDB。

恢复日志：

Thu Mar 16 08:42:04 2017
Recovery created pluggable database <PDB_NAME>
Recovery attempting to copy datafiles for pdb-<PDB_NAME> from source dir-/<PATH>/<PDB_NAME>
Thu Mar 16 08:42:15 2017
Recovery copied files for tablespace SYSTEM
Recovery successfully copied file +<PATH>/DATAFILE/<FILE_NAME> from /<PATH>/<FILE_NAME>
Thu Mar 16 08:42:15 2017
Errors in file /<PATH>/trace/<FILE_NAME>.trc:
ORA-01186: file 1027 failed verification tests
ORA-01157: cannot identify/lock data file 1027 - see DBWR trace file
ORA-01110: data file 1027: '+<PATH>'
Thu Mar 16 08:42:15 2017
File 1027 not verified due to error ORA-01157
Thu Mar 16 08:42:15 2017
Errors in file /<PATH>/trace/<FILE_NAME>.trc:
ORA-01186: file 1028 failed verification tests
ORA-01157: cannot identify/lock data file 1028 - see DBWR trace file
ORA-01110: data file 1028: '+<PATH>'
File 1028 not verified due to error ORA-01157
Thu Mar 16 08:42:15 2017
Errors in file /<PATH>/trace/<FILE_NAME>.trc:
ORA-01186: file 1029 failed verification tests
ORA-01157: cannot identify/lock data file 1029 - see DBWR trace file
ORA-01110: data file 1029: '+DATA'
File 1029 not verified due to error ORA-01157
Thu Mar 16 08:42:15 2017
Successfully added datafile 38 to media recovery
Datafile #38: '+<PATH>/DATAFILE/<FILE_NAME>'
Thu Mar 16 08:42:25 2017
Recovery copied files for tablespace SYSAUX
Recovery successfully copied file +<PATH>/DATAFILE/<FILE_NAME> from /<PATH>/<FILE_NAME>