Home » RDBMS Server » Backup & Recovery » Database Recover (db 10g)
Database Recover [message #445279] Sat, 27 February 2010 23:03 Go to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Dear all,

I am using Oracle DB 10g R2. Now when i want to connect with this database ,i can not connect. The following message given.
" The database is either shutdown or open in progress" But the database does not open.

How to solve this problem . please help me. Very urgent.

Regards.

Mahmud

Report message to a moderator

Re: Database Recover [message #445280 is a reply to message #445279] Sat, 27 February 2010 23:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Post Operating System (OS) name & version for DB server system.

CUT lines below then PASTE into command/terminal window

sqlplus
/ as sysdba
shutdown abort
startup
exit


CUT commands and results then PASTE all back here

Report message to a moderator

Re: Database Recover [message #445283 is a reply to message #445280] Sat, 27 February 2010 23:35 Go to previous messageGo to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Database mount successfuly, but cannot open

Report message to a moderator

Re: Database Recover [message #445284 is a reply to message #445283] Sat, 27 February 2010 23:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You're On Your Own
since you can't or won't do as requested.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 27 February 2010 23:39]

Report message to a moderator

Re: Database Recover [message #445287 is a reply to message #445283] Sun, 28 February 2010 01:11 Go to previous message
Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
mahmud732 wrote on Sun, 28 February 2010 06:35
Database mount successfuly, but cannot open

Good, now make it open fixing the error you have.

Regards
Michel

Report message to a moderator

Previous Topic: Clone from ASM to non ASM.
Next Topic: RMAN Backup & Recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 07:00:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.