报错日志如下：
同步scn 的操作应当在源端环境去操作；
[node1]zkemr2$$ORACLE_HOME/perl/bin/perl xttdriver.pl -s -L
============================================================
trace file is /temp/zkemr/determinescn_Nov16_Fri_21_32_17_515//Nov16_Fri_21_32_17_515_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
Prepare newscn for Tablespaces: 'USERS','TS_HIS','TS_CDR'
Prepare newscn for Tablespaces: 'TSP_SUPCON','TSP_OUTPADM','TSP_ORDADM'
Prepare newscn for Tablespaces: 'TSP_INPADM','TSP_INSURANCE','TSP_PHARMACY'
Prepare newscn for Tablespaces: 'TSP_MEDREC','TSP_SURGERY','TSP_COMM'
Prepare newscn for Tablespaces: 'MEDDOC','TSP_BLDBANK','TSP_EXAM'
Prepare newscn for Tablespaces: 'TSP_LAB','TSP_INPBILL','TSP_OUTPBILL'
Prepare newscn for Tablespaces: 'TS_EHIT','TSP_CP','SUPCLINIC'
Prepare newscn for Tablespaces: 'TSP_EEMR','TSP_EPNURDOC','CARADIGM_TABLESPACE'
New /temp/zkemr/xttplan.txt with FROM SCN's generated
[node1]zkemr2$ls -trl
###目标端运行 -s 同步scn 操作报错日志：
oracle@emrdb01:/temp/zkemr$$ORACLE_HOME/perl/bin/perl xttdriver.pl -s
============================================================
trace file is /temp/zkemr/determinescn_Nov16_Fri_21_28_16_402//Nov16_Fri_21_28_16_402_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
Prepare newscn for Tablespaces: 'USERS','TS_HIS','TS_CDR'
l_tsn dbms_sql.number_table;
*
ERROR at line 11:
ORA-06550: line 11, column 21:
PLS-00201: identifier 'DBMS_SQL.NUMBER_TABLE' must be declared
ORA-06550: line 11, column 21:
PL/SQL: Item ignored
ORA-06550: line 12, column 21:
PLS-00201: identifier 'DBMS_SQL.VARCHAR2_TABLE' must be declared
ORA-06550: line 12, column 21:
PL/SQL: Item ignored
ORA-06550: line 13, column 21:
PLS-00201: identifier 'DBMS_SQL.VARCHAR2_TABLE' must be declared
ORA-06550: line 13, column 21:
PL/SQL: Item ignored
ORA-06550: line 14, column 21:
PLS-00201: identifier 'DBMS_SQL.VARCHAR2_TABLE' must be declared
ORA-06550: line 14, column 21:
PL/SQL: Item ignored
ORA-06550: line 15, column 21:
PLS-00201: identifier 'USER_TABLESPACES.TABLESPACE_NAME' must be declared
ORA-06550: line 15, column 21:
PL/SQL: Item ignored
ORA-06550: line 16, column 21:
PLS-00201: identifier 'DBMS_SQL.NUMBER_TABLE' must be declared
ORA-06550: line 16, column 21:
PL/SQL: Item ignored
ORA-06550: line 17, column 21:
PLS-00201: identifier 'DBMS_SQL.NUMBER_TABLE' must be declared
ORA-06550: line 17, column 21:
PL/SQL: Item ignored
ORA-06550: line 270, column 11:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 268, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 277, column 15:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 277, column 5:
PL/SQL: Statement ignored
ORA-06550: line 278, column 17:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 278, column 5:
PL/SQL: Statement ignored
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Error:
------
Error in executing /temp/zkemr/determinescn_Nov16_Fri_21_28_16_402//xttpreparenextiter.sql
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!