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_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Linda Hagedorn [SMTP:Linda_at_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: {<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: 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