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 connect to system identified by "free2go" using 'india';
   Database link created.
   SQL>

4. Now execute EXPDP from the primary database as follows and ensure that you have proper roles and privileges to export the backups:

   [oracle@oracle...