XTTS 增量备份同步scn xttdriver.pl  -s PLS-00201: identifier 'DBMS_SQL.VARCHAR2_TABLE' must be declare运行报错

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/royjj/article/details/84674771

报错日志如下:

同步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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

 

 

阅读更多

没有更多推荐了,返回首页