Home » RDBMS Server » Backup & Recovery » oracle not available
oracle not available [message #294408] Thu, 17 January 2008 08:34 Go to next message
tomukaz
Messages: 16
Registered: December 2007
Junior Member
windows 2000
http://www.fenixoid.projektas.lt/oracle.jpg

any ideas howto make this working?
Re: oracle not available [message #294415 is a reply to message #294408] Thu, 17 January 2008 09:16 Go to previous messageGo to next message
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 #294427 is a reply to message #294408] Thu, 17 January 2008 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But I think we need more information from you.

For instance, if you have the current control file or if the database is in NOARCHIVELOG mode or ...

Regards
Michel
Re: oracle not available [message #294558 is a reply to message #294415] Fri, 18 January 2008 00:24 Go to previous messageGo to next message
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 messageGo to next message
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 #294576 is a reply to message #294565] Fri, 18 January 2008 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Export files are not backup ones, you can't restore or recover a database with them.

Regards
Michel
Re: oracle not available [message #294583 is a reply to message #294576] Fri, 18 January 2008 01:21 Go to previous messageGo to next message
tomukaz
Messages: 16
Registered: December 2007
Junior Member
So is there a way to recover this database somehow? Maby to install evething from new and import tables?
Re: oracle not available [message #294589 is a reply to message #294583] Fri, 18 January 2008 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can do this and lose all modifications made since the export.

Regards
Michel
Re: oracle not available [message #294603 is a reply to message #294589] Fri, 18 January 2008 02:59 Go to previous messageGo to next message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

Hi:

Check your logical export dmp file first to make sure it's available for recovery.



Fangxin.Lou
Re: oracle not available [message #294608 is a reply to message #294603] Fri, 18 January 2008 03:12 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Error in creating backup set.
Next Topic: how to reconfigure rman configuration parameters
Goto Forum:
  


Current Time: Sat Dec 03 09:49:16 CST 2016

Total time taken to generate the page: 0.12430 seconds