• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

4tb database using tdp for Oracle taking long time

nikhil_1707

ADSM.ORG Member
Joined
Jan 10, 2008
Messages
161
Reaction score
0
Points
0
Hi Team,

4tb database using tdp for Oracle taking long time and sometime failing .

The backup is going directly to tapes and drive is LTO3.

Please help in fixing it.

Regards,

Nikhil
 

fidel

ADSM.ORG Member
Joined
Aug 23, 2011
Messages
40
Reaction score
4
Points
0
Hi Team,

4tb database using tdp for Oracle taking long time and sometime failing .

The backup is going directly to tapes and drive is LTO3.

Please help in fixing it.

Regards,

Nikhil
Hello,
could you be more precise ?
How long does it take ?
Error code when the backup failed.
How many chanels are configured in RMAN ?
 

moon-buddy

ADSM.ORG Moderator
Joined
Aug 24, 2005
Messages
7,032
Reaction score
403
Points
0
Location
Somewhere in the US
Hi Team,

4tb database using tdp for Oracle taking long time and sometime failing .

The backup is going directly to tapes and drive is LTO3.

Please help in fixing it.

Regards,

Nikhil
As mentioned, send us more details like:

- is LAN Free used?
- Errors messages?
- How many drives are backing up the DB?
- is a disk pool available to speed backups?
 

nikhil_1707

ADSM.ORG Member
Joined
Jan 10, 2008
Messages
161
Reaction score
0
Points
0
Hi ,
Yes this is lan free and in 1 hour it takes 30 gb to back up on lto3 drives and after some hours rman backup fsils with error 72 ..and only 1 channel is selected.
No diskpool is available.

Regards,
Nikhil
 

LED888

ADSM.ORG Moderator
Joined
Oct 15, 2002
Messages
861
Reaction score
75
Points
0
Website
http
What is the full version of the TSM Server and the os that is hosting the TSM Server?
What is the full version of the Storage Agent, TSM API, TDP, Oracle and the os that is hosting the applications.
When did the issue started?
Is this a new set up?
If so, Verifying the LAN-free configuration

Is the Storage Agent running?
How many LTO3 are there in the library?
Are all the paths and drives on line via the TSM Server and STA?
Does the os see the library and drives?

What log did we find the "error 72"?
The number is too high to come from the application.
Were there any error on the os that is hosting the STA, TSM API, TDP and Oracle?

Were there any error in the dsmsta.err, dsierror.log, tdpoerror.log...
Were there any error message in the TSM Server activity log around the time when the "error 72" was generated?

Is the issue specific with the backup of Oracle?
Does the issue occur with the TSM B/A Client that is hosted on another system?

Here is a link to a techdoc regarding gathering process activity
Gathering Tivoli Storage Manager Storage Agent Activity through the Admin Console

Good Luck,
Sias
 

fidel

ADSM.ORG Member
Joined
Aug 23, 2011
Messages
40
Reaction score
4
Points
0
Hi ,
Yes this is lan free and in 1 hour it takes 30 gb to back up on lto3 drives and after some hours rman backup fsils with error 72 ..and only 1 channel is selected.
No diskpool is available.

Regards,
Nikhil
Error 72 means "connection timeout". As previously said by LED888, you have to check the TSM configuration and also from RMAN side.
 

eibbob

ADSM.ORG Member
Joined
Jul 13, 2015
Messages
34
Reaction score
0
Points
0
Hi,

How many tape drives do you have in the library? It can help if you increase the number of channels in RMAN and configure the TSM Client to use x number of mount points. This might speed up your backup time.

eibbob.
 

smajl

ADSM.ORG Senior Member
Joined
Dec 10, 2009
Messages
174
Reaction score
22
Points
0
Location
Brno
I'm wondering if you run full RMAN backup or incremental one.
 

nikhil_1707

ADSM.ORG Member
Joined
Jan 10, 2008
Messages
161
Reaction score
0
Points
0
What is the full version of the TSM Server and the os that is hosting the TSM Server?
TSM version is 7.1.3 and OS is Windows 2008


What is the full version of the Storage Agent, TSM API, TDP, Oracle and the os that is hosting the applications.
Storage Agent -- Version 6, Release 3, Level 2.000
TSM API --Client Version 6, Release 3, Level 0.0
TDP for Oracle --Version 6, Release 3, Level 0.0
When did the issue started? issue started when come to know that database size is increased to 4 TB
Is this a new set up? no
If so, Verifying the LAN-free configuration already verified
OS is AIX on which TDP for oracle reside

Is the Storage Agent running? Yes
How many LTO3 are there in the library? 4 drives
Are all the paths and drives on line via the TSM Server and STA? yes
Does the os see the library and drives? yes

What log did we find the "error 72"? I got it from Oracle logs which is generated form the script
The number is too high to come from the application.
Were there any error on the os that is hosting the STA, TSM API, TDP and Oracle?
No error seen

Were there any error in the dsmsta.err, dsierror.log, tdpoerror.log...

No error only -72

Were there any error message in the TSM Server activity log around the time when the "error 72" was generated?

No

Is the issue specific with the backup of Oracle? yes

Does the issue occur with the TSM B/A Client that is hosted on another system?

No it does not
 

fidel

ADSM.ORG Member
Joined
Aug 23, 2011
Messages
40
Reaction score
4
Points
0
What is the full version of the TSM Server and the os that is hosting the TSM Server?

No error only -72

Were there any error message in the TSM Server activity log around the time when the "error 72" was generated?

No

Is the issue specific with the backup of Oracle? yes

Does the issue occur with the TSM B/A Client that is hosted on another system?

No it does not
For error 72 you have to increase the following option in server and STA option file.
IDLETIMEOUT
COMMTIMEOUT

Did you check the TDP trace in activity log of the TSM server to verify if "LAN-Free=yes" ?
 

nikhil_1707

ADSM.ORG Member
Joined
Jan 10, 2008
Messages
161
Reaction score
0
Points
0
all the above setting done last week than also no result
taking 20 to 25 gb in one hour on an free after that also
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 19 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 61.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.0%
  • Other (please comement)

    Votes: 8 8.0%

Forum statistics

Threads
31,773
Messages
135,482
Members
21,760
Latest member
DanielVIera
Top