OraFAQ Forum: Backup & Recovery » open problem after recover

Home » RDBMS Server » Backup & Recovery » open problem after recover (Oracle 9i version 9.2.0.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

open problem after recover [message #324758]

Tue, 03 June 2008 23:29

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

Report message to a moderator

Re: open problem after recover [message #324761 is a reply to message #324758]

Tue, 03 June 2008 23:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I open database . Pls help me
You should follow your documented & tested recovery procedure.

Report message to a moderator

Re: open problem after recover [message #324764 is a reply to message #324761]

Tue, 03 June 2008 23:43

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

Report message to a moderator

Re: open problem after recover [message #324766 is a reply to message #324758]

Tue, 03 June 2008 23:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Why do you not have backups & tested recovery procedures?

Report message to a moderator

Re: open problem after recover [message #324774 is a reply to message #324764]

Wed, 04 June 2008 00:05

Michel Cadot
Messages: 68650
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 03:33:55 CDT 2024