Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

V4 XTTS errors generated in the res.txt file

AntonioMay 7 2021

Good afternoon, we are performing a migration from AIX to Linux, using the procedure and scripts of the note V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1) and the version of the scripts is rman_xttconvert_VER4.3.zip.

We have about 200 tablespaces with several datafiles each tablespace, when performing the backup as indicated in the note:
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup

Everything runs correctly, but the problem is that when generating the res.txt file, it is generated incorrectly, instead of putting the backup pieces generated for each tablespaces, it puts the name of the datafile.

Here is an example:

[oracle@targetserver tempxtt]$ cat res.txt
#0:::101,6,TS_CIERR_DAT_101.dbf,0,1060603814,0,0,0,TS_CIERR_DAT,TS_CIERR_DAT_101.dbf
#0:::124,6,TS_CIERR_IDX_124.dbf,0,1060603814,0,0,0,TS_CIERR_IDX,TS_CIERR_IDX_124.dbf
#0:::125,6,TS_CIERR_LOB_125.dbf,0,1060603814,0,0,0,TS_CIERR_LOB,TS_CIERR_LOB_125.dbf

And it would have to be this:

[oracle@targetserver tempxtt]$ cat res.txt
#0:::101,6,TS_CIERR_DAT_101_6fvu8qtt_1_1.bkp,0,1060603814,0,0,0,TS_CIERR_DAT,TS_CIERR_DAT_101.dbf
#0:::124,6,TS_CIERR_IDX_124_6gvu8qu4_1_1.bkp,0,1060603814,0,0,0,TS_CIERR_IDX,TS_CIERR_IDX_124.dbf
#0:::125,6,TS_CIERR_LOB_125_6hvu8qua_1_1.bkp,0,1060603814,0,0,0,TS_CIERR_LOB,TS_CIERR_LOB_125.dbf

And when trying to perform the restore:

$ORACLE_HOME/perl/bin/perl xttdriver.pl --restore

it does not locate the backup pieces and errors are generated.

Any idea about this, we have performed other procedures in Solaris as target and destination linux and the file res.txt has been generated correctly, it only happens to us when the source platform is AIX.

Thank you very much.

Comments

Processing

Post Details

Added on May 7 2021
1 comment
1,172 views