Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Missing archive file, recovery is asking for it
Hello,
What do I do when the archive file Oracle is asking for is missing? It's asking for 1_135046, and the earliest I have is 1_135057.
Here are the messages, and the list of archives:
SVRMGR> startup database PETS
MGR-00127: invalid combination of STARTUP options
SVRMGR> startup
ORACLE instance started.
Total System Global Area 784768528 bytes Fixed Size 48656 bytes Variable Size 129261568 bytes Database Buffers 655360000 bytes Redo Buffers 98304 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf'
SVRMGR> exit
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
SVRMGR> recover database
ORA-00279: change 433834283014 generated at 06/04/00 23:00:01 needed for
thread1
ORA-00289: suggestion :
/opt/oracle/app/oracle/oradata/PETS/archive/1_135046.dbf
ORA-00280: change 433834283014 for thread 1 is in sequence #135046
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/opt/oracle/app/oracle/oradata/PETS/archiv'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SVRMGR> exit
Server Manager complete.
loaddb1:/opt/oracle/app/oracle/oradata/PETS/archive$ ls
1_135057.dbf 1_135082.dbf 1_135107.dbf 1_135132.dbf 1_135157.dbf 1_135058.dbf 1_135083.dbf 1_135108.dbf 1_135133.dbf 1_135158.dbf 1_135059.dbf 1_135084.dbf 1_135109.dbf 1_135134.dbf 1_135159.dbf 1_135060.dbf 1_135085.dbf 1_135110.dbf 1_135135.dbf 1_135160.dbf 1_135061.dbf 1_135086.dbf 1_135111.dbf 1_135136.dbf 1_135161.dbf 1_135062.dbf 1_135087.dbf 1_135112.dbf 1_135137.dbf 1_135162.dbf 1_135063.dbf 1_135088.dbf 1_135113.dbf 1_135138.dbf 1_135163.dbf 1_135064.dbf 1_135089.dbf 1_135114.dbf 1_135139.dbf 1_135164.dbf 1_135065.dbf 1_135090.dbf 1_135115.dbf 1_135140.dbf 1_135165.dbf 1_135066.dbf 1_135091.dbf 1_135116.dbf 1_135141.dbf 1_135166.dbf 1_135067.dbf 1_135092.dbf 1_135117.dbf 1_135142.dbf 1_135167.dbf 1_135068.dbf 1_135093.dbf 1_135118.dbf 1_135143.dbf 1_135168.dbf 1_135069.dbf 1_135094.dbf 1_135119.dbf 1_135144.dbf 1_135169.dbf 1_135070.dbf 1_135095.dbf 1_135120.dbf 1_135145.dbf 1_135170.dbf 1_135071.dbf 1_135096.dbf 1_135121.dbf 1_135146.dbf 1_135171.dbf 1_135072.dbf 1_135097.dbf 1_135122.dbf 1_135147.dbf 1_135172.dbf 1_135073.dbf 1_135098.dbf 1_135123.dbf 1_135148.dbf 1_135173.dbf 1_135074.dbf 1_135099.dbf 1_135124.dbf 1_135149.dbf 1_135174.dbf 1_135075.dbf 1_135100.dbf 1_135125.dbf 1_135150.dbf 1_135175.dbf 1_135076.dbf 1_135101.dbf 1_135126.dbf 1_135151.dbf 1_135176.dbf 1_135077.dbf 1_135102.dbf 1_135127.dbf 1_135152.dbf archive.tar 1_135078.dbf 1_135103.dbf 1_135128.dbf 1_135153.dbf lost+found 1_135079.dbf 1_135104.dbf 1_135129.dbf 1_135154.dbf 1_135080.dbf 1_135105.dbf 1_135130.dbf 1_135155.dbf 1_135081.dbf 1_135106.dbf 1_135131.dbf 1_135156.dbfReceived on Tue Jun 06 2000 - 08:21:00 CDT