Hello,
I just was thrown into a position where i am administering a 80 TB database. The previous DBA left and didn't provide any documentation on the backups.
We are using an incremental backup strategy initiated through cron. The cumulative level 0's are initiated on Friday but they are running abnormally long, over 70 hours. This is not acceptable, and i am looking to better optimize this backup. I plan to only utilize ASM for the time being unless space allocation becomes a problem.
I see that some of the backup is going to an nfs mount point and some are going to ASM. It looks like the previous level 0 is located on nfs and some of the level 1's are on both ASM and nfs.
Block Change tracking is enabled and i am in the process of moving that to ASM because it is currently on local file system.
Optimization is turned on.
This is the backup script :
run {
crosscheck backup;
crosscheck archivelog all;
delete expired backup;
delete expired
backup device type disk archivelog all not backed up delete all input;
backup incremental level 0 cumulative database format '+FRA/Sid/backupset/BACKUP_LVL0_%T_%s_%u';
backup current controlfile format '+FRA/Sid/autobackup/%U';
allocate channel oem_backup_disk1 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk2 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk3 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk4 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk5 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk6 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk7 type disk maxpiecesize 1000 G;
allocate channel oem_backup_disk8 type disk maxpiecesize 1000 G;
release channel oem_backup_disk1;
release channel oem_backup_disk2;
release channel oem_backup_disk3;
release channel oem_backup_disk4;
release channel oem_backup_disk5;
release channel oem_backup_disk6;
release channel oem_backup_disk7;
release channel oem_backup_disk8;
}
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
Any assistance would be appreciated.