We are backing up our Oracle 10G database using TSM TDP and LAN Free 5.5.1 clients via a TSM 5.5. server. We are getting the following error upon restore. Any ideas? ***********log file results **************
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Aug 7 20:45:25 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: CERT (DBID=2144641495) connected to recovery catalog database connected to auxiliary database: RESTORE1 (not mounted) RMAN> new RMAN configuration parameters: CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS 'BLKSIZE=1048576,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'CERT_rman_%d_%t_%U.bck'; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete RMAN> RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 9 BACKUP TYPE TO BACKUPSET; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS 'BLKSIZE=524288,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'CERT_rman_%d_%t_%U.bck'; CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS 'BLKSIZE=1048576,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'CERT_rman_%d_%t_%U.bck'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/10.2.0.3/db/dbs/snapcf_cert1.f'; # default RMAN> 2> 3> 4> Starting Duplicate Db at 07-AUG-08 allocated channel: ORA_AUX_SBT_TAPE_1 channel ORA_AUX_SBT_TAPE_1: sid=1310 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_2 channel ORA_AUX_SBT_TAPE_2: sid=1309 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_2: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_3 channel ORA_AUX_SBT_TAPE_3: sid=1304 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_3: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_4 channel ORA_AUX_SBT_TAPE_4: sid=1306 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_4: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_5 channel ORA_AUX_SBT_TAPE_5: sid=1312 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_5: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_6 channel ORA_AUX_SBT_TAPE_6: sid=1303 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_6: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_7 channel ORA_AUX_SBT_TAPE_7: sid=1305 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_7: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_8 channel ORA_AUX_SBT_TAPE_8: sid=1307 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_8: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_SBT_TAPE_9 channel ORA_AUX_SBT_TAPE_9: sid=1300 devtype=SBT_TAPE channel ORA_AUX_SBT_TAPE_9: Data Protection for Oracle: version 5.5.1.0 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=1301 devtype=DISK contents of Memory Script: { set newname for datafile 1 to "/dev/rcert_systm_001"; set newname for datafile 2 to "/dev/rcert_undo1_001"; set newname for datafile 3 to "/dev/rcert_syaux_001"; set newname for datafile 4 to "/dev/rcert_misc_001"; set newname for datafile 5 to "/dev/rdcert_00000001"; set newname for datafile 6 to "/dev/rdcert_00000002"; set newname for datafile 7 to "/dev/rdcert_00000003"; set newname for datafile 8 to "/dev/rdcert_00000004"; set newname for datafile 9 to "/dev/rdcert_00000005"; set newname for datafile 10 to "/dev/rdcert_00000006"; set newname for datafile 11 to "/dev/rdcert_00000007"; set newname for datafile 12 to "/dev/rdcert_00000008"; set newname for datafile 13 to "/dev/rdcert_00000009"; set newname for datafile 14 to "/dev/rdcert_00000010"; set newname for datafile 15 to "/dev/rdcert_00000011"; set newname for datafile 16 to "/dev/rdcert_00000012"; set newname for datafile 17 to "/dev/rdcert_00000013"; set newname for datafile 18 to "/dev/rdcert_00000014"; set newname for datafile 19 to "/dev/rdcert_00000015"; set newname for datafile 20 to "/dev/rdcert_00000016"; set newname for datafile 21 to "/dev/rdcert_00000017"; set newname for datafile 22 to "/dev/rdcert_00000018"; set newname for datafile 23 to "/dev/rdcert_00000019"; set newname for datafile 24 to "/dev/rdcert_00000020"; restore check readonly clone database ; } executing Memory Script 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 executing command: SET NEWNAME Starting restore at 07-AUG-08 using channel ORA_AUX_SBT_TAPE_1 using channel ORA_AUX_SBT_TAPE_2 using channel ORA_AUX_SBT_TAPE_3 using channel ORA_AUX_SBT_TAPE_4 using channel ORA_AUX_SBT_TAPE_5 using channel ORA_AUX_SBT_TAPE_6 using channel ORA_AUX_SBT_TAPE_7 using channel ORA_AUX_SBT_TAPE_8 using channel ORA_AUX_SBT_TAPE_9 using channel ORA_AUX_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/07/2008 20:46:26 RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE RMAN> Recovery Manager complete. ***********log file results ************** Thanks in advance JR