Why do we need to transfer Oracle files between databases? There may be lots of cases depending on your imagination, and my case here is sending archivelogs in a dataguard configuration. Dataguard ships the archivelog files automatically, even if the standby database is read-write (Snapshot Standby Feature) in 11g. But in 10gR2, if you’re “Using a Physical Standby Database for Read/Write Testing and Reporting”, archivelog shipping stops while the physical standby database in Read-Write. What i want to do is adding an 11g feature to 10g and ship the archivelogs from primary to standby via a script.
What options do we have for this purpose?
DBMS_FILE_TRANSFER
DBMS_FILE_TRANSFER package provides three procedures to move Oracle files. COPY_FILE procedure moves files between directories within a database. However GET_FILE and PUT_FILE procedures contacts to a remote database and transfer files from or to remote database.
Note: When transferring files in use, you should bring them offline to guarantee consistency.
Let’s see the usage of PUT_FILE procedure:
