Possible Oracle corruption when using it's filesystemio_options=SETALL parameter

Solution Verified - Updated -

Issue

  • Using a combination of a EXT4 filesystem, Oracle RMAN backups configured with Oracle's application parameter filesystem_io=SETALL, and compression enabled causes database backups to be corrupted during recovery.
  • This behavior may have been ongoing for some time and was only noticed after validation was enabled during database restores.
  • The last 512 byte block is being overwritten with zeros and this is corrupting the database.
  • The corrupted 512 byte block is consistently 131072, but not always.

Environment

  • Red Hat Enterprise Linux 8
  • Red Hat Enterprise Linux 7
  • Red Hat Enterprise Linux 6
  • EXT4
  • Oracle RMAN for database backups/recovery

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content