Oracle Data Guard 11gR2 Administration : Beginner's Guide

Time for action – exporting a database backup from Active Data Guard

In order to export a database backup from Active Data Guard, perform the following steps:

1. Ensure that your standby database is in the Read Only mode and the MRP process should not be running, as shown in the following query:

   SQL> select open_mode from v$database;
   OPEN_MODE
   --------------------
   READ ONLY

2. Create a directory in the primary database logically and create the same directory name physically at the OS level as follows:

   SQL> create directory expdp_india as '/u02/backups/expdp';
   Directory created.
   SQL>

3. Create a database link from the primary database so that TNS string should point to the standby database, as shown in the following query:

   SQL> create public database link exp_turkey ...