OraFAQ Forum: Backup & Recovery » RMAN Parallel Recovery

Home » RDBMS Server » Backup & Recovery » RMAN Parallel Recovery (Oracle 9.0.2.0.0 Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Parallel Recovery [message #288326]

Mon, 17 December 2007 01:50

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear All,

i had a oracle db server with 4-cpu's and now i want to recover the db in parallel

RMAN>run{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
recover database;
}

RMAN>recover database parallel (degree 4);

Are both of these scripts will do the same ?
or
is there any difference betwen these scripts ?

and what is the role of the initialization parameter RECOVERY_PARALLELISM in media recovery?

Regards,
M.Shakeel Azeem

Report message to a moderator

Re: RMAN Parallel Recovery [message #288329 is a reply to message #288326]

Mon, 17 December 2007 02:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you don't give neither PARALLEL nor NOPARALLEL clause and don't have a configuation parameter that set it then RMAN do it in parallel using all allocated channels.
If you give the degree of parallelism then RMAN limits it to the degree you gave.

From doc:

Quote:

RECOVERY_PARALLELISM specifies the number of processes to participate in instance or crash recovery. A value of 0 or 1 indicates that recovery is to be performed serially by one process.

No relation with media recovery.

Regards
Michel

Report message to a moderator