Slow backup performance after Oracle Upgrade to 11.2.0.4 + sap kernel 721_ext

[Former Member]

Dear Experts,

After upgrading to Oracle 11.2.0.4 + SAP Kernel 721_EXT from Oracle 10.2.0.4 + SAP Kernel 700, we had a problem with backup performance using brtools. The backup time took pretty long running with 20 hours for 3.6TB.

Before upgrade to Oracle 11.2.0.4 the backup performance just took 12 hours for 3.6TB.

What's parameter need to be tuned?

Thank You

Edy

[stefan_koehler]

Hi Edy,

> Do you have any suggestion to analyze slow backup performance after Oracle Upgrade to 11.2.0.4 and SAP Kernel 721?

We need more information about how you perform an Oracle backup. Do you use Oracle RMAN (with or without BR*Tools) or do you perform the old fashion file based backup? Do you backup directly to tape (with third party MML or not) or to disk? Have you switched between both backup types after upgrade?

There are a lot of possibilities and configurations that we don't know yet. For example it is a well known issue, that the metadata collection (before the actual backup begins) can slow down the backup times dramatically, if you are using RMAN.

Regards

Stefan

[Former Member]

Hi Stefan,

We don't used RMAN, just brtools (brbackup command). The backup directly to tape.

>Have you switched between both backup types after upgrade?

What kind of backup types need to be changed? Whether the parameter in initSID.sap ? I don't change the initAOP.sap.

Here is the parameter on initSID.sap and will be loaded before backup started:

Name                           Value

oracle_sid                     SID

oracle_home                    /oracle/SID/102_64

oracle_profile                 /oracle/SID/102_64/dbs/initSID.ora

sapdata_home                   /oracle/SID

sap_profile                    /oracle/SID/102_64/dbs/initSID.sap

backup_mode                    ALL

backup_type                    online

backup_dev_type                tape

compress                       no

tape_copy_cmd                  dd

cpio_flags                     -ovB

cpio_in_flags                  -iuvB

dd_flags                       obs=64k bs=64k

dd_in_flags                    ibs=64k bs=64k

rewind                         mt -f $ rewind

rewind_offline                 mt -f $ rewind

tape_size                      2048000.000 MB

tape_address                   /dev/rmt/0mn,/dev/rmt/1mn

tape_address_rew               /dev/rmt/0m,/dev/rmt/1m

volume_backup                  SIDB11,SIDB12

expir_period                   0

tape_use_count                 100

exec_parallel                  2

system_info                    SIDadm/oraSID eccprod SunOS 5.10 Generic_147440-19 sun4u

oracle_info                    SID 10.2.0.4.0 8192 139857 18188985270 eccprod UTF8 UTF8 4021187988 &SID

sap_info                       700 SAPSR3 0002LK0003SID0011Y10086678010015Maintenance_ORA

make_info                      sun_64 OCI_102 Sep 18 2012

command_line                   brbackup -u / -jid ALLOG20140701183345 -c force -t online -m all -p initSID.sap -v SIDB11,SIDB12 -a -c force -p initSID.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance SID

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oracle/SID/oraarch/SIDarch

Archive format                 %t_%s_%r.dbf

What parameter need to be configured?

Thank You

Edy

[thiago_cavalheiro]

Hello Edy,

Run the check script from note 1171650 as indicated on the note itself to check the parameters that need changing.

Regards,

Thiago

[Former Member]

Hi Thiago,

I have done executed the script and adjust the parameter that recommended by this script.

Thank You

Edy

[thiago_cavalheiro]

Hi Edy,

That's good. Did you notice any improvement?

Regards,

Thiago

[Former Member]

Hi Thiago,

Yes, I did. I follow all recommendation from result of this script.

Do you have any suggestion to analyze slow backup performance after Oracle Upgrade to 11.2.0.4 and SAP Kernel 721?

Thank You

Edy