Troubleshooting RMAN Duplicate Database issues

Issue 1 : Failed to load Media Management Library

RMAN-03009: failure of allocate command on ch1 channel at 10/25/2011 12:48:18

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2

·         Check whether Media library agent is installed on server.

·         After Installation of Media Manager, if RMAN Channel Allocation Fails

Check in the trace file and sbio file if any error it generated (check USER_DUMP_DEST location)

If there is not much information, check if the issue is related to Media Mgmt library is not getting picked correctly. While allocating Channel force to use Media management library using parameter SBT_LIBRARY

Please use below commands to test (note : replace the env details)

Eg:

run

{

 ALLOCATE AUXILIARY CHANNEL ch2 DEVICE TYPE sbt parms='SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prddb,NSR_DATA_VOLUME_POOL=Weekly)';

}

            Using this command if it is able to connect to Tape , then change the rman script to reflect the SBT_LIBRARY parameter

Issue 2 :  ora-01103 database name <> in control file is not <>

This is due to previous RMAN duplicate must have errored out or set the DB_name as Production.

(This is a known bug in 11g)

Please check the spfile/pfile whether db_name is set correctly.

Issue 3 : Debug RMAN commands

Rman target  <>      Auxilary   <> log=rmanLog.txt trace=rmanTrace.txt

run {

 debug on;

 ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE sbt parms 'SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prderpdb,NSR_DATA_VOLUME_POOL=ADFCA Weekly)';

 ALLOCATE AUXILIARY CHANNEL ch2 DEVICE TYPE sbt parms 'SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prderpdb,NSR_DATA_VOLUME_POOL=ADFCA Weekly)';

 duplicate target database to ERPUAT  UNTIL TIME 'SYSDATE-1' ;

 debug off;

 }

Please check the trace and log file for error info.

refer notes:

http://download.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmtroub.htm

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1006474