Home » RDBMS Server » Backup & Recovery » RMAN Parallel Recovery (Oracle 9.0.2.0.0 Windows Server 2003)
RMAN Parallel Recovery [message #288326] Mon, 17 December 2007 01:50 Go to next message
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
Re: RMAN Parallel Recovery [message #288329 is a reply to message #288326] Mon, 17 December 2007 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN Parallel Recovery [message #288336 is a reply to message #288326] Mon, 17 December 2007 02:21 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
ok i understand
and many thanx for ur prompt response

So Both of my scripts will do the same ?????

Regards,
M.Shakeel Azeem
Re: RMAN Parallel Recovery [message #288339 is a reply to message #288336] Mon, 17 December 2007 02:31 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, if there are 4 available channels.

Regards
Michel
Previous Topic: rman backup cannot restore
Next Topic: RMAN error question from a newbie
Goto Forum:
  


Current Time: Sun Dec 04 04:23:55 CST 2016

Total time taken to generate the page: 0.24867 seconds