|
Re: oracle not available [message #294415 is a reply to message #294408] |
Thu, 17 January 2008 09:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
d.c.b.a
Messages: 44 Registered: March 2005 Location: China
|
Member |
![loufangxin](/forum/theme/orafaq/images/yahoo.png)
|
|
1, Did you do a database restore?
2, Does this file contains any important data?
You can try to type a "recover database" command, and then run "alter database open". But I think we need more information from you.
Fangxin.Lou, from China
[Edit MC: Ads must only be posted in Marketplace forum]
[Updated on: Thu, 17 January 2008 10:01] by Moderator Report message to a moderator
|
|
|
|
Re: oracle not available [message #294558 is a reply to message #294415] |
Fri, 18 January 2008 00:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tomukaz
Messages: 16 Registered: December 2007
|
Junior Member |
|
|
d.c.b.a wrote on Thu, 17 January 2008 09:16 | 1, Did you do a database restore?
2, Does this file contains any important data?
You can try to type a "recover database" command, and then run "alter database open". But I think we need more information from you.
Fangxin.Lou, from China
[Edit MC: Ads must only be posted in Marketplace forum]
|
1. yep, ir tais oracle not available
2. yeap. This happened on power-lost.
recover database didin't help, it says oracle not available.
|
|
|
Re: oracle not available [message #294565 is a reply to message #294408] |
Fri, 18 January 2008 00:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tomukaz
Messages: 16 Registered: December 2007
|
Junior Member |
|
|
Hm, found something interesting. Every night the was export of all tables. Files are colled exp.dmp and exp1.dmp. maby it's possible to recover stuff from them?
|
|
|
|
|
|
|
Re: oracle not available [message #294608 is a reply to message #294603] |
Fri, 18 January 2008 03:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
[QUOTE]Check your logical export dmp file first to make sure it's available for recovery./QUOTE]
It is NOT a recovery, it is an import.
Regards
Michel
|
|
|