Hi,
I am getting following erorr during backup/recovery from my prod DB to test DB.
I tried to run again with recover command but it's the same problem.
I also shutdown the DB and try again but no luck.
I have build the control file from trace file.
Errors
--------
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 492813519 generated at 10/18/2007 18:22:32 needed for thread
1
ORA-00289: suggestion :
/u01/app/oracle/product/9.2.0/admin/tst/arch/_0000000001.arc
ORA-00280: change 492813519 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/u01/app/oracle/product/9.2.0/admin/tst/arch/_0000000001.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u03/oradata/tst/system01.dbf'

I also followed following steps.
[1] Recover DATABASE
recover DATABASE until cancel USING backup controlfile;
[2] Cancel the recovery
CANCEL 
[3] Open WITH resetlogs
ALTER DATABASE open resetlogs;-- Should get ORA-01195
[4] Stop db.
shutdown;
[5]Now ADD this TO init file
_allow_resetlogs_corruption = true
_allow_read_only_corruption = true
[6] 
startup mount
[7] Do resetlogs again ALTER DATABASE open resetlogs;

then got the following error:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel