DB Version : 11.2.0.4 (Enterprise Edition)
SunOS 5.10
We have 1.5 TB DB size and below is the RMAN compression setting. but recently i have realized that we are not using the BASIC compression while taking the full incremental level 0 backup. (our aim is to reduce the backup size due to cost factor.)
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
Current backup script:
run{
show all;
report schema;
allocate channel C1 device type 'SBT_TAPE';
allocate channel C2 device type 'SBT_TAPE';
backup incremental 0 database force;
backup archivelog all not backed up 1 times delete input;
delete noprompt obsolete;
sql "alter database backup controlfile to trace";
}
In one of the post (RMAN Compression Algorithms in 11gR2 - Database Specialists) I see the comparison in the backup size and time, it seems to be very promising to use the BASIC compression without much compromise on the backup elapsed time.
My question:
1) If we use the BASIC compression, will there be any additional license cost involves?
2) Will there be any significant impact on time DB recovery time? also if there is any challenge in using the compressed backup over non compressed BKP.
3) If we need to buy the advanced compression feature, how much is the cost ? (any useful URL on the license cost to understand the license stuff better )
Thank you all.