No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

Rman backup is running slow.
Next thread: ORA-01791: not a SELECTed expression - select distinct 'alter table' ||
Prev thread: How to SELECT XMLTYPE data with Perl DBD::Oracle?

Message Score Author Date
Hi, We have a database of 7 TB size and for which...... indrajit chatterjee Aug 18, 2015, 21:25
What script do you use to backup? Regards Mi...... Michel Cadot Aug 18, 2015, 21:42
run { allocate channel t1 type 'sbt_tape' parms ...... indrajit chatterjee Aug 19, 2015, 00:02
What is the bottleneck during your backup? CPU? ...... Michel Cadot Aug 19, 2015, 08:08
Hi Indrajit, when you say "since a couple of da...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Dieter Henig Aug 21, 2015, 17:39
Thanks Dieter and Michele, We are suspecting the ...... indrajit chatterjee Aug 21, 2015, 20:58
The way depends on what is your bottleneck. So ...... Michel Cadot Aug 21, 2015, 21:34
Hi, I'm not sure what kind of Tape drive you ha...... Thameera Nawaratna Aug 24, 2015, 07:24

Follow up by mail Click here

Subject: Rman backup is running slow.
Author: indrajit chatterjee, India
Date: Aug 18, 2015, 21:25, 2845 days ago
Os info: AIX 6.1
Oracle info: 11.2.0.3
Message: Hi,
We have a database of 7 TB size and for which we have been experiencing a huge slowness of the backup for the last couple of days. Please guide what needs to be checked from the database end ? The backup is still running. Is there any mechanism to make a running rman backup faster ? Please guide.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: Michel Cadot, France
Date: Aug 18, 2015, 21:42, 2845 days ago
Message:
What script do you use to backup?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: indrajit chatterjee, India
Date: Aug 19, 2015, 00:02, 2845 days ago
Message: run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/${sid}/admin/adsmagent/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/${sid}/admin/adsmagent/tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/${sid}/admin/adsmagent/tdpo.opt)';
allocate channel t4 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/${sid}/admin/adsmagent/tdpo.opt)';
backup incremental level 0 cumulative database filesperset ${RMAN_FILES_PER_SET} format '${sid}.backup_database.level_0_%U';
backup current controlfile;
backup spfile;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: Michel Cadot, France
Date: Aug 19, 2015, 08:08, 2845 days ago
Message:
What is the bottleneck during your backup? CPU? IO? How many tape devices have you at the end?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: Dieter Henig, Switzerland
Date: Aug 21, 2015, 17:39, 2842 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi Indrajit,

when you say "since a couple of days", first I would like to ask, what has changed a couple of days before?

Anyway a good idea is to configure backup to disk (not to tape) and later copy the backup pieces to tape for further storage. 
ALLOCATE CHANNEL d1 DEVICE TYPE disk ...


Then you could switch on compression to reduce the traffic on the SAN/NFS-network. 
backup AS COMPRESSED BACKUPSET full database ...

What else you could do is to limit the backup-set size 
RMAN> CONFIGURE MAXSETSIZE TO 32 G;
(the size must be greater than your biggest datafile - somehow it is faster then).

hope this helps
b.r. Dieter
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: indrajit chatterjee, India
Date: Aug 21, 2015, 20:58, 2842 days ago
Message: Thanks Dieter and Michele,
We are suspecting the CPU overhead for the cause of this slowness. I have one last question that might be silly. IS there any mechanism to make a running rman backup fast ? Like increasing the Large Pool ? Please help to understand
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: Michel Cadot, France
Date: Aug 21, 2015, 21:34, 2842 days ago
Message:
The way depends on what is your bottleneck.
So be sure.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Rman backup is running slow.
Author: Thameera Nawaratna, Thailand
Date: Aug 24, 2015, 07:24, 2840 days ago
Message: Hi,

I'm not sure what kind of Tape drive you have. But once we had the same issue and it was hardware issue. Please check the Tape drive and Tapes.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here