Here we'll be utilizing the demo scripts included in the OGG software distribution to implement a basic homogenous (Oracle-to-Oracle) replication.
You need to ensure your Oracle database is in archivelog mode. If your database is not in archivelog mode, you won't be able to recover your database due to media corruption or user errors.
The steps for creating one-way replication are as follows:
SQL> select supplemental_log_data_min from v$database;
The output of the preceding command will be as follows:
SUPPLEME ----------------- NO