My Oracle Support Banner

Recreate Missing Ib_logfile (Doc ID 2636045.1)

Last updated on MARCH 19, 2020

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

Customer has deleted both their redo log files in a running DB environment .
Its preventing mysqlbackup from completing.

Needs a resolution

Changes

Files were manually deleted

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Database already shutdown
 Database still running
 Option 1  : innodb_fast_shutdown=0
 Option 2 : OS ( linux ) file manipulation
 Option 3: FTWRL ( flush tables with read lock )
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.