One of my larger AIX DB servers running RMAN backups for Oracle is creating over 3400 save sets daily when performing a backup. There is a recurring size of 257KB for many of the save sets. I currently have 1.8 million save sets going back 3 years on my system. I cannot view more a few days of these with the java GUI as it runs out of memory and just hangs. This cannot be an efficient use of resources. Is this a configuration error?
run { allocate channel C1 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; allocate channel C2 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; allocate channel C3 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; allocate channel C4 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; allocate channel C5 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; allocate channel C6 device type SBT parms "SBT_PARMS=(NSR_MMDB_RETRY_TIME=30,NSR_MAX_START_RETRIES=100)"; send 'NSR_ENV=(NSR_SERVER=corp-nw.corp.local,NSR_CLIENT=rcodbschi037.xxxxxxxx.net,NSR_DATA_VOLUME_POOL=ddprimaryFileSystem)';
backup filesperset 20 format 'ARCH_%d_%t.%s.%p.`date +%Y%m%d.%H:%M:%S`.arch.bk' tag 'ARCH-${TODAY}' archivelog from time 'sysdate-7' not backed up 1 times;
DELETE force noprompt archivelog until time 'sysdate-5' backed up 1 times to device type sbt;
backup current controlfile format 'ARCH_%d_%t.%s.%p.`date +%Y%m%d.%H:%M:%S`.ctl.bk' tag 'ARCH-${TODAY}';
#==================================================================================================# #**************************** MAIN SECTION OF SCRIPT ********************************************* # #==================================================================================================#
@DonAIX, the fileperset is set to 1 for full backup for a better restore performance. Can you check if you have this parameter - MAXSETSIZE set in RMAN outside this script ?
crazyrov
6 Operator
•
1319 Posts
782
0
Posted July 9th, 2020 20:00
@DonAIX, Can you share your RMAN script with us ?