Restoring and Recovering Oracle using RMAN and Data Domain DDBoost when the catalog is lost

Here’s a scenario I’ve been asked about a few times.

The DBA has backed up the database using RMAN and Data Domain DDBoost and dutifully stored details of the backup in the RMAN catalog.

But then he needs to restore and recover the database to a new server without the RMAN catalog.

This can happen, for example, if an entire data center goes down.  Many Data Domain users use the automatic replication option, whereby Data Domain will replicate RMAN backupsets from one device to another, often to a remote data center, but without the original RMAN catalog to inspect, how do we restore and recover our database?

Continue reading

Replicating an RMAN Backupset with Data Domain and DD Boost

In this post, we will replicate an RMAN backupsets using RMAN managed replication and DD Boost.

In an earlier post, I showed how it was possible to use Data Domain’s Mtree replication to ensure that your Oracle RMAN backups are safely replicated to a second backup appliance when using Data Domain as an NFS target.

Replicating the RMAN backupset is important to protect databases from failures that might affect a whole data center, such as prolonged power or network failures, or events such as a flood that might destroy infrastructure.

These scenarios are rare but should they occur, having the RMAN backups of our databases available at a second location can be the different between an organization surviving such an event, or not.

Continue reading

Configuring DD Boost Replication for Oracle RMAN

In this post, we are going to install the DD Boost module for Oracle RMAN.

DD Boost is an optional module that works with Data Domain and a number of applications and databases, including Oracle. DD Boost moves some of the sophisticated deduplication process from the Data Domain appliance to the database server, resulting in a dramatic reduction in network bandwidth and backup times.

A greater than fifty percent reduction in backup times for a full level zero RMAN backup is typical when switching to DD Boost although as always, your mileage may vary.

Continue reading