Shulou(Shulou.com)06/02 Report--

Briefly tested the ability of the rac environment to back up to the tape library through RMAN.

Database: Oracle 10203 RAC for Solaris8

Tape library: Quantum PX502

Backup software: Veritas netbackup 6. 0

Because the band library is 502, it contains two controllers. That is, it should be possible to improve backup performance with two controlled parallel writes. But the test found that it didn't seem to be what I expected.

First, let's take a look at starting a channel on a node for backup:

$rman target /

Recovery Manager: Release 10.2.0.3.0-Production on Thursday May 10 16:42:19 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to the target database: TESTRAC (DBID=4291216984)

RMAN > run

2 > {

3 > allocate channel C1 device type sbt

4 > backup database

5 >}

Assigned channel: C1 channel C1: sid=296 instance = testrac1 devtype=SBT_TAPE channel C1: VERITAS NetBackup for Oracle-Release 6.0 (2006110304)

Start backup in November-May-07 channel C1: start all data files backup set channel C1: specifying data files in backup set input data files fno=00006 name=+DISK/testrac/datafile/zhejiang01.dbf input data files fno=00007 name=+DISK/testrac/datafile/zhejiang02.dbf input data files fno=00009 name=+DISK/testrac/datafile/zhejiang03.dbf input data files fno=00011 name=+DISK/testrac/datafile/zhejiang04.dbf input data files fno=00012 name=+DISK/testrac/ Datafile/zhejiang05.dbf input data file fno=00014 name=+DISK/testrac/datafile/zhejiang06.dbf import data file fno=00008 name=+DISK/testrac/datafile/ndmain01.dbf import data file fno=00002 name=+DISK/testrac/datafile/undotbs1.263.618591197 import data file fno=00004 name=+DISK/testrac/datafile/undotbs2.266.618591249 import data file fno=00010 name=+DISK/testrac/datafile/ndindex01.dbf import data file fno=00013 name=+DISK/testrac/datafile/lt_index_ts01.dbf import data file fno=00001 name=+DISK/testrac/ Datafile/system.262.618591167 input data file fno=00003 name=+DISK/testrac/datafile/sysaux.264.618591225 input data file fno=00005 name=+DISK/testrac/datafile/users.267.618591279 channel C1: starting segment 1 on November-May-07 channel C1: completed segment 1 on November-May-07 segment handle = 1qihelgr_1_1 tag = TAG20070511T091922 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C1: backup set completed Time elapsed: 01:25:45 channel C1: start all data files backup set channel C1: data files backup set in specified backup set including current control files in backup set including current SPFILE channel C1: starting segment 1 in November-May-07 channel C1: completed segment 1 in November-May-07 segment handle = 1riheqhl_1_1 tag = TAG20070511T091922 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C1: backup set completed, time elapsed: 00:00:57 completed Channel released by backup in November-May-07: C1

RMAN >

You can see that the backup took about 1 hour and 25 minutes.

Let's try to allocate two CHANNEL on one node to back up:

RMAN > run

2 > {

3 > allocate channel C1 device type sbt

4 > allocate channel c2 device type sbt

5 > backup database

6 >}

Assigned channel: C1 channel C1: sid=296 instance = testrac1 devtype=SBT_TAPE channel C1: VERITAS NetBackup for Oracle-Release 6.0 (2006110304)

Assigned channel: C2 channel c2: sid=301 instance = testrac1 devtype=SBT_TAPE channel c2: VERITAS NetBackup for Oracle-Release 6.0 (2006110304)

Start backup in November-May-07 channel C1: start all data files backup set channel C1: specifying data files in backup set input data files fno=00006 name=+DISK/testrac/datafile/zhejiang01.dbf input data files fno=00009 name=+DISK/testrac/datafile/zhejiang03.dbf input data files fno=00012 name=+DISK/testrac/datafile/zhejiang05.dbf input data files fno=00008 name=+DISK/testrac/datafile/ndmain01.dbf input data files fno=00010 name=+DISK/testrac/ Datafile/ndindex01.dbf input data file fno=00001 name=+DISK/testrac/datafile/system.262.618591167 input data file fno=00005 name=+DISK/testrac/datafile/users.267.618591279 channel C1: starting segment 1 on November-May-07 channel c2: start all data files backup set channel c2: specifying data files in backup set input data files fno=00007 name=+DISK/testrac/datafile/zhejiang02.dbf input data files fno=00011 name=+DISK/testrac / datafile/zhejiang04.dbf input data file fno=00014 name=+DISK/testrac/datafile/zhejiang06.dbf input data file fno=00002 name=+DISK/testrac/datafile/undotbs1.263.618591197 input data file fno=00004 name=+DISK/testrac/datafile/undotbs2.266.618591249 input data file fno=00013 name=+DISK/testrac/datafile/lt_index_ts01.dbf input data file fno=00003 name=+DISK/testrac/datafile/sysaux.264.618591225 channel c2: starting segment 1 in November-May-07 channel C1: Completed paragraph 1 on November-May-07 paragraph handle = 1siheql7_1_1 tag = TAG20070511T104702 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C1: backup set completed Time elapsed: 00:42:17 channel C1: start all data files backup set channel C1: data files backup set in the specified backup set including current control file channel C1: starting segment 1 in November-May-07 channel c2: completed segment 1 in November-May-07 segment handle = 1tiheql8_1_1 tag = TAG20070511T104702 comment = API Version 2.0 MMS Version 5.0.0.0 Channel c2: backup set completed Time elapsed: 01:24:33 channel c2: start all data files backup set channel c2: data files in the specified backup set contain the current SPFILE channel in the backup set c2: starting segment 1 in November-May-07 channel C1: completed segment 1 in November-May-07 segment handle = 1uihet4g_1_1 tag = TAG20070511T104702 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C1: backup set completed, time elapsed: 00:43:03 Channel c2: completed Segment 1 in November-May-07 Segment handle = 1vihevjp_1_1 tag = TAG20070511T104702 comment = API Version 2.0 Version 5.0.0.0 Channel c2: backup set completed, after time: 00:01:31 completed Channel released by backup in November-May-07: Channel released by C1: C2

