在进行xtts迁移时报错如下
[oracle@localhost u02]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i
mkdir: cannot create directory ‘/u01/xtts/tempu/incremental_Jan15_Mon_21_58_30_205/’: No such file or directory
============================================================
trace file is /u01/xtts/tempu/incremental_Jan15_Mon_21_58_30_205//Jan15_Mon_21_58_30_205_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
============================================================
/u01/xtts/tempu/xttnewdatafiles.txt not present, so can't check if new files got added
=============================================================
Can't use an undefined value as an ARRAY reference at xttdriver.pl line 3215.
解决办法:
打开数据库
commit
SQL> commit;
再次执行增量备份
[oracle@localhost u02]$ export TMPDIR=/u01/xtts/temp
[oracle@localhost u02]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i
============================================================
trace file is /u01/xtts/temp/incremental_Jan15_Mon_22_04_08_699//Jan15_Mon_22_04_08_699_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
============================================================
No new datafiles added
=============================================================
Prepare newscn for Tablespaces: 'USERS'
Prepare newscn for Tablespaces: 'TEST'
Prepare newscn for Tablespaces: 'TBS_A'
Prepare newscn for Tablespaces: 'TBS_B'
Prepare newscn for Tablespaces: ''''
Prepare newscn for Tablespaces: ''''
Prepare newscn for Tablespaces: ''''
Prepare newscn for Tablespaces: ''''
Prepare newscn for Tablespaces: ''''
Prepare newscn for Tablespaces: ''''
--------------------------------------------------------------------
Starting incremental backup
--------------------------------------------------------------------
--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------
大功告成