ADSM-L

[ADSM-L] Oracle archive log backups and resourceutilization

2017-02-22 15:28:35
Subject: [ADSM-L] Oracle archive log backups and resourceutilization
From: "Rhodes, Richard L." <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 22 Feb 2017 20:27:34 +0000
Our DBA's have scripts that backup their Oracle archive logs.
It causes us pain.

(AIX 7.1 with BA clients 6.4 and up)

Their scripts run from cron every few minutes.
If it finds archive logs, it processes as below:

  For each archive log (individual log file)
    run dsmc on the log file
    check dsmc output for whether it worked or failed
    delete the log file if backup worked

So they process the log files one at a time on separate dsmc cmds.

Now, if there are a bunch of files (30, 40, 100, or multiple 100's), it kicks 
into high
gear and runs up to 8 dsmc cmds in parallel.

What I'd like to know is, if they were to put all
the log file names into a filelist, and run ONE dsmc cmd
specifying the filelist along with -resourceutilization=10,
will dsmc parallel some number of files concurrently back to
the TSM server?


The DBA's really, really want to get the archive logs
off the server and into TSM ASAP!  We have big Oracle
servers that do several thousand TSM session per day
with this processing.


Note:  all log files are in the same filesystem



-----------------------------------------
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.

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