Re: RMAN

From: Jack <none_at_INVALID.com>
Date: Thu, 23 Feb 2012 08:10:44 +0200
Message-ID: <GLk1r.16327$I33.5116_at_uutiset.elisa.fi>

"ExecMan" kirjoitti
viestissä:4c0ed053-8e85-4c4d-92e2-0d692e6bbadf_at_k28g2000yqn.googlegroups.com...

Hi,

This database is only 60GB, and is taking 9 hours for RMAN to back up?? Though the disk where the backup files are put is mounted NFS, that still does not explain 9 hours. I am pasting the commands we use below. Can anyone see what the hold up is? I do not want to paste a huge log here unless someone thinks it will help.

Thanks!

run {

allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;

sql "alter system archive log current";
crosscheck archivelog all;
crosscheck copy;
crosscheck backup of database;
crosscheck backup of controlfile;
delete force noprompt obsolete;
delete force noprompt expired backup;
backup validate database archivelog all; backup current controlfile format '/backup/oracle/OR00/control/%d_%T_
%s';

backup incremental level 1 cumulative database format '/backup/oracle/OR00/rman/D_ora_%M%D%Y_OR00_%p%s' tag daily_backup
filesperset 3
plus archivelog format '/backup/oracle/OR00/rman/archive/arc_%M%D
%Y_OR00_%p%s' delete input;

restore database validate;
}

Is disk or CPU saturated? Received on Thu Feb 23 2012 - 00:10:44 CST