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