Anand
asked on
Database block corruption -
could not able to recover database block , which is having corruption type is NOLOGGING
In MariaDB/MySQL, typical way to resolve this...
mysqlcheck --defaults-extra-file=/etc /mysql/deb ian.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.
mysqlcheck --defaults-extra-file=/etc
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.
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...
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 TRIALMembers 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.
if your lucky it's just an index block
Open in new window