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

From: Boivin, Patrice J <>
Date: Tue, 06 Jun 2000 11:30:49 -0300
Message-Id: <>

Linda, can you restore those old archived logs from tape or storage?

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: <>=20

	-----Original Message-----
	From:	Linda Hagedorn []
	Sent:	Tuesday, June 06, 2000 11:27 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Missing archive file, recovery is asking for it


	What do I do when the archive file Oracle is asking for is missing?
	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:
	SVRMGR> exit
	Oracle Server Manager Release - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release - Production PL/SQL Release - 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>=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: 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: (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
Received on Tue Jun 06 2000 - 09:30:49 CDT

Original text of this message