Configuring Oracle RMAN

Configuring Oracle RMAN channel and parallelism includes specifying the file system targets for the Oracle RMAN backup channels and the total number of channels used for backup and restore operations. Performance benefits can be realized by configuring 16 Oracle RMAN channels spanning the available ZFS Storage Appliance shares. Configure Oracle RMAN channels such that they are evenly distributed over the Oracle Database instances and nodes in the RAC cluster and evenly distributed over the shares exported from the ZFS Storage Appliance.

The following code fragments show sample Oracle RMAN run blocks for performing backup and restore operations for backup sets and image copies as well as applying incremental merges to image copies. The sample code is based on the following database configuration:

• Database name: dbname

• SYSDBA login: sys/welcome

• Scan address: ad01-scan

• Service names for the backup: dbname_bkup

The ZFS Storage Appliance can be configured in a one-pool configuration in which the appliance exports eight shares used as eight mount points.

The Oracle RMAN run blocks for backup and restore using backup sets and image copies are shown in the examples in the sections below. In these examples, the mount points for the four-share configuration are accessed as /zfssa/dbname/backup1 through /zfssa/dbname/backup4. Also, the examples are for a configuration in which the ZFS Storage Appliance exports four shares used as four mount points for 16 Oracle RMAN channels.

Backup set level 0 backup:

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup as backupset incremental level 0 section size 32g database<br/>
   tag ’FULLBACKUPSET_L0’ plus archivelog tag ’FULLBACKUPSET_L0’;    
}

Backup set level 1 backup:

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup as backupset incremental level 1 database tag<br/>
   ’FULLBACKUPSET_L1’ plus archivelog tag ’FULLBACKUPSET_L1’;
}

Image copy backup:

run
{<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup2/%U’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup1/%U’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’ format ’/zfssa/dbname/backup4/%U’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’ format ’/zfssa/dbname/backup3/%U’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   backup incremental level 1 for recover of copy with tag ’IMAGECOPY’<br/>
   database;    
}

Incremental merge to image copy:

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   recover copy of database with tag ’IMAGECOPY’;
}

Restore validate:

run
{<br/>
   sql ’alter system set "_backup_disk_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_disk_bufsz"=1048576 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufcnt"=64 scope=memory’;<br/>
   sql ’alter system set "_backup_file_bufsz"=1048576 scope=memory’;<br/>
   allocate channel ch01 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch02 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch03 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch04 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch05 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch06 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch07 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch08 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch09 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch10 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch11 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch12 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch13 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch14 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   allocate channel ch15 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup1’;<br/>
   allocate channel ch16 device type disk connect ’sys/welcome@ad01-<br/>
   scan/dbname_bkup2’;<br/>
   configure snapshot controlfile name to<br/>
   ’/zfssa/dbname/backup1/snapcf_dbname.f’;<br/>
   restore validate database;
}