OraFAQ Forum: Backup & Recovery » Oracle cannot open database

Home » RDBMS Server » Backup & Recovery » Oracle cannot open database (Oracle Database 18c Express Edition Release 18.0.0.0.0)

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

Oracle cannot open database [message #686983]

Fri, 10 February 2023 05:17

ladyoracle
Messages: 1
Registered: February 2023

Junior Member

Hi all. I've faced with a problem: database is mounted but not opened.

SQL> startup
ORACLE instance started.

Total System Global Area 1610609384 bytes
Fixed Size 9028328 bytes
Variable Size 520093696 bytes
Database Buffers 1073741824 bytes
Redo Buffers 7745536 bytes
Database mounted.
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 80265 change 86824650 time 02/08/2023
17:02:08
ORA-00312: online log 1 thread 1:
'C:\APP\USER\PRODUCT\18.0.0\ORADATA\XE\REDO01.LOG'

What should I do in that case? Thanks.

Report message to a moderator

Re: Oracle cannot open database [message #686988 is a reply to message #686983]

Fri, 10 February 2023 10:11

John Watson
Messages: 8869
Registered: January 2010
Location: Global Village

Senior Member

Moderator comment:

From your IP address, it appears as though you may be in a country where US Export Regulations currently make use of Oracle products illegal. That is of course nothing to do with this bulletin board, but is a factor that some people may want to consider when replying.

Report message to a moderator

Re: Oracle cannot open database [message #686990 is a reply to message #686983]

Sat, 11 February 2023 10:53

Michel Cadot
Messages: 68500
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00355: change numbers out of order
 *Cause:  A change number found in the redo log is lower than a previously
          encountered change number. The log is corrupted in some way. The
          corruption may be at the earlier change or at this one.
 *Action: Do recovery with a good version of the log or do time based
          recovery up to the indicated time.

Report message to a moderator

Previous Topic:	ora-12203 TNS unable to connect
Next Topic:	Oracle RMAN Backup API

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 16:02:05 CDT 2023