|
|
| Re: oracle not available [message #294415 is a reply to message #294408] |
Thu, 17 January 2008 09:16   |
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
|
Member |
|
|
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 |
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 |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
