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