Home » SQL & PL/SQL » Client Tools » Oracle instance Shutdown (Oracle 11G windows server 2016)
Oracle instance Shutdown [message #684484] Mon, 14 June 2021 01:13 Go to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
Hi All,
I have a database and user on same name unfortunately with power fluctuation Server shut downs abnormally now server starts normal but DB is not working. Oracle is connecting with sysdba user but not with ordinaty user and its schema it gives a message database is shutting down.. kindly guide me to resolve the issue..

Regards,
Re: Oracle instance Shutdown [message #684486 is a reply to message #684484] Mon, 14 June 2021 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68006
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Check the Oracle service is on
2a/ If not then start it
2b/ If started, connect, with SQL*Plus, as sysdba and execute "startup", post the result of the command

Don't forget to format your post as explained in "How to use [code] tags and make your code easier to read".

Re: Oracle instance Shutdown [message #684487 is a reply to message #684486] Mon, 14 June 2021 02:36 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
Ora-00333 redo log read error block 792 count 7403
Re: Oracle instance Shutdown [message #684488 is a reply to message #684487] Mon, 14 June 2021 02:43 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
I have a latest backup of that userand its schema if i restore it will the problem be resolved?
Re: Oracle instance Shutdown [message #684489 is a reply to message #684488] Mon, 14 June 2021 03:46 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
I restored backup still gives the same error
Re: Oracle instance Shutdown [message #684493 is a reply to message #684489] Mon, 14 June 2021 11:52 Go to previous message
Qas313
Messages: 9
Registered: May 2021
Junior Member
Thanx to all... i have recovered my database by my self. Alhamdo lillah
Previous Topic: Backup using toad
Next Topic: Automate sql executions
Goto Forum:
  


Current Time: Mon Oct 25 20:19:45 CDT 2021