Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: missing datafile

Re: missing datafile

From: Neil Greene <ngreene_at_laoc.SHL.com>
Date: 1997/07/27
Message-ID: <MPG.e44a40e867a71079896a9@news.internetmci.com>#1/1

[This followup was posted to comp.databases.oracle.server and a copy was sent to the cited author.]

In article <33DAC4C6.41A4_at_cs.umbc.edu>, sli1_at_cs.umbc.edu says...
> Hi,
> While trying to put "USERS" tablespace back online, I received the
> following error messages:
>
> ORA-01157: cannot identify data file 8 - file not found
> ORA-01110: data file 8: '/u01/oradata/csee/users04.dbf'
>
> I then check if /u01/oradata/csee/users04.dbf exists or not by looking
> into the directory /u01/oradata/csee/ and can't find file 'users04.dbf'
> either. It is greatly appreciated if anyone kindly suggests how to fix
> this problem.

If running in archive log mode, restore a backup copy of your users tablespace and apply your archive logs. If not running in archive log mode, then restore the entire database back to a previous copy.

//neil

-- 
Neil Greene			Senior System Engineer / Oracle DBA	
MCI Systemhouse, Inc. 		

Email:	<mailto:ngreene_at_laoc.SHL.com>	Work: 	714-522-9096		
Pager Email:	4112636_at_PageMCI.com		Pager:	800-411-2636


-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGP for Personal Privacy 5.0

mQGiBDPWHBYRBADARuLlZYHQLIL0Qm0qYbHK7y3yKO8urQ2cb6yfCEvX3rjh5lqC
PTGR5+abkJzYspnd0i7ksZWqt7i472GCwdTFl7B41Kr8g6C5UeD4Z4EtUubJuNXw
vl+pw2WLcvaqfPKnOcTxfqN8BVNRdzbtvmNs1o32sSuejoilzoL0LxZ/+QCg/3Du
ywincqFGokI89cycUDaz4FsD+wQ2o2FBVQHnUGkIyhxuH9fUjzD3rLbjZVy2HTLi
Y0gPM6diMMvHk0SK9DapKkXN5lj/eSHPy838qQ+7gLjHeKso9W1Z24LFgQuSMHE1
sSzDP3/gN+OwwXUvMFk+BnmjGZDolxaiC9X2AQEVLDRSZlZUaOl4Ew9Xj4MF/CS+
zQmxA/0e5d/BEZGvNR5BVwcc4Lq4nXbpV5isBYcHD9fe/TIRh2+nMqsoIWLag3S0
gVQcwT7/AQPJ8ZHqZtp3QCLb9pHO08O6cCh5EG91Djs04L9q3J/54jKCL8uLG/Er
tqaKKGlz8I1RRqEZfimdCzju5tpn+n1J+TP35dmjvnx90zhrybQiTmVpbCBHcmVl
bmUgPG5ncmVlbmVAbGFvYy5TSEwuY29tPokASwQQEQIACwUCM9YcFgQLAwECAAoJ
EA06NGvZhzY8xNkAn1rsngQyrgRp5qMJ7kbbnND0VIw6AJ4sFiDO7RGdEcbglCbY
E9PHCDiIc7kCDQQz1hwXEAgA9kJXtwh/CBdyorrWqULzBej5UxE5T7bxbrlLOCDa
AadWoxTpj0BV89AHxstDqZSt90xkhkn4DIO9ZekX1KHTUPj1WV/cdlJPPT2N286Z
4VeSWc39uK50T8X8dryDxUcwYc58yWb/Ffm7/ZFexwGq01uejaClcjrUGvC/RgBY
K+X0iP1YTknbzSC0neSRBzZrM2w4DUUdD3yIsxx8Wy2O9vPJI8BD8KVbGI2Ou1WM
uF040zT9fBdXQ6MdGGzeMyEstSr/POGxKUAYEY18hKcKctaGxAMZyAcpesqVDNmW
n6vQClCbAkbTCD1mpF1Bn5x8vYlLIhkmuquiXsNV6TILOwACAgf/cA5Da93sz9BF
jWXp7QMVcQzOkQlHKV0AIBNQvNPgZxvVPknh21N2qSEkdkbgfjZpxplNsLlOGh3F
CZ3s9tHgUUJPkGRm0wAldN7SqCN0VWTLThnw7r9Jcze6WSdepSwoggADaPE+4cqg
o1REViiGpHjo+CMjAK3S6713X2e1FZll50LYiTn4nCtAdcyPgseqkqipm3wS4w9w
RqAUx1IFCRm/X5TBLK1ZlZ57UoCr2E1NL9r+viFwVjglbcJS2LSiCDu0fUhrL63R
hY/HWACHTYalQzNddhuNZYQ0CBlpY8HxQ3VgMKVTETw/nhBEx+5nc85Et9xk/V0G
KsY09fkCI4kAPwMFGDPWHBcNOjRr2Yc2PBECa8oAoN6EUjvHJzdYYzXUqWo7n4Yi
zeQHAKDiz0rMyO0uhvmekbN67vygKDyGLQ==
=s/sM
-----END PGP PUBLIC KEY BLOCK-----
Received on Sun Jul 27 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US