FAQ-How to Elevate the Oracle Database Backup Performance

Publication Date:  2015-07-31 Views:  251 Downloads:  0
Issue Description
How to Elevate the Oracle Database Backup Performance?
Solution
NOTE:
Many complicated factors impact the Oracle database backup performance, so only the trained engineers or database administrators can perform operations related to backup performance improvements.

Influential Factors

The networking of NetBackup backup is shown in Figure 1. Each element in this figure may affect the backup performance.

Network

Backup throughput may be affected by many network elements, such as network bandwidth, NIC drive, full-duplex mode, DNS server, and network storms. To optimize network elements, contact the equipment room administrator.

NetBackup

NetBackup allows multi-stream concurrent backups by enabling multiple channels. To achieve multi-stream concurrent backups, ensure that the following conditions must be met:
  • The backup script supports multi-stream concurrent backups.
          Two backup channels are available for the common backup script. You can allocate more backup channels by editing the backup script. For details, see Allocating Backup Channels to the Backup Script.
  • The global attributes of the HDP3500E master server are set to support multi-stream concurrent backups. For details on the setting method, see Global Attributes of the HDP3500E.
Storage media

By default, the HDP3500E storage media support multi-stream concurrent backups.

Figure 1 Backup networking




Allocating Backup Channels to the Backup Script

Perform the following steps to add backup channels to the backup script:

NOTE:
Allocating backup channels up to 4 in the backup script.

1.  Log in to the Oracle database server as user root.

2.  Go to the directory that saves the backup script and add backup channels in the backup script.

     You can find the name and directory of the backup script in the backup policy for Oracle database.

     For example, editing the backup script in the single-host Oracle environment.

cd /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/
vi nbu_oracle_clt_hot_database_backup.sh


     When backing up the Oracle database and archived log files, add two backup channels: CHANNEL ch02 TYPE 'SBT_TAPE' and CHANNEL ch03 TYPE 'SBT_TAPE'.

Add the following content in the backup script:

ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';

Release the two backup channels after the backup.

RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;

After adding backup channels, the backup script is shown as below:

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
BACKUP
    $BACKUP_TYPE
    SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    FILESPERSET 5
    # recommended format
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
BACKUP
   filesperset 20
   FORMAT 'al_%s_%p_%t'
   ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;


3.  After the backup script is edited, save the changes and exit.

Global Attributes of the HDP3500E

Perform the following steps to set attributes so that multi-stream concurrent backups can be supported on the HDP3500E master server.

1.  Log in as user root to the NetBackup Administration Console on the HDP3500E master server.
For details, refer to Logging In to the NetBackup Administration Console in the OceanStor HDP3500E G3 V100R003 Installation Guide.

2.  In the navigation tree, choose NetBackup Management > Host Properties > Master Servers. Double-click on the function pane and the Master Server Properties:masterserver dialog box is displayed.

3.  In the navigation tree, click Global Attributes. Enter a desired value (4 for example) in the Maximum jobs per client text box.

The value can be larger than the number of backup channels but it is recommended that the value is consistent with the number of the backup channels in the backup script.





4.  Click OK. The multi-stream concurrent backup function takes effect only after the setting is complete.

END