Message-Id: <10520.107881@fatcity.com> From: "Boivin, Patrice J" Date: Tue, 06 Jun 2000 11:30:49 -0300 Subject: RE: Missing archive file, recovery is asking for it Linda, can you restore those old archived logs from tape or storage? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO E-Mail: boivinp@mar.dfo-mpo.gc.ca =20 -----Original Message----- From: Linda Hagedorn [SMTP:Linda@pets.com] Sent: Tuesday, June 06, 2000 11:27 AM To: Multiple recipients of list ORACLE-L Subject: Missing archive file, recovery is asking for it Hello,=20 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. =20 Here are the messages, and the list of archives:=20 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'=20 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: {=3Dsuggested | 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$ --=20 Author: Linda Hagedorn INET: Linda@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@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