GregE
ADSM.ORG Senior Member
-Sunfire v490
-CPU's - (4) dual core 1.5GHz
-OS is Solaris 10 running Oracle 10g
-16GB memory
-A single 2Gb Emmulex FC HBA dedicated to LTO-3 tape drives thru a 2Gb switch (two others dedicated to disk)
-TSM BA client 5.4.1.5
-TSM Oracle TDP 5.4.1.5
-TSM Storage Agent 5.4.5.0
Because RMAN opens and closed sessions during a single Oracle db backup, I can't use session information to get any bytes per second type of information from TSM for Oracle backups.
But, though I'm not any Oracle guru, I would think there is some RMAN information that could be obtained via RMAN script or something. Does anyone know how or have any script they use to gather some Oracle backup statistics?
Getting some ballpark numbers manually from amount of data backed up during a day, for a particular Oracle node, and the time it took to back it up, I can manually get some "decent" statistics, but nothing exact and nothing that isn't a very manual process.
Our backup speed is about 43MB/sec and I'm getting told it should be better than this, AS EXISTS. Not, "with new hardware."
I'm looking for a way to gather some RMAN stats, as well as some advice on RMAN performance. I know this is not an Oracle forum, but maybe someone has some expertise that will be helpful?
-CPU's - (4) dual core 1.5GHz
-OS is Solaris 10 running Oracle 10g
-16GB memory
-A single 2Gb Emmulex FC HBA dedicated to LTO-3 tape drives thru a 2Gb switch (two others dedicated to disk)
-TSM BA client 5.4.1.5
-TSM Oracle TDP 5.4.1.5
-TSM Storage Agent 5.4.5.0
Because RMAN opens and closed sessions during a single Oracle db backup, I can't use session information to get any bytes per second type of information from TSM for Oracle backups.
But, though I'm not any Oracle guru, I would think there is some RMAN information that could be obtained via RMAN script or something. Does anyone know how or have any script they use to gather some Oracle backup statistics?
Getting some ballpark numbers manually from amount of data backed up during a day, for a particular Oracle node, and the time it took to back it up, I can manually get some "decent" statistics, but nothing exact and nothing that isn't a very manual process.
Our backup speed is about 43MB/sec and I'm getting told it should be better than this, AS EXISTS. Not, "with new hardware."
I'm looking for a way to gather some RMAN stats, as well as some advice on RMAN performance. I know this is not an Oracle forum, but maybe someone has some expertise that will be helpful?