Oracle Database Management Strategic Directions

1. Best Practices for managing Oracle database servers.
2. Oracle Fusion Middleware products like J2EE, ADF, XML, BPEL, SOA, Web Services, Discoverer...).
3. Oracle Application Servers and Apache.

Thursday, May 14, 2009

The Future of Backups for DBAs

DBAs have used vendor solutions for backups for years.
  • In the Oracle world RMAN has been the primary tool used for Oracle backups.
  • In the MySQL world replication, InnoDB hot backup have been primary tools used for backups.

However as databases grow into the two terabyte range and larger, the old ways are just not efficient any longer. In the future you will see snapshots and split mirror backups become more prominent in large database enviroments.

Snapshots and split mirror backups offered by logical volume managers and some operating systems allow a backup to be taken in a few seconds. Higher availability requirements and time windows required to perform backups are becoming bigger issues as database servers continue to grow in size.



At 4:56 PM, Blogger SydOracle said...

"the old ways are just not efficient any longer"
Newsflash. These tools (or at least RMAN) do actually improve over time. Block change tracking, incremental backups.

Plus the fact that volume snapshots can ONLY work if they are don in conjunction with database operations. In Oracle you would have to ensure that the tablespaces are in backup mode otherwise the Oracle database blocks may be inconsistent (as they don't map one-to-one with file blocks) and would be unusable for a point-in-time recovery.

If you stop using database tools for backup, you stop backing up your database.

At 5:05 PM, Blogger Unknown said...

Gary thanks for the input. You're right snapshots do have to be synched up with database operations. Snapshots can backup multi-terabyte systems in a few seconds.

RMAN is a great tool and most Oracle environments use it. I'm just seeing that as databases get above the 2 TB range, organizations are looking at other options.


Post a Comment

<< Home




Popular Classes

  • Oracle11gR2 New Features

  • Intro to Java Programming
  • Intro to Linux for Oracle
  • Intro to PL/SQL Programming
  • Oracle11gR2 Fusion Dev Wkshp I



    The Trubix Blog is focused on discussions on strategic directions in database technology and the challenges Oracle technologists are addressing today and in the future. This site will focus on issues and challenges of database management that cannot be resolved with a code snippet. There are already a lot of great websites out there with tons of code samples. We would like to facilitate more discussions on issues Oracle technologists are dealing with today that a quick search on the Internet cannot solve. There will also be a group of recognized industry leaders that will also participate in this blog. This blog is an extension of the Tim Tam Group, an international group of industry leaders that meet once a year to discuss strategic directions in the industry.



    Powered by Blogger