Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
Re: Missing archive file, recovery is asking for it
Re: Missing archive file, recovery is asking for it
Hi Linda,
What's in that archive.tar file?
- Linda Hagedorn <Linda_at_pets.com> wrote:
> 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
> loaddb1:/opt/oracle/app/oracle/oradata/PETS/archive$
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Received on Tue Jun 06 2000 - 09:49:35 CDT
Original text of this message