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
