What is Oracle real-time backup system?
Oracle Streams replication is the process which enables Oracle database schema to replicate to another Oracle database, which can be located to any location. Whenever a transaction occurs in the primary database DML or DDL, it will execute immediately to the target database to maintain a live backup copy. Below I am explaining and providing scripts for Oracle Streams step by step replication example.
Oracle Streams Replication Setup
Important! Create an entry in tnsname.ora for both source and target databases for each other connection.
Step-1 Configuring Target or Secondary Database
Step-2 Configuring Source or Primary Database
Step-3 Create Tablespace for Source Database
Step-4 Create Oracle Streams Admin User for Source Database
connect [source_sys_connection1] as sysdba;
/
Step-5 Creating Streams Admin for the target database
connect [target_sys_connection] as sysdba;
Step-6 Creating Database Link for Source Database
connect [source_stream_connection]
Step-7 Creating Database Link for Target Database
connect [target_stream_connection]
Step-8 Creating Datapumb Directory on Target database
connect [target_stream_connection]
Step-9 Creating Capture process at the source database
Step-10 Creating Apply process at the target database
connect [target_stream_connection]
Step-11 Instantiating Target Database
connect [target_stream_connection]
Step-12 Starting Apply process at the arget database
connect [target_stream_connection]
Step-13 Starting Source Capture process
connect [source_stream_connection]
Select * From V$STREAMS_CAPTURE;
Select * From DBA_APPLY;
connect [target_stream_connection]
connect [source_stream_connection]
If you are not able to modify these scripts then you can buy this utility, based on vb.net check this link Oracle Replication Software.