Monday, April 1, 2013

Recovering Parallel

Parallel media recovey : Roll forward can be parallelized by specifiying following command;

RECOVER PARALLEL {integer} , integer : degree of parallelism(default is number of cpu's)

In rac, Oracle distributes these parallel recovery processes accross the rac nodes automatically.  Usage Example : RECOVER DATABASE PARALLEL 4;

 Also , RECOVERY_PARALLELISM initialization parameter can be used to increase performance of Instance or Crash recovery..

Note that: Instance Recovery is initiated by SMON automatically at instance startup. Media Recovery is initiated by user.

No comments :

Post a Comment

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link:

Register and create an issue in the related category.
I will support you from there.