Database Software

Hi All,

My Oracle database is 11G R2 and version is 11.2.0.2.0..!and OS is RHEL 5.

My Database Size is 13TB.

We are trying to restore full DB backup to test server from via Tape by using RMAN for testing purpose whether backup team is taking perfectly or not .but Getting below error while restoring the SPFILE and CONTROLFILE..Please tell that whether problem is from Oracle server side or backup server side.and please tell me the solution for the issue.

******************************Error Start*****************************************

channel c1: no AUTOBACKUP in 7 days found
channel c2: no AUTOBACKUP in 7 days found
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/06/2013 10:57:24
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

*****************************Error end********************************************

Followed the below scripts to restore controlfile and spfile..


Script for Spfile restoration:-
**********************
run
{
allocate channel c1 type SBT_TAPE;
allocate channel c2 type SBT_TAPE;
SEND 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom)';
restore spfile to '/tmp/spfile_restored.ora' from '/NM0_MDA_c-1022799756-20130303-00/';
release channel c1;
release channel c2;
}



Script for Controlfile Restoration:-
**************************
run
{
allocate channel c1 type SBT_TAPE;
allocate channel c2 type SBT_TAPE;
SEND 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom)';
restore controlfile to '/tmp/controlfile.ora' from '/NM0_MDA_c-1022799756-20130303-00/';
release channel c1;
release channel c2;
}


Thanks in Advance :-)


Thanks & Regards
Prasanth