Backing up an Oracle Data Guard environment

Restore

In this section, we will describe 3 possible restore scenarios, and for each of them document

the needed steps to bring the data guard configuration back online.

We will consider 3 different scenarios:

I. – Instantiation of the Primary database after a Failover (Loss of the primary database)

II. – Datafile loss on the primary Database. Restore using backup of the Standby

III. – Loss of a data file on the Standby

CAUTION

It is only possible to run restores directly from RMAN. The Data Protector GUI can

not be used for restores in an Oracle Data Guard environment-

I. - Instantiation of the Primary database after Failover

As mentioned in the Data Guard overview, if we loose the primary site, a data guard failover

needs to be performed, and the primary database needs to be recreated to become the new

standby.

Before performing the failover, we must create a full backup with RMAN on the standby

database (SITE oracle1), as described in the section Backup.

Figure 7 Restore Scenario 1