EBS 12.2 19c数据库克隆步骤

1.源环境数据库主节点DB1运行预克隆
su – oracle
. /u01/SIT/db/19.0.0/SITCDB_r122sitdb.env
perl adpreclone.pl dbTier

2.目标数据库节点运行克隆技术堆栈
su – oracle
cd /u01/SIT/db/19.0.0/appsutil/clone/bin
perl adcfgclone.pl dbTechStack

3.利用rman或NBU恢复源库备份到目标数据库节点

4.修改CDB db_name
su – oracle
export ORACLE_SID=PRODCDB
sqlplus / as sysdba
startup mount
exit

nid target=sys/oracle dbname=SITCDB setname=yes

5.修改PDB name
su - oracle
. 19c_cdb.env
sqlplus / as sysdba

alter pluggable database PROD close;
alter pluggable database PROD open restricted;
alter session set container=PROD;
alter pluggable database rename global_name to SIT;
alter pluggable database close immediate;
alter pluggable database SIT open;

6.创建并启动 PDB service
su - oracle
. 19c_cdb.env
sqlplus / as sysdba

alter session set container=SIT;
exec dbms_service.create_service('ebs_SIT','ebs_SIT');
exec dbms_service.delete_service('ebs_PROD');

exec dbms_service.create_service('SIT_ebs_patch','SIT_ebs_patch');
exec dbms_service.delete_service('PROD_ebs_patch');

exec dbms_service.start_service('ebs_SIT');

7.检查并测试连接PDB
su - oracle
. 19c_cdb.env
sqlplus / as sysdba

alter session set container=SIT;
set linesize 4000;
select name,pdb from cdb_services order by 2;
exit

sqlplus system/system_passwd@SIT
sqlplus apps/apps_passwd@SIT

8.切换到pdb环境变量，清理节点信息
source /u01/SIT/db/19.0.0/SIT_r122sitdb.env
sqlplus apps/<apps_passwd>@SIT
exec fnd_conc_clone.setup_clean;
commit;

9.切换到pdb环境变量，运行数据库节点autoconfig
source /u01/SIT/db/19.0.0/SIT_r122sitdb.env
ls -l $CONTEXT_FILE
cd $ORACLE_HOME/appsutil/bin

/*修复
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /u01/SIT/db/19.0.0/appsutil/bin/txkCfgUtlfileDir.sh  1
 No. of scripts failed in CVM phase: 1
*/

SIT_utlfiledir.txt

perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -skipdirvalidation=Yes

$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=$CONTEXT_FILE appspass=<apps_passwd>