Diagnose the cause of slow Oracle RMAN backup

(I) First query the CPU and IO usage at the system level: Top, iostat, Sar...

(Ii) exec dbms_workload_repository.create_snapshot ();

(Iii) RMAN target/debug trace =/tmp/rmandebug.txt log =/tmp/rman_log20130727.txt
Execute backup

(Iv) exec dbms_workload_repository.create_snapshot ();

(V) query v $ backup_datafile

Set markup HTML onset echo onset pages 80 set lines 180 set numformat 99999999999999999 spool plugin file # fno, used_change_tracking BCT, initincr, incremental_change #, checkpoint_change #, datafile_blocks blks, block_size, blocks_read, round (blocks_read/datafile_blocks) * 100,2) "% read", blocks, round (blocks/datafile_blocks) * 100,2) "% wrtn", to_char (comletion_time, 'yyyy-mm-dd hh24: MI: ss') from V $ backup_datafileorder by file #, comletion_time; spool offset markup HTML off
 

By dba_waterbin

2013-07-27

Good luck