In order to export a database backup from Active Data Guard, perform the following steps:
- Ensure that your standby database is in the
Read Onlymode and theMRPprocess should not be running, as shown in the following query:SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY
- 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>
- 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>
- Now execute EXPDP from the primary database as follows and ensure that you have proper roles and privileges to export the backups:
[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 ~]$
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.