ora-27037

hi all
i trying to apply archive on cold database in 10g.
scenario is this:
i'm firing scp command on linux and copying all the archives from the hot database to cold one but after copying it whenever im
firing command on cold
like

Code:

---

recover database using backup controlfile

---

it show an error which is mentioned earlier

post the full output from the screen, not little bits which you have put in

recover database using backup controlfile;
ORA-00279: change 3389516449866 generated at 10/19/2007 22:11:04 needed for
thread 1
ORA-00289: suggestion :
/soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog/
2007_10_25/o1_mf_1_2776_%u_.arc
ORA-00280: change 3389516449866 for thread 1 is in sequence #2776


Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog
/2007_10_25/o1_mf_1_2776_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog
/2007_10_25/o1_mf_1_2776_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

are you perhaps trying to apply archivelogs of database "A" which is in archivelog mode on database "B" which is in nonarchivelog mode?

database B is just the cold database and im trying to apply the archives of A to B.

well the files dont exist and what is a 'cold' database as far as you know it