-
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