Exadata Traditional RMAN backup with ZFS Storage Appliance

RMAN backup sets are logical entities create by RMAN backup which can be both encrypted and compressed at the same time. A traditional RMAN Backup strategy involve performing full backups or any combination of level 0, level 1 cumulative incremental, and differential backup to restore and recover the database in the event of a physical or logical failure. Basically, traditional Exadata backup strategy is full online backup of database which are performed weekly or daily and have at least one copy of database transactional archive logs stored on Oracle ZFS Appliance.  This full backup and archive logs can be used to recover full database up to the point of failover in case of a recovery. Additionality, If you have properly size your redo logs for max 3 archive switches per hour, your RPO should never be more than 20 mins. Recommended version retention objectives (VRO) should be at least 2 full backups retained on ZFS Appliance all the time with older backups schedule to delete automatically. Additionally, its good idea perform full database backups for small databases to achieve better RTO. As per Oracle MMA best practices, a common implementation is a tiered approach that combines incremental level 0 and level 1 backup. Level 0 incremental backups are often taken on a weekly basis with level 1 differential or cumulative incremental backups performed daily.  It is also important to enable RMAN block change tracking, it can drastically improve the performance of incremental backups.

Related Blog:

General guidelines for using ZFS storage appliance for Exadata Backups

Sample Traditional RMAN backup script : 
run

{

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

BACKUP AS BACKUPSET SECTION SIZE 100G INCREMENTAL LEVEL 0 DATABASE FILESPERSET 1 TAG 'bkup_weekly_L0' plus ARCHIVELOG;

backup spfile format '/zfssa/proddb/backup1/spfile_%d_%s_%T_dbid%I.rman';

backup current controlfile format '/zfssa/proddb/backup1/Controlfile_%d_%T_dbid%I_s%s_p%p';

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;

}