oracle-Audit derivative

1, due to audit requirements, MySQL, Oracle database needs to import the table data to SQL Server for audit.

2, the previous method:
A. Oracle group dumps the table, compresses it, transfers it to the Oracle derivative server (brokered server), restores it, and modifies the table structure to migrate data from the Oracle Library with SQL Server's own tools.
B. mysql dumps the table structure and data files and imports them into the SQL Server database via bcp.

3, now through the test found that Oracle through the Db_link way to transfer the online data to the transit server than the table dump down, then compress and restore faster and more ruthless. (Remember to do it on the Oracle DG side)

4, if the standby IP is: 192.168.7.119
Create user name Yoon, password Yoon to access the schema of the Oracle Backup required table

5. Relay Oracle Server IP: 192.168.7.120
Create DATABASE Link:
Sql>grant CREATE database link to Yoon;
Sql>create DATABASE LINK cts_test CONNECT to Yoon identified by Yoon USING ' yoondg '; YOONDG for the standby Tnsnames.ora service name
When you are finished creating a test, you can connect access:
Sql>select Count (*) from [email protected]_test; Query to Data description OK.
Start derivative:
Sql>create table Yoon.yoon as SELECT * from [email protected]_test;

6, write scripts, serial execution; If there are 5 standby, can open 5 window execution, the original 700 million data dump after the compression, restore needs n long, through the link way about more than 100 minutes to be done.

7. Finally, the Oracle derivative can be obtained from SQL Server's own tool.

oracle-Audit derivative