Home » RDBMS Server » Backup & Recovery » database is mounted suddenly cannot open it
database is mounted suddenly cannot open it [message #194856] Mon, 25 September 2006 14:12 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii all

I have a big problem in my database
it was working fine and now i tried to connect to the database using sql

ORA-01033: ORACLE INTILIZIATION OR SHUTDOWN IN PRORESS


I opened Oracle enterprize manager Console

i connected well with no problem
and in the INSTANCE/CONFIGURATION
i found my database is mounted
when i tried to open it it gives me that error

ORA-00368 : checksum error in redo log block
ORA-00353: log corruption near block 9958 change time 09/25/2006
10:02:56 1289354
:ORA-00312 online log 2 thread 1 : 'D'ORACLE\ORADATA\WATER\REDO02.LOG\


Thanks for Everyone Helped and Helping me
Re: database is mounted suddenly cannot open it [message #194858 is a reply to message #194856] Mon, 25 September 2006 14:19 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See actions below:

00353, 00000, "log corruption near block %s change %s time %s"
// *Cause:  Some type of redo log corruption has been discovered. This error
//          describes the location of the corruption. Accompanying errors
//          describe the type of corruption.
// *Action: Do recovery with a good version of the log or do incomplete
//          recovery up to the indicated change or time.
Re: database is mounted suddenly cannot open it [message #194859 is a reply to message #194856] Mon, 25 September 2006 14:28 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Thanks first for your Reply

how can i do a recovery i selected tools/database tools/backup mangement/Recovery

and it gives me that message
this application can only be launched when the applications is (connected to oracle manegment server (OMS
launch the application and connect to the OMS before trying to launch the wizard again

[Updated on: Mon, 25 September 2006 14:29]

Report message to a moderator

Re: database is mounted suddenly cannot open it [message #196359 is a reply to message #194859] Thu, 05 October 2006 02:13 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Go Through below link
http://www.dbforums.com/showthread.php?t=984559
Previous Topic: my database do not open
Next Topic: problem in jobs
Goto Forum:
  


Current Time: Wed Dec 07 08:45:12 CST 2016

Total time taken to generate the page: 0.05355 seconds