Link to home
Start Free TrialLog in
Avatar of Anand
AnandFlag for India

asked on

Database block corruption -

could not able to recover database block , which is having corruption type is NOLOGGING
Avatar of Geert G
Geert G
Flag of Belgium image

rebuilding the index is the first thing to try
if your lucky it's just an index block

alter index x rebuild tablespace y;

Open in new window

In MariaDB/MySQL, typical way to resolve this...

mysqlcheck --defaults-extra-file=/etc/mysql/debian.cnf --auto-repair -o --all-databases | egrep Error

Likely Oracle has a similar facility, which repairs records. Look at documentation for your version of Oracle or open a support ticket with Oracle.

If worse comes to worse, likely there's a way to rollback this table to a point prior to corruption too.

Best to open an Oracle support ticket, as they'll look at your specific version + provide direction from there.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Please provide even the basic information?

Oracle version (all 4 numbers).
What are you trying to do?  You mention recover but what type of recovery?
What data file has the corruption?
etc...
Please provide more details, Oracle error and scenario
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.