Exadata RMAN Image Copy backup with ZFS Storage Appliance

RMAN image copy backup is a block by block copy of target database consist of data files, archive logs, and control files. Block by block copy comes with an obvious flaw that it cannot be compressed, so storage requirements should be taken into consideration before opting for RMAN Image copy backups. If your target database size in Terabytes, it takes up significant storage space to hold image copy backup. Fortunately, if you are using ZFS appliance to store image copy backups, you can use Oracle ZFS Storage appliance native compression to save storage. Oracle ZFS storage appliance support many different types of compression for different types of workload but it is recommended to use LZ4 for Image copy backups.

Related Blog:

General guidelines for using ZFS storage appliance for Exadata Backups

Sample RMAN Image Copy Backup script:

run

{

sql 'alter system set "_backup_file_bufcnt"=64 scope=memory';

sql 'alter system set "_backup_file_bufsz"=1048576 scope=memory';

sql 'ALTER SYSTEM SWITCH ALL LOGFILE';

allocate channel ch01 device type disk connect 'sys/********@proddb_bkup1' FORMAT '/zfssa/proddb/imgbackup1/%U’;

allocate channel ch02 device type disk connect 'sys/********@proddb_bkup2' FORMAT '/zfssa/proddb/imgbackup2/%U’;

allocate channel ch03 device type disk connect 'sys/********@proddb_bkup3' FORMAT '/zfssa/proddb/imgbackup3/%U’;

allocate channel ch04 device type disk connect 'sys/********@proddb_bkup4' FORMAT '/zfssa/proddb/imgbackup4/%U’;

allocate channel ch05 device type disk connect 'sys/********@proddb_bkup5' FORMAT '/zfssa/proddb/imgbackup5/%U’;

allocate channel ch06 device type disk connect 'sys/********@proddb_bkup6' FORMAT '/zfssa/proddb/imgbackup6/%U’;

allocate channel ch07 device type disk connect 'sys/********@proddb_bkup7' FORMAT '/zfssa/proddb/imgbackup7/%U’;

allocate channel ch08 device type disk connect 'sys/********@proddb_bkup8' FORMAT '/zfssa/proddb/imgbackup8/%U’;

allocate channel ch09 device type disk connect 'sys/********@proddb_bkup1' FORMAT '/zfssa/proddb/imgbackup1/%U’;

allocate channel ch10 device type disk connect 'sys/********@proddb_bkup2' FORMAT '/zfssa/proddb/imgbackup2/%U’;

allocate channel ch11 device type disk connect 'sys/********@proddb_bkup3' FORMAT '/zfssa/proddb/imgbackup3/%U’;

allocate channel ch12 device type disk connect 'sys/********@proddb_bkup4' FORMAT '/zfssa/proddb/imgbackup4/%U’;

allocate channel ch13 device type disk connect 'sys/********@proddb_bkup5' FORMAT '/zfssa/proddb/imgbackup5/%U’;

allocate channel ch14 device type disk connect 'sys/********@proddb_bkup6' FORMAT '/zfssa/proddb/imgbackup6/%U’;

allocate channel ch15 device type disk connect 'sys/********@proddb_bkup7' FORMAT '/zfssa/proddb/imgbackup7/%U’;

allocate channel ch16 device type disk connect 'sys/********@proddb_bkup8' FORMAT '/zfssa/proddb/imgbackup8/%U’;

backup incremental level 1 for recover of copy with tag 'IMAGECOPY' database;

recover copy of database with tag 'IMAGECOPY';

sql "ALTER DATABASE BACKUP CONTROLFILE TO ''/zfssa/proddb/imgbackup1/proddb/control.bkp''";

release channel ch01;

release channel ch02;

release channel ch03;

release channel ch04;

release channel ch05;

release channel ch06;

release channel ch07;

release channel ch08;

release channel ch09;

release channel ch10;

release channel ch11;

release channel ch12;

release channel ch13;

release channel ch14;

release channel ch15;

release channel ch16;

}