• 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.

why does RMAN TDPO start such a huge amount of sessions?

PaulKolling

Newcomer
Joined
Nov 11, 2020
Messages
3
Reaction score
0
Points
0
Location
Frankfurt, Germany
Hi,

we can see many many sessions from our RMAN TDPO Clients in our activity log over the day - not in parallel, mostly in sequence!
There are lots of nodes with more then 12000 sessions per day !
What is the reason for this and is there any possibility to prevent this behaviour of RMAN?

regards
Paul
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,660
Reaction score
597
Points
0
Location
Canada
Website
www-947.ibm.com
Check with your DBAs. They are likely archiving their database logs throughout the day. That's common practice by the way.
 

PaulKolling

Newcomer
Joined
Nov 11, 2020
Messages
3
Reaction score
0
Points
0
Location
Frankfurt, Germany
Yes indeed, they do that, I know. But why are 12000 sessions necessary for that? I think when archiving a database once in an hour - let's assume with 4 channels - there should be something around 4 sessions per pass, why 12000 ?
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,660
Reaction score
597
Points
0
Location
Canada
Website
www-947.ibm.com
There's one session every time RMAN opens a channel. The answer resides with RMAN, from the Spectrum Protect server, we only see the sessions, can't tell what RMAN is doing.
 

PaulKolling

Newcomer
Joined
Nov 11, 2020
Messages
3
Reaction score
0
Points
0
Location
Frankfurt, Germany
hm, you are confusing me a little bit - this is the first time I use this platform since many many years - has something changed here? am I in the wrong Forum? I wanted to discuss a strange behaviour of Spectrum Protect Oracle Client - why do you tell me the absolute basics and commonplaces about RMAN?
Isn't anybody else here using the Spectrum Protect Oracle Client?
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,660
Reaction score
597
Points
0
Location
Canada
Website
www-947.ibm.com
You are in the right forum and I'm trying to help you.

The thing about Oracle is that there is no Spectrum Protect Oracle Client. RMAN is the client and all that Data Protection for Oracle provides is an API so that RMAN can send backups to the Spectrum Protect Server.

The point I was trying to make is that RMAN controls the backup. I am not familiar enough with RMAN to know how the internals work, but I do know that the sessions are opened as a result of activity generated by RMAN. I also know that RMAN has a fileperset options that determines how many files are sent per backupset. If the backups are sent to a deduplicated pools, the recommended value is fileperset=1 (https://www.ibm.com/support/pages/rman-settings-when-using-tivoli-storage-manager-deduplication) and that would use 1 session per object.

This brings us back to RMAN, how is it configured? How many objects is it sending? How frequently? If the fileperset value is low and RMAN is sending a large number of objects, then it's normal to see a large number of sessions.
 

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 18.6%
  • Keep using TSM for Spectrum Protect.

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

    Votes: 13 12.7%
  • Other (please comement)

    Votes: 9 8.8%

Forum statistics

Threads
31,795
Messages
135,569
Members
21,775
Latest member
oscar
Top