Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 28 02:06:58 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: QBPROD (DBID=1820071005) connected to auxiliary database: QBINT1 (not mounted) RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "identifier": expecting one of: "double-quoted-string, equal, single-quoted-string" RMAN-01008: the bad identifier was: to_date RMAN-01007: at line 27 column 16 file: standard input RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "(": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 27 column 23 file: standard input RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Starting Duplicate Db at 28-MAY-09 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=82 devtype=DISK contents of Memory Script: { set until scn 806983306; set newname for datafile 1 to "+DATA/qbprod/datafile/system.445.624113309"; set newname for datafile 2 to "+DATA/qbprod/datafile/undotbs1.447.624113309"; set newname for datafile 3 to "+DATA/qbprod/datafile/sysaux.446.624113309"; set newname for datafile 4 to "+DATA/qbprod/datafile/users.448.624113309"; set newname for datafile 5 to "+DATA/qbprod/datafile/undotbs2.453.624113399"; set newname for datafile 6 to "+DATA/qbprod/datafile/tia_archive_01.dbf"; set newname for datafile 7 to "+DATA/qbprod/datafile/tia_archivelob_data_01.dbf"; set newname for datafile 8 to "+DATA/qbprod/datafile/tia_archive_index_01.dbf"; set newname for datafile 9 to "+DATA/qbprod/datafile/tia_data_01.dbf"; set newname for datafile 10 to "+DATA/qbprod/datafile/tia_data1_01.dbf"; set newname for datafile 11 to "+DATA/qbprod/datafile/tia_data2_01.dbf"; set newname for datafile 12 to "+DATA/qbprod/datafile/tia_data3_01.dbf"; set newname for datafile 13 to "+DATA/qbprod/datafile/tia_data4_01.dbf"; set newname for datafile 14 to "+DATA/qbprod/datafile/tia_index_01.dbf"; set newname for datafile 15 to "+DATA/qbprod/datafile/tia_index1_01.dbf"; set newname for datafile 16 to "+DATA/qbprod/datafile/tia_index2_01.dbf"; set newname for datafile 17 to "+DATA/qbprod/datafile/tia_index3_01.dbf"; set newname for datafile 18 to "+DATA/qbprod/datafile/tia_index4_01.dbf"; set newname for datafile 19 to "+DATA/qbprod/datafile/tia_lob_data_01.dbf"; set newname for datafile 20 to "+DATA/qbprod/datafile/tia_reference_01.dbf"; set newname for datafile 21 to "+DATA/qbprod/datafile/tia_reference_index_01.dbf"; set newname for datafile 22 to "+DATA/qbprod/datafile/tia_user_01.dbf"; set newname for datafile 23 to "+DATA/qbprod/datafile/tia_user_index_01.dbf"; restore check readonly clone database ; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 28-MAY-09 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to +DATA/qbprod/datafile/system.445.624113309 restoring datafile 00002 to +DATA/qbprod/datafile/undotbs1.447.624113309 restoring datafile 00003 to +DATA/qbprod/datafile/sysaux.446.624113309 restoring datafile 00004 to +DATA/qbprod/datafile/users.448.624113309 restoring datafile 00005 to +DATA/qbprod/datafile/undotbs2.453.624113399 restoring datafile 00006 to +DATA/qbprod/datafile/tia_archive_01.dbf restoring datafile 00007 to +DATA/qbprod/datafile/tia_archivelob_data_01.dbf restoring datafile 00008 to +DATA/qbprod/datafile/tia_archive_index_01.dbf restoring datafile 00009 to +DATA/qbprod/datafile/tia_data_01.dbf restoring datafile 00010 to +DATA/qbprod/datafile/tia_data1_01.dbf restoring datafile 00011 to +DATA/qbprod/datafile/tia_data2_01.dbf restoring datafile 00012 to +DATA/qbprod/datafile/tia_data3_01.dbf restoring datafile 00013 to +DATA/qbprod/datafile/tia_data4_01.dbf restoring datafile 00014 to +DATA/qbprod/datafile/tia_index_01.dbf restoring datafile 00015 to +DATA/qbprod/datafile/tia_index1_01.dbf restoring datafile 00016 to +DATA/qbprod/datafile/tia_index2_01.dbf restoring datafile 00017 to +DATA/qbprod/datafile/tia_index3_01.dbf restoring datafile 00018 to +DATA/qbprod/datafile/tia_index4_01.dbf restoring datafile 00019 to +DATA/qbprod/datafile/tia_lob_data_01.dbf restoring datafile 00020 to +DATA/qbprod/datafile/tia_reference_01.dbf restoring datafile 00021 to +DATA/qbprod/datafile/tia_reference_index_01.dbf restoring datafile 00022 to +DATA/qbprod/datafile/tia_user_01.dbf restoring datafile 00023 to +DATA/qbprod/datafile/tia_user_index_01.dbf channel ORA_AUX_DISK_1: reading from backup piece /u03/oradata/BACKUPS/RMAN/QBPROD2/tiadatafile_1_1.bak ORA-19870: error reading backup piece /u03/oradata/BACKUPS/RMAN/QBPROD2/tiadatafile_1_1.bak ORA-19504: failed to create file "+DATA" ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15077: could not locate ASM instance serving a required diskgroup ORA-29701: unable to connect to Cluster Manager failover to previous backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 05/28/2009 02:07:41 RMAN-03015: error occurred in stored script Memory Script RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 23 found to restore RMAN-06023: no backup or copy of datafile 22 found to restore RMAN-06023: no backup or copy of datafile 21 found to restore RMAN-06023: no backup or copy of datafile 20 found to restore RMAN-06023: no backup or copy of datafile 19 found to restore RMAN-06023: no backup or copy of datafile 18 found to restore RMAN-06023: no backup or copy of datafile 17 found to restore RMAN-06023: no backup or copy of datafile 16 found to restore RMAN-06023: no backup or copy of datafile 15 found to restore RMAN-06023: no backup or copy of datafile 14 found to restore RMAN-06023: no backup or copy of datafile 13 found to restore RMAN-06023: no backup or copy of datafile 12 found to restore RMAN-06023: no backup or copy of datafile 11 found to restore RMAN-06023: no backup or copy of datafile 10 found to restore RMAN-06023: no backup or copy of datafile 9 found to restore RMAN-06023: no backup or copy of datafile 8 found to restore RMAN-06023: no backup or copy of datafile 7 found to restore RMAN-06023: no backup or copy of datafile 6 found to restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore RMAN> RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 2 column 1 file: standard input RMAN> RMAN> Recovery Manager complete.