Physical standby database are open in Read Only mode and data pump job perform some write activity in database for completing export/import job, to support this activity Create database link in your UAT or any other database which are opened as read write mode.
1. Create Database Link With Standby Database.
CREATE DATABASE LINK STDBY
CONNECT TO PRODUSER
IDENTIFIED BY pass123
USING '10.11.201.200:1521/dcdbstdby';
2. Now submit data pump job using NETWORK_LINK parameter.
expdp system/pass123 schemas=PRODUSER directory=DUMP_FILE_DIR dumpfile=PRODUSER_DATA_DUMP.dmp logfile=PRODUSER_DATA_DUMP.log NETWORK_LINK=STDBY
This policy can be used to perform import dump file into remote database.
No comments:
Post a Comment