-
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
"Every morning I check Forbes 40 richest Indians
list , if i'm not there I go to work."
-
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
"Every morning I check Forbes 40 richest Indians
list , if i'm not there I go to work."
-
are you perhaps trying to apply archivelogs of database "A" which is in archivelog mode on database "B" which is in nonarchivelog mode?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
database B is just the cold database and im trying to apply the archives of A to B.
"Every morning I check Forbes 40 richest Indians
list , if i'm not there I go to work."
-
well the files dont exist and what is a 'cold' database as far as you know it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|