Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Missing archive file, recovery is asking for it

Missing archive file, recovery is asking for it

From: Linda Hagedorn <Linda_at_pets.com>
Date: Tue, 6 Jun 2000 06:21:00 -0700
Message-Id: <10520.107856@fatcity.com>


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.dbf
Received on Tue Jun 06 2000 - 08:21:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US