Re: RMAN backups of SAP database

BR*Tools do leave a log file and have several methods. One of them is UTL_FILE, the other one is RMAN. UTL_FILE is basially, version 7 style backup of files with the database in the backup mode. Another brbackup method is RMAN, with some twists. BR*Tools can't utilize catalog. I wander what method is used by BR*Tools. BR*Tools, as opposed to RMAN, can also utilize snapshots. The phrase "SAP backup" doesn't mean much without the exact configuration of brbackup. BR*backup is also backing up the SAP configuration files, which are ignored by usual RMAN backups. SAP only certifies BR*Tools for SAP R3 backup. RMAN backup is not certified. There are many nuances here, and discussing BR*Tools without knowing the details is pointless.

On 2/23/20 9:23 PM, Jack van Zanen wrote:
> 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
>
>
> -------------------------
> 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
>
>
> On Sat, Feb 22, 2020 at 6:22 AM Sandra Becker <sbecker6925_at_gmail.com
> <mailto:sbecker6925_at_gmail.com>> wrote:
>
> Oracle EE v11.2
>
> 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.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l