RMAN convert optimization
When converting a database from one operating system to another one (to phase out your Itanium infrastructure for example) you may be tempted to play with parallelism parameter when converting your tablespaces (having one datafile in our example). This RMAN convert phase is obviously needed when your destination platform endian format is not he same:
SQL> set lines 130 SQL> col PLATFORM_NAME for a40 SQL> select platform_name, endian_format from v$transportable_platform order by 1; PLATFORM_NAME ENDIAN_FORMAT ---------------------------------------- -------------- AIX-Based Systems (64-bit) Big Apple Mac OS Big HP IA Open VMS Little HP Open VMS Little HP Tru64 UNIX Little HP-UX (64-bit) Big HP-UX IA (64-bit) Big IBM Power Based Linux Big IBM zSeries Based Linux Big Linux 64-bit for AMD Little Linux IA (32-bit) Little Linux IA (64-bit) Little Microsoft Windows 64-bit for AMD Little Microsoft Windows IA (32-bit) Little Microsoft Windows IA (64-bit) Little Solaris Operating System (AMD64) Little Solaris Operating System (x86) Little Solaris[tm] OE (32-bit) Big Solaris[tm] OE (64-bit) Big 19 rows selected.
You see in below example that a datafile conversion is sequential and parallelism is not apply at all (testing has been done with Oracle 10.2.0.3.0 on HPUX IA 11.23):
server1{oracle}# rman
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Apr 7 17:35:28 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: DB1 (DBID=329576362)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora_db1/software/dbs/snapcf_db1.f'; # default
RMAN> sql 'alter tablespace DMDATA3 read only';
sql statement: alter tablespace DMDATA3 read only
RMAN> convert tablespace DMDATA3 to platform 'Linux 64-bit for AMD' format '/backup/%U';
Starting backup at 07-APR-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00007 name=/ora_db1/data01/db1/dmdata3_01.dbf
converted datafile=/backup/data_D-DB1_I-329576362_TS-DMDATA3_FNO-7_01m96nr6
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:05:06
Finished backup at 07-APR-11
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> convert tablespace DMDATA3 to platform 'Linux 64-bit for AMD' format '/backup/%U';
Starting backup at 07-APR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=402 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=433 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00007 name=/ora_db1/data01/db1/dmdata3_01.dbf
converted datafile=/backup/data_D-DB1_I-329576362_TS-DMDATA3_FNO-7_02m96o7p
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:05:45
Finished backup at 07-APR-11
This last example of conversion clearly demonstrate that main bottleneck is I/O and that figures are quite erratic if other processes are using same disk:
RMAN> convert tablespace DMDATA3 to platform 'Linux 64-bit for AMD' format '/backup/%U' parallelism=6; Starting backup at 07-APR-11 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 allocated channel: ORA_DISK_5 channel ORA_DISK_5: sid=423 devtype=DISK allocated channel: ORA_DISK_6 channel ORA_DISK_6: sid=418 devtype=DISK channel ORA_DISK_1: starting datafile conversion input datafile fno=00007 name=/ora_db1/data01/db1/dmdata3_01.dbf converted datafile=/backup/data_D-DB1_I-329576362_TS-DMDATA3_FNO-7_04m96otf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:03:25 Finished backup at 07-APR-11 RMAN> convert tablespace DMDATA3 to platform 'Linux 64-bit for AMD' format '/backup/%U' parallelism=1; Starting backup at 07-APR-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile conversion input datafile fno=00007 name=/ora_db1/data01/db1/dmdata3_01.dbf converted datafile=/backup/data_D-DB1_I-329576362_TS-DMDATA3_FNO-7_05m96p9m channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:03:25 Finished backup at 07-APR-11
But parallelism parameter do have an interest when converting, one shot, a whole database and/or tablespaces with many datafiles (more common configuration). In this case each channel will handle a datafile and will parallelize the job, having fast disk for target directory is, in this case, mandatory…


