Linda,
How important the data is.. Is this prod database?
You can do is,,
startup mount;
recover database until cancel;
Apply all the logs till the missing log.
alter database open resetlogs;
This will not ask you for any more archive logs.
and it will open the database. However you will
lose all the transaction after the last applied
archive log.
- Rocky Welch <rockyw_99_at_yahoo.com> wrote:
> 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
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: Rocky Welch
> INET: rockyw_99_at_yahoo.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
Received on Tue Jun 06 2000 - 10:31:20 CDT