ADSM-L

Re: TDP for Oracle

2005-10-24 01:16:27
Subject: Re: TDP for Oracle
From: Kurt Beyers <Kurt.Beyers AT DOLMEN DOT BE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 24 Oct 2005 07:12:21 +0200
Joni,
 
A backup of Oracle with the TDP will always allocate the channel ''sbt_tape" in 
the RMAN script. This channel uses the library of TSM you had to create a 
symbolic link for. That is how RMAN knows that the data must be sent to the TSM 
server.
 
>From there on it is TSM that handles the data further on. The destination pool 
>in the (default) management class will be used. This can either be to disk or 
>tape and they will both use the channel 'sbt_tape' in the RMAN script.
 
You can check the destination yourself with the command:
 
show versions 'TSM node name Oracle TSP' *;
 
Here you see the management class the backups are binded to.
 
best regards,
Kurt

________________________________

From: ADSM: Dist Stor Manager on behalf of Joni Moyer
Sent: Sun 23/10/2005 23:34
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP for Oracle



Hello everyone,

We are beginning the testing of TDP for Oracle and I was just wondering if
a majority of you go directly to tape?  And if so, how do you know it's
going to tape and not the disk pool?  I have defined a default management
class for our TDPO domain which is supposed to go to our disk pool.  I
don't have a dbt_tape device class set up on my TSM server, so I am a
little confused by the output that was received when they used the TDP
client on the oracle server.  Can anyone clarify how I can tell how the
data was transferred in the below messages?  It looks like it was using a
tape drive, but I don't know how that's possible.  Any help is appreciated.
Thanks!

Sent:
     allocate channel t1 device type 'sbt_tape'
     parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
     backup incremental level ${LEVEL} (database) plus archivelog;

Response:
allocated channel: t1
channel t1: sid=141 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 20-OCT-05
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=151 recid=479 stamp=572133718
input archive log thread=1 sequence=152 recid=480 stamp=572138781
input archive log thread=1 sequence=153 recid=481 stamp=572138801
input archive log thread=1 sequence=154 recid=482 stamp=572157003
input archive log thread=1 sequence=155 recid=483 stamp=572157026
channel t1: starting piece 1 at 20-OCT-05
channel t1: finished piece 1 at 20-OCT-05
piece handle=aoh1kr36_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:00:36
Finished backup at 20-OCT-05Sent:
     allocate channel t1 device type 'sbt_tape'
     parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
     backup incremental level ${LEVEL} (database) plus archivelog;

Response:
allocated channel: t1
channel t1: sid=141 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 20-OCT-05
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=151 recid=479 stamp=572133718
input archive log thread=1 sequence=152 recid=480 stamp=572138781
input archive log thread=1 sequence=153 recid=481 stamp=572138801
input archive log thread=1 sequence=154 recid=482 stamp=572157003
input archive log thread=1 sequence=155 recid=483 stamp=572157026
channel t1: starting piece 1 at 20-OCT-05
channel t1: finished piece 1 at 20-OCT-05
piece handle=aoh1kr36_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:00:36
Finished backup at 20-OCT-05
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************

<Prev in Thread] Current Thread [Next in Thread>