dbTalk Databases Forums  

RMAN

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss RMAN in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ExecMan
 
Posts: n/a

Default RMAN - 01-26-2012 , 09:08 AM






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;
}

Reply With Quote
  #2  
Old   
Jack
 
Posts: n/a

Default Re: RMAN - 02-23-2012 , 12:10 AM






"ExecMan" kirjoitti
viestissä:4c0ed053-8e85-4c4d-92e2-0d692e6bbadf (AT) k28g2000yqn (DOT) 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?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.