Hi ,

Thanks for the advice. I have use the until SCN parameter to restore my database from tape. But when i tried to

"recover database using backup controlfile until cancel"

it suggest the archive log which i have, and thus applied it.
I tried to issue a CANCEL for the next prompt, but messages says that my system_01.dbf file needs to be more consistent.

The conflict is tat the next archived log message says that the archive log is no longer needed. This could be due to my command at rman

RMAN > restore database until SCN 10000;

How can i proceed to recover my database?

I am really stuck with this for 2 days.