UNSOLVED

rmbraga

updated

12 years ago

R

rmbraga

3 Posts

0

2252

April 9th, 2014 12:00

Rman channel allocation very slow with NMDA

Hello there!

I'm moving from NMO to NMDA and have been facing performance issues while allocating tape channels with RMAN.

Basically, my archive backup script is like this:

run {

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=servername,NSR_DATA_VOLUME_POOL=poolname,NSR_SAVESET_EXPIRATION=expiration)';

allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=servername,NSR_DATA_VOLUME_POOL=poolname,NSR_SAVESET_EXPIRATION=expiration)';

allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=servername,NSR_DATA_VOLUME_POOL=poolname,NSR_SAVESET_EXPIRATION=expiration)';

allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=servername,NSR_DATA_VOLUME_POOL=poolname,NSR_SAVESET_EXPIRATION=expiration)';

# switch logfile before backing up archive logs

sql 'alter system archive log current';

# backup of all archive logs delete afterwards

backup filesperset 20

format 'LOG_%U'

(archivelog all delete input);

}

It is taking 10 minutes, only to allocate these 4 tape channels.

The same script, running with NMO allocate the same 4 channles in seconds !!!

I'm running Oracle Enterprise Edition 11.2.0.4 on a RHEL 6.4 64 bits

Have you seen this kind of problem before?

See ya,

Rafa