Skip to Main Content
  • Questions
  • What is the proper way to clear active/current corrupted redo log group

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, jessy.

Asked: November 10, 2021 - 3:23 pm UTC

Last updated: November 16, 2021 - 7:01 am UTC

Version: 19.3.0.0.0

Viewed 100+ times

You Asked

Hi tom
i wanted to know what is the proper way to clear active /current corrupted redo log group from what i know that you need to do a point in time recovery before the corrupt happens.is this the best way or is there a another way to clear a corrupted active/current redo log group without doing a PITR

and Connor said...

Check here

https://asktom.oracle.com/pls/apex/asktom.search?tag=alter-database-clear-logfile

But it should be *extremely* rare that you ever need to do this

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database