Hello,
when running xttdriver.pl --restore the generated RMAN command files are not generated correctly: I am following the MOS Note https://support.oracle.com/rs?type=doc&id=2005729.1
restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset '/opt/stage/EASEBIZD/MVXSSMA_9_8tsrv4je_1_1.bkp';
When the command should look like this:
restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE 100 format '+DATA' from backupset '/opt/stage/EASEBIZD/MVXSSMA_9_8tsrv4je_1_1.bkp';
From the logfile with -d 3 set:
[oracle@ocilxeasdbd01 restore_Feb26_Mon_13_23_26_450]$ more *.log
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: backupondest
Values: +RECO
Key: dumpdir
Values: /opt/oracle/temp_data/INFC
Key: platformid
Values: 2
Key: parallel
Values: 8
Key: dfcopydir
Values: /opt/oracle/temp_data/INFC
Key: dstdir
Values: /opt/stage/EASEBIZD
Key: cnvinst_home
Values: /u01/app/oracle/product/12.1.0.2/dbhome_3
Key: cnvinst_sid
Values: EASEBIZD
Key: rollparallel
Values: 4
Key: stageondest
Values: /opt/stage/EASEBIZD
Key: getfileparallel
Values: 8
Key: backupformat
Values: /opt/oracle/temp_data/INFC
Key: storageondest
Values: +DATA
Key: asm_sid
Values: +ASM1
Key: srcdir
Values: /opt/VXVM/oracle/data/db01-VXFS/INFC,/opt/VXVM/oracle/data/db02-VXFS/INFC,/opt/VXVM/oracle/data/db03-VXFS/INFC,/opt/VXVM/oracle/data/db04-VXFS/INFC,/opt/VXVM/oracle/dat
a/db05-VXFS/INFC
Key: tablespaces
Values: APPS_TS_ARCHIVE, APPS_TS_INTERFACE, APPS_TS_MEDIA, APPS_TS_NOLOGGING, APPS_TS_QUEUES, APPS_TS_SEED, APPS_TS_SUMMARY, APPS_TS_TOOLS, APPS_TS_TX_DATA, APPS_TS_TX_IDX, CS_
IDX, CS_TBL, DBH_DATA, DBH_IDX, DLOGTP004M01, FND_TBL, GL_IDX, GL_TBL, GL_TEMP_IDX, GL_TEMP_TBL, ICX_TBL, INDEX_REBUILD, INTERIM, INV_TBL, IZU_IDX, IZU_TBL, JA_IDX, JA_TBL, JE_
IDX, JE_TBL, JL_IDX, JL_TBL, MCS_TBL_128K, MP251_DATA, MP251_IDX, MP260_DATA, MP260_IDX, MTC_HIST_IDX, MTC_HIST_TBL, MTC_QUERY_TBL_128K, MTC_TBL_128K, MTL_IDX01, MTL_TBL01, MVA
D, MVAX, MVD, MVDSSMA, MVIEWLOGSSMA01, MVX, MVXSSMA, OMARAP_TBL, OMARAR_TBL, OMARFND_TBL, OPM_IDX, OPM_TBL, ORADISC, OWA_TBL, PA_TBL, PICUI, PORTAL, PO_TBL, SHARED_IDX, SHARED_
TBL, TOOLS, USERS, WEB_TBL, XXMAR_IDX, XXMAR_TBL, XXMAR_TEMP_IDX, XXMAR_TEMP_TBL, XXOMAR_IDX, XXOMAR_TBL
Key: asm_home
Values: /u01/app/12.1.0.2/grid
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
ARGUMENT stageondest
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : EASEBIZD
ORACLE_HOME : /u01/app/oracle/product/12.1.0.2/dbhome_3
121020
--------------------------------------------------------------------
Start restore/recover
--------------------------------------------------------------------
rdfno 10,7,11,9
BEFORE ROLLPLAN
AFTER ROLLPLAN
rdfno 105,59,60
BEFORE ROLLPLAN
AFTER ROLLPLAN
rdfno 136,4,115,127,111,154
BEFORE ROLLPLAN
AFTER ROLLPLAN
rdfno 15,8,12,16
BEFORE ROLLPLAN
AFTER ROLLPLAN
rdfno 159,518,489,568,587,559,56,470,511,575,602,249,562,99,485,517,584,599,644,558
BEFORE ROLLPLAN
AFTER ROLLPLAN
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 26 13:23:27 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: EASEBIZD (DBID=740217448)
RMAN> restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "integer"
RMAN-01007: at line 1 column 67 file: /opt/stage/EASEBIZD/restore_Feb26_Mon_13_23_26_450//xttresrec_105_59_60.cmd
rdfno 18,528,670,62,412,421,423,531,260,413,414,416,529
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 26 13:23:28 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: EASEBIZD (DBID=740217448)
RMAN> restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "integer"
RMAN-01007: at line 1 column 67 file: /opt/stage/EASEBIZD/restore_Feb26_Mon_13_23_26_450//xttresrec_15_8_12_16.cmd
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 26 13:23:27 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: EASEBIZD (DBID=740217448)
RMAN> restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "integer"
RMAN-01007: at line 1 column 67 file: /opt/stage/EASEBIZD/restore_Feb26_Mon_13_23_26_450//xttresrec_10_7_11_9.cmd
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 26 13:23:27 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: EASEBIZD (DBID=740217448)
RMAN> restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "integer"
RMAN-01007: at line 1 column 67 file: /opt/stage/EASEBIZD/restore_Feb26_Mon_13_23_26_450//xttresrec_136_4_115_127_111_154.cmd
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 26 13:23:30 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: EASEBIZD (DBID=740217448)
RMAN> restore from platform 'Solaris[tm] OE (64-bit)' FOREIGN DATAFILE from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "integer"
RMAN-01007: at line 1 column 67 file: /opt/stage/EASEBIZD/restore_Feb26_Mon_13_23_26_450//xttresrec_159_518_489_568_587_559_5.cmd
[oracle@ocilxeasdbd01 restore_Feb26_Mon_13_23_26_450]$
Cheers,
Andy