Home » RDBMS Server » Backup & Recovery » rman 'restore validate database' parallelism (Oracle DB, 10.2, RHEL4)
rman 'restore validate database' parallelism [message #376833] Thu, 18 December 2008 15:06 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
I'm testing out methods of efficiently validating our backups:
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
restore validate database;
}


The host that's executing the above has 4 dual core processors. Is a general rule of thumb to limit parallel operations at max processors-1? In this case, 7 would be the highest number of channels I could allocate?

I was initially executing the validate with a single channel before I began to investigate the potential performance enhancements of multiple channels. I'm searching for the appropriate setting for my purposes.

Thanks.
Re: rman 'restore validate database' parallelism [message #376834 is a reply to message #376833] Thu, 18 December 2008 16:04 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Generally, the number of channels that you allocate should match the number of physical devices accessed in the backup.
Previous Topic: Update statistics
Next Topic: BACKUP FROM DAILY INCREMENTAL COPY WITH FULL WEEKLY BACKUP
Goto Forum:
  


Current Time: Mon Apr 29 20:26:16 CDT 2024