Hi Gurus,
I wanted to implement the rman backup optimization feature. I did a small test to check its usage and didnt find it much useful as everytime I do a full backup it takes backup of all the datafiles and nothing is skipped.
As per ORACLE notes as below, Ideally, once I backup the database, the other backup should not skip all files.
If you enable backup optimization, then the BACKUP command skips backing up files when the identical file has already been backed up to the specified device type.
Please note that this is my test server and no connections are made to the DB. Listener is down. So no point of change scn. Am I missing here something?
Oracle version - 11.2.0.4
RMAN> run
2> { allocate channel ch1 type
3> disk format '/oraback/RMAN/%d_DB_%u_%s_%p';
4> backup database;
5> }
allocated channel: ch1
channel ch1: SID=172 device type=DISK
Starting backup at 28-APR-15
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oradata/nmsdata/system01.dbf
input datafile file number=00006 name=/u04/oradata/nmsdata/NMSINFO_DATA01_02.dbf
input datafile file number=00005 name=/u04/oradata/nmsdata/NMSINFO_DATA01_01.dbf
input datafile file number=00007 name=/u03/oradata/nmsdata/NMSINFO_INDX01.dbf
input datafile file number=00003 name=/u01/oradata/nmsdata/undotbs01.dbf
input datafile file number=00002 name=/u01/oradata/nmsdata/sysaux01.dbf
channel ch1: starting piece 1 at 28-APR-15
channel ch1: finished piece 1 at 28-APR-15
piece handle=/oraback/RMAN/NMSDATA_DB_ngq5g2vv_71408_1 tag=TAG20150428T042431 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:25
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/oradata/nmsdata/users01.dbf
channel ch1: starting piece 1 at 28-APR-15
channel ch1: finished piece 1 at 28-APR-15
piece handle=/oraback/RMAN/NMSDATA_DB_nhq5g30o_71409_1 tag=TAG20150428T042431 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 28-APR-15
Starting Control File and SPFILE Autobackup at 28-APR-15
piece handle=/opt/app/oracle/product/11.2.0.4_ee/dbs/c-3349937142-20150428-00 comment=NONE
Finished Control File and SPFILE Autobackup at 28-APR-15
released channel: ch1
RMAN> show all;
RMAN configuration parameters for database with db_unique_name CHNMCPRDB1_NMSDATA are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
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 CHANNEL 1 DEVICE TYPE DISK FORMAT '${backup_dir}/${ORACLE_SID}/%d_t%t_s%s_p%p';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/RMAN';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/nmsdata_snapshot_arch.ctl';
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
RMAN> run
{ allocate channel ch1 type
disk format '/oraback/RMAN/%d_DB_%u_%s_%p';
backup database;
}
2> 3> 4> 5>
allocated channel: ch1
channel ch1: SID=172 device type=DISK
Starting backup at 28-APR-15
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oradata/nmsdata/system01.dbf
input datafile file number=00006 name=/u04/oradata/nmsdata/NMSINFO_DATA01_02.dbf
input datafile file number=00005 name=/u04/oradata/nmsdata/NMSINFO_DATA01_01.dbf
input datafile file number=00007 name=/u03/oradata/nmsdata/NMSINFO_INDX01.dbf
input datafile file number=00003 name=/u01/oradata/nmsdata/undotbs01.dbf
input datafile file number=00002 name=/u01/oradata/nmsdata/sysaux01.dbf
channel ch1: starting piece 1 at 28-APR-15
channel ch1: finished piece 1 at 28-APR-15
piece handle=/oraback/RMAN/NMSDATA_DB_njq5g509_71411_1 tag=TAG20150428T045849 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:25
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/oradata/nmsdata/users01.dbf
channel ch1: starting piece 1 at 28-APR-15
channel ch1: finished piece 1 at 28-APR-15
piece handle=/oraback/RMAN/NMSDATA_DB_nkq5g512_71412_1 tag=TAG20150428T045849 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 28-APR-15
Starting Control File and SPFILE Autobackup at 28-APR-15
piece handle=/opt/app/oracle/product/11.2.0.4_ee/dbs/c-3349937142-20150428-01 comment=NONE
Finished Control File and SPFILE Autobackup at 28-APR-15
released channel: ch1
RMAN> exit