No question at this time
DBA Top 10
1 M. Cadot 5800
2 B. Vroman 3800
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 800
6 D. Johnson 700
7 T. Boles 600
8 D. Walgude 400
9 J. Alcroft 200
9 S. Spb 200
9 P. Wisse 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48667
Total active users1334
Act. users last 24h0
Act. users last hour0
Registered user hits last week21
Registered user hits last month202
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, 2469 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, 2469 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, 2469 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, 2469 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, 2466 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, 2466 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, 2466 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, 2464 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