I don’t often learn of major bugs with incremental backups …

… but when I do, it’s always on a Friday afternoon.

During a Friday meeting, some friendly Oracle ExCite types directed my attention to this GEM of a bug:

Bug 16057129 – Exadata cell optimized incremental backup can skip some blocks to backup

If your incremental backups are “cell-optimized” – which they are by default in Exadata – they can skip blocks if a database file grows in size during the backup.

If you’re taking incremental backups with RMAN of your Exadata databases, have not applied the one-off patch for this bug or the “hidden” parameter workaround and you’re running:

  • 12.1.0.1 GIPSU1 or earlier
  • 11.2.0.3 BP21 or earlier
  • 11.2.0.2 (any)
  • 11.2.0.1 (any)

You should assume that all your incremental backups – both cumulative and differential – are invalid and unusable.

Unfortunately, there is no way to know whether your incremental backup has been affected until you use it for recovery and see an ORA-00600 [3020] error message.

Only incremental backups are possibly affected by this problem – you can still use archive logs to recover from a Level 0 backup and other recovery options are not impacted.

To squash this bug, you have three options:

  • Apply the workaround to disable cell optimized backups.
  • Apply the one-off bug fix for your version.
  • Upgrade to either 12.1.0.1.2, 11.2.0.4 or 11.2.0.3.22.

The Quarterly Full Stack Patch for January 2014 includes Bundle Patch 22 for 11.2.0.3, so you may want to review the QFSP January 2014 upgrade process. It looks like you will have to apply a one-off patch 17599908 on top of 11.2.0.3.22, so review it closely!

If you haven’t done so already, bookmark the MOS list of Exadata Critical Issues.

Mark

Advertisements
Tagged , , , , , , , , ,

2 thoughts on “I don’t often learn of major bugs with incremental backups …

  1. […] Remember this particularly scary bug with RMAN incremental backups? […]

    Like

  2. I every time spent my half an hour to read this website’s content daily along with a cup of coffee.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: