Home » RDBMS Server » Backup & Recovery » open problem after recover (Oracle 9i version 9.2.0.0)
open problem after recover [message #324758] Tue, 03 June 2008 23:29 Go to next message
Jahid
Messages: 2
Registered: June 2008
Location: Dhaka
Junior Member
our windows crash, so I format c: drive then install windows then I take only DBF file.

I create new instance then i create controlfile as nomount state
then I try to alter database open resetlogs

then show following messeage:
ora-01194 file 1 needs more recovery to be consistent

How can I open database . Pls help me


Jahid
Re: open problem after recover [message #324761 is a reply to message #324758] Tue, 03 June 2008 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How can I open database . Pls help me
You should follow your documented & tested recovery procedure.

Re: open problem after recover [message #324764 is a reply to message #324761] Tue, 03 June 2008 23:43 Go to previous messageGo to next message
Jahid
Messages: 2
Registered: June 2008
Location: Dhaka
Junior Member
Actually i can't understand.
I want this state open only, if i have lost some data no problem.


Jahid
Re: open problem after recover [message #324766 is a reply to message #324758] Tue, 03 June 2008 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Why do you not have backups & tested recovery procedures?
Re: open problem after recover [message #324774 is a reply to message #324764] Wed, 04 June 2008 00:05 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want this state open only, if i have lost some data no problem.

In this case, just recreate a new database.

Regards
Michel
Previous Topic: Reg Cold and Hot backup
Next Topic: ORA-19504: failed to create file "+MY_DG2"
Goto Forum:
  


Current Time: Sat Dec 10 12:50:07 CST 2016

Total time taken to generate the page: 0.08971 seconds