Re: RMAN backups of SAP database
Date: Mon, 24 Feb 2020 13:23:32 +1100
Message-ID: <CAFeFPA9eucRixs-ERQAM0Lj14ZJvkR3OCudyHE9sPkb9ffkiUg_at_mail.gmail.com>
First question: Can they prove it is your backup causing the Performance
issue. You may be on a wild goose chase
Even SAP backups most likely leave a log file behind somewhere that should
tell you what the SAP backup is doing (is it actually making a backup?) .
Don't they use RMAN under the hood anyway?
Regards
Jack van Zanen
On Sat, Feb 22, 2020 at 6:22 AM Sandra Becker <sbecker6925_at_gmail.com> wrote:
> Oracle EE v11.2
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
>
> The Basis admin from another team has asked if I can help him find out
> why RMAN backups of his SAP database cause severe performance issues in the
> database with only two channels. Yet the SAP backup method runs with 6
> parallel processes in about 4-5 hours. I know nothing about how the SAP
> backups are configured and don't have access to any of that information, so
> I'm not sure you'll be able to provide much help to us. I do know the
> following:
>
> - they don't use ASM
> - all files are on the same NFS mount, including the datafiles,
> binaries, logs, audit files, etc.
> - archivelogs are kept for 3 days and written to another NFS mounted
> drive
> - SAP backup method uses 6 channels, backup completes in 4-5 hours
> - RMAN backup was set for 2 channels, backup tool over 12 hours and
> caused significant performance degradation (so I was told, I can't prove it)
>
> Any suggestions on what they should look at to see what's going on or
> adjustments they should look into? I've looked at their RMAN configuration
> and it's actually pretty close to what I use in my production databases,
> just minor differences for path names and the like.
>
> --
> Sandy B.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 24 2020 - 03:23:32 CET