RMAN Backiup Options

[Rekha Anupati]

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?

[burleson]

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

[Rekha Anupati]

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.

[burleson]

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