Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: missing datafile
[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