Hello all,
Whenever I run rman backup to sbt_tape, the complete database becomes slow.
Also RMAN takes more than 12 hours to complete.
RMAN script is:
run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system switch logfile';
backup incremental level 2 tag 'db_level2_backup'
format'%d/INC2/%t/%s/%p'
database diskratio=0;
backup
format '%d/LOG_INC2/%t/%s/%p'
archivelog all
delete all input;
release channel t1;
}
The AWR shows following "Top 5 timed events"
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 817,467 17,419 21 28.6 User I/O
CPU time 14,294 23.5
log file sync 141,642 8,570 61 14.1 Commit
enq: TX - row lock contention 3,371 7,171 2,127 11.8 Application
log file parallel write 149,486 5,356 36 8.8 System I/O
What can be done? Can anyone tell what wrong is happening here?
Database is 10.2.0.4
OS is AIX 5.3
SGA_TARGET is 6G
PGA_AGGREGATE_TARGET is 2G
Total physical RAM is 12G
EBiz application is running in the same server
Regards,
SA