Printable View
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
it show an error which is mentioned earlierCode:recover database using backup controlfile
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