In order to export a database backup from Active Data Guard, perform the following steps:
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
SQL> create directory expdp_india as '/u02/backups/expdp'; Directory created. SQL>
SQL> create public database link exp_turkey connect to system identified by "free2go" using 'india'; Database link created. SQL>
[oracle@oracle-primary ~]$ expdp system/free2go directory=EXPDP_INDIA network_link=exp_turkey tables=packt.oracle dumpfile=Sample_Standby.dmp logfile=FULL_standby.log Export: Release 11.2.0.1.0 - Production on Wed Nov 7 15:55:28 2012 ........................ Starting "SYSTEM"."SYS_EXPORT_TABLE_02": system/******** directory=EXPDP_INDIA network_link=exp_turkey tables=packt.oracle dumpfile=Sample_Standby.dmp logfile=FULL_standby.log Estimate in progress using BLOCKS method... Dump file set for SYSTEM.SYS_EXPORT_TABLE_02 is: /u02/backups/expdp/Sample_Standby.dmp Job "SYSTEM"."SYS_EXPORT_TABLE_02" successfully completed at 15:55:41 [oracle@oracle-primary ~]$