O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required