Avatar of Swaminathan K
Swaminathan KFlag for India

asked on 

Oracle 12c throws an redolog error on startup

Hi Team,

Iam getting the below error when i startup the database from sqlplus prompt
Any help is really appreciated.

SQL> startup
ORACLE instance started.

Total System Global Area 5133828096 bytes
Fixed Size                  4629144 bytes
Variable Size            1174408552 bytes
Database Buffers         3942645760 bytes
Redo Buffers               12144640 bytes
Database mounted.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 45150 change 1108101562370 time 08/04/2021
08:27:22
ORA-00312: online log 3 thread 1: 'D:\APP\ADMIN\ORADATA\ORCL\REDO03.LOG'





* Oracle12cOracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Swaminathan K

ASKER

Hi ,
Below is the output after querying for redo log files. The database is in mounted and not opened. Iam not able to open the database.

1      1      523      NO      INACTIVE      D:\APP\ADMIN\ORADATA\ORCL\REDO01.LOG      50
2      1      524      NO      INACTIVE      D:\APP\ADMIN\ORADATA\ORCL\REDO02.LOG      50
3      1      525      NO      CURRENT      D:\APP\ADMIN\ORADATA\ORCL\REDO03.LOG      50 -- Is the corrupted redo log file

Iam not able to switch the log files as the database is not  opened. The below command fails with the error

ALTER SYSTEM SWITCH LOGFILE;

Error starting at line 13 in command:
ALTER SYSTEM SWITCH LOGFILE
Error report:
SQL Error: ORA-01109: database not open
01109. 00000 -  "database not open"
*Cause:    A command was attempted that requires the database to be open.
*Action:   Open the database and try the command again

Iam trying to drop the redolog file and recreate the group. Any help is really appreciated.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>Iam trying to drop the redolog file and recreate the group.

There are examples all over the Internet.  What are you trying and what isn't working?
Avatar of Swaminathan K

ASKER

The issue is the redolog3 is the current log file. Hence i want to run the log switch to change the log.
But for that My DB needs to be opened. Iam not able to open the DB because of redolog file
Everything you just posted makes perfect sense.  You have a corrupt redo log.  You need to resolve that before you can open the database.

If this is an important database to you, I would contact Oracle Support.
Avatar of Swaminathan K

ASKER

Thanks a lot
So, what did you end up doing to get your database open?

Going from memory:
If you used "_allow_restlogs_corruption", you need to do a full export, recreate the database and import everything back in.  Otherwise, you're in an unsupported state.
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo