Home » Server Options » Data Guard » recovery parameters confusion
recovery parameters confusion [message #256517] Sun, 05 August 2007 08:33 Go to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
Hi.....
we have a physical standby database on our site....every time when standby db is up it is trying to start recovery with (no of datafiles)*2 processes...but as parallel max servers is the ultimate parallel threshold it is taking that many no of processes for parallel recovery....
My doubt is what does recover_parallelism parameter is doing then...n wat about parallel_threadspercpu....please help me....
Re: recovery parameters confusion [message #256521 is a reply to message #256517] Sun, 05 August 2007 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just a question: why you database is not ALWAYS started and in recovery mode?

Regards
Michel
Re: recovery parameters confusion [message #257034 is a reply to message #256521] Tue, 07 August 2007 07:40 Go to previous messageGo to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
Of course every time recovery is continuous...so finally as i said it is using PARALLEL_MAX_SERVERS no of recovery processes...in those processes exactly how many are used for read n how many r used for apply to blocks.....if it uses recovery_parallelism no of processes for apply to data blocks,how i can get optimum value for that parameter..ultimately when log shipping is fine,i want to increase recovery speed....
if i heave parallel_max_servers=64,recovery_parallelism=30 for a 32 CPU how can i speed up log applying further....pls help me....
Re: recovery parameters confusion [message #257053 is a reply to message #257034] Tue, 07 August 2007 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovery is more a matter of disk accesses than CPU.
Do you have 32 or 64 distinct disks to where you recover?

Regards
Michel
Re: recovery parameters confusion [message #257185 is a reply to message #257053] Tue, 07 August 2007 13:07 Go to previous message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
we are using SAN...so all the files n blocks sre scattered across various LDEVS and so various Disks..
Previous Topic: A question of Operating Systems
Next Topic: how to force FAL
Goto Forum:
  


Current Time: Fri Mar 29 06:51:18 CDT 2024