Database Software

Hi All,

This is my first thread.

I am junior Oracle DBA and recently I was told to do a RMAN restoration from a set of backup files which consists 1CT & 5DF files. This back up was taken at some other region.

I created a database to restore the files, I used the command:

rman target /

RMAN> restore control file from '/temp/bkp/ct_784333_p2'

Starting restoring at 22-NOV-11
using channel ORA_DISK_1

RMAN-00571:
RMAN-00569: ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
RMAN-03002: failure of restore command at 11/22/2011 16:10:51
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

Can anyone pls tell me how to solve this issue..

I even tried by creating a pwdfile and pfile from a plain database and edited the pfile. Executed the same command and got the same error.

Then by searching in forums and googling I came to know that I must have at least one physical file that is controlfile to restore.
But unfortunately I don't have one. So kinldy pls tel me anyother way to restore this..

This is quite urgent..

Thanks in advance