ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[ADSM-L] JR- RMAN

2008-08-07 22:07:03
Subject: [ADSM-L] JR- RMAN
From: JR Trimark <j.r.trimark AT AURORA DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 7 Aug 2008 21:04:03 -0500 
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
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [ADSM-L] TSM - Configuration Manager, Lloyd Dieter
Next by Date:  Re: [ADSM-L] New Tivoli Licensing Free Metric tool!, Schaub, Steve
Previous by Thread:  [ADSM-L] TSM Solaris Server on X86, Sam Sheppard
Next by Thread:  Re: [ADSM-L] JR- RMAN, Jiangxi Wazi
Indexes:  [Date] [Thread] [Top] [All Lists]