Home » RDBMS Server » Backup & Recovery » Oracle cannot open database (Oracle Database 18c Express Edition Release 18.0.0.0.0)
Oracle cannot open database [message #686983] Fri, 10 February 2023 05:17 Go to next message
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.
Re: Oracle cannot open database [message #686988 is a reply to message #686983] Fri, 10 February 2023 10:11 Go to previous messageGo to next message
John Watson
Messages: 8922
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.



Re: Oracle cannot open database [message #686990 is a reply to message #686983] Sat, 11 February 2023 10:53 Go to previous message
Michel Cadot
Messages: 68625
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.
Previous Topic: ora-12203 TNS unable to connect
Next Topic: Oracle RMAN Backup API
Goto Forum:
  


Current Time: Thu Mar 28 20:05:02 CDT 2024