Hello all,
we have strange issue although we are using EXDATA but still RMAN crosscheck and delete command is taking too long say 4 to 5 hours or more.. and complete backup (CRD FILES) is taking just few hours..
if full backup is taking 10 hours for 12tb DB 3 hours backup is completing rest is taken by crosscheck and delete.. strange..
we have raised n number of SR's with oracle but with no help.
some times its happening the backup (with backup+crosscheck+delete) is overlapping with next day's rman schedule backup.
can anyone share some way to fix this issue…
here are the clause used for crosscheck and delete..
CROSSCHECK ARCHIVELOG ALL;
crosscheck backup;
delete NOPROMPT backup completed before 'sysdate - 15' DEVICE TYPE DISK;
DELETE FORCE NOPROMPT BACKUPSET completed before 'sysdate - 15';
delete noprompt force archivelog all backed up 1 times to device type disk completed before 'sysdate-2' ;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 15 DAYS;
We ran wait event sql during whole rman backup and using excel captured the most often wait hit as below.
event_name (Count(EVENT))
cell single block physical read: xrmem cache 111
control file sequential read 473
Disk file Mirror Read 316
Disk file operations I/O 207
enq: BS - Backup spare1 116
kfk: async disk IO 441
KSV master wait 538
latch free 155
recovery area: computing obsolete files 158
RMAN backup & recovery I/O 43
regards
R Syed