Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> RMAN Backiup
Rekha Anupati
post Aug 8 2012, 11:43 AM
Post #1


Advanced Member
***

Group: Members
Posts: 130
Joined: 19-April 12
From: california
Member No.: 47,104



on our 10.2.0.5 database, when we run full backup, my system performance comes to an halt. we run full backup and then do a validate backup to validate the structure of the database etc. Database performance takes a hit and all of the application connections goes in wait mode: On ASH or AWR - this is the top wait i see:

RMAN backup & recovery I/O

Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
RMAN backup & recovery I/O 22.22 "1","32","2147483647" 21.79 count intr timeout

what can we do to over come this issue? any work arounds?
Go to the top of the page
 
+Quote Post
burleson
post Aug 8 2012, 12:33 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,729
Joined: 26-January 04
Member No.: 13



Hi

>> when we run full backup, my system performance comes to an halt

First, this is normal, as RMAN does full-table scans against all of the tables, depending on the backup type.

Also, this MUST be a hot backup, since the database is running.

Have you considered trying incremental backups?

Please read:

http://www.dba-oracle.com/t_incr_different...ive_backups.htm


*********************************************

>> RMAN backup & recovery I/O

Your disk channels are saturated!

The ONLY way to fix this issue is to improve the speed of the I/O subsystem (i.e. more disks or faster disks), or do the backups during scheduled downtime, or do incremental backups . . . .

Another solution is to move to SSD:

http://www.dba-oracle.com/oracle_tips_SSD.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Rekha Anupati
post Aug 9 2012, 11:22 AM
Post #3


Advanced Member
***

Group: Members
Posts: 130
Joined: 19-April 12
From: california
Member No.: 47,104



thank you so much for the detailed answers with references. i will surely look into the SSD direction and put an recommendation to our group director.
Go to the top of the page
 
+Quote Post
burleson
post Aug 10 2012, 11:09 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,729
Joined: 26-January 04
Member No.: 13



Hi Rekha,

>> i will surely look into the SSD direction and put an recommendation to our group director.

Not all SSD is the same, you need RACK-MOUNTED SSD . . .

See this, a market review of SSD:


http://dba-oracle.com/include_ssd.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 27th November 2014 - 12:02 PM