We have an ASM database on a P780 AIX with almost 72 data files and the DB size now is 200 GB
The backup started to take almost 3 hours the I have started to allocate 16 channels as following
RUN {
allocate channel d1 type disk ;
allocate channel d2 type disk ;
allocate channel d3 type disk ;
allocate channel d4 type disk ;
allocate channel d5 type disk ;
allocate channel d6 type disk ;
allocate channel d7 type disk ;
allocate channel d8 type disk ;
allocate channel d9 type disk ;
allocate channel d10 type disk ;
allocate channel d11 type disk ;
allocate channel d12 type disk ;
allocate channel d13 type disk ;
allocate channel d14 type disk ;
allocate channel d15 type disk ;
allocate channel d16 type disk ;
backup check logical as compressed backupset tag='DBPRO_rmanbackup_compressed'
database filesperset 1 plus archivelog;
crosscheck backupset;
crosscheck copy;
crosscheck archivelog all;
delete noprompt expired backup ;
delete expired archivelog all;
delete noprompt obsolete;
}
How can we improve this to be faster ?
Can we use maxopenfiles here?
Is using filesperset 1 correct here?
Oracle Database
Last Comment
it-rex
8/22/2022 - Mon
slightwv (䄆 Netminder)
Do you need to do a full backup every night?
I would suggest a rolling incremental with block change tracking:
Then only blocks that have changed are backed up and the incremental is merged back into your level 0 (full) so you always have a full around.
it-rex
ASKER
what if I want to improve this full backup.
before it used to be 1 channel and took 4 hours now with 16 channel it went down to 1 and 40 minutes,I think we can do more.
I would suggest a rolling incremental with block change tracking:
4.4.3 Incrementally Updated Backups: Rolling Forward Image Copy Backups
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm
Then only blocks that have changed are backed up and the incremental is merged back into your level 0 (full) so you always have a full around.