RMAN >

It was found that although two channel were allocated, the first channel backup took 42 minutes, while the second channel still took 1 hour and 24 minutes. In other words, there is no performance improvement.

At the same time, start the jnbSA graphical interface with root and find that only one controller is working, that is to say, although two channel are assigned, the two channel are still working serially. When the first backup ends, the backup of the second channel begins. Therefore, the total amount of time consumed is still so much.

In order for two controls to work at the same time, consider allocating two channel and connecting to two different instances as follows:

RMAN > RUN

2 > {

3 > ALLOCATE CHANNEL C1 DEVICE TYPE SBT CONNECT SYS/TEST@TESTRAC1

4 > ALLOCATE CHANNEL C2 DEVICE TYPE SBT CONNECT SYS/TEST@TESTRAC2

5 > BACKUP DATABASE

6 >}

Assigned channel: C1 channel C1: sid=293 instance = testrac1 devtype=SBT_TAPE channel C1: VERITAS NetBackup for Oracle-Release 6.0 (2006110304)

Assigned channel: C2 channel C2: sid=289 instance = testrac2 devtype=SBT_TAPE channel C2: VERITAS NetBackup for Oracle-Release 6.0 (2006110304)

Start backup on November-May-07 channel C1: start all data files backup set channel C1: specifying data files in backup set input data files fno=00006 name=+DISK/testrac/datafile/zhejiang01.dbf input data files fno=00009 name=+DISK/testrac/datafile/zhejiang03.dbf input data files fno=00012 name=+DISK/testrac/datafile/zhejiang05.dbf input data files fno=00008 name=+DISK/testrac/datafile/ndmain01.dbf input data files fno=00010 name=+DISK/testrac/ Datafile/ndindex01.dbf input data file fno=00001 name=+DISK/testrac/datafile/system.262.618591167 input data file fno=00005 name=+DISK/testrac/datafile/users.267.618591279 channel C1: starting segment 1 on November-May-07 channel C2: start all data files backup set channel C2: specifying data files in backup set input data files fno=00007 name=+DISK/testrac/datafile/zhejiang02.dbf input data files fno=00011 name=+DISK/testrac / datafile/zhejiang04.dbf input data file fno=00014 name=+DISK/testrac/datafile/zhejiang06.dbf input data file fno=00002 name=+DISK/testrac/datafile/undotbs1.263.618591197 input data file fno=00004 name=+DISK/testrac/datafile/undotbs2.266.618591249 input data file fno=00013 name=+DISK/testrac/datafile/lt_index_ts01.dbf input data file fno=00003 name=+DISK/testrac/datafile/sysaux.264.618591225 channel C2: starting segment 1 from November to May-07 channel C2: Completed paragraph 1 on November-May-07 paragraph handle = 21ihf3gn_1_1 tag = TAG20070511T131819 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C2: backup set completed Time elapsed: 00:41:01 channel C2: start all data files backup set channel C2: data files backup set in specified backup set including current control file channel C2: starting segment 1 in November-May-07 channel C2: completed segment 1 in November-May-07 section handle = 22ihf5tl_1_1 tag = TAG20070511T131819 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C2: backup set completed Time elapsed: 00:01:06 channel C2: start all data files backup set channel C2: data files in the specified backup set contain the current SPFILE channel C2: starting segment 1 from November to May-07 channel C2: completed segment 1 from November to May-07 handle = 23ihf5vn_1_1 tag = TAG20070511T131819 comment = API Version 2.0 MMS Version 5.0.0.0 Channel C2: backup set completed, after time: 00:01:07 Channel C1: completed Segment 1 on November-May-07 Segment = 20ihf3gs_1_1 tag = TAG20070511T131819 comment = API Version 2.0 Version 5.0.0.0 Channel C1: backup set completed, after time: 00:44:39 completion of backup released in November-May-07 Channel: C1 released Channel: C2

RMAN >

This method backups, each node will back up part of the data files, from the graphical interface observation, the two controllers work at the same time, from the final backup time can also be seen that the entire backup only took about 44 minutes, the execution time has been reduced by half.

Since you are not familiar with hardware and backup software, it is not clear whether a node can only use one controller. However, for this default, the RAC environment can improve the performance of backups in this last way.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.