RMAN & Golden Gate : how rman can be used to instantiate a database which will be kept in sync later using Golden Gate

Courtesy : http://istvanstahl.wordpress.com/category/golden-gate/

NOTE : THE BELOW IS From Istvan Stahl's Blog and NOT from me. Thanks Istvan Stahl. For  more info visit Istvan Stahl's blog : http://istvanstahl.wordpress.com/category/golden-gate/

===============================================================

OK. Let’s do some blogging 

In my first blog entry I’ll cover how rman can be used to instantiate a database which will be kept in sync later using Golden Gate.

Prerequisites:
- source database (10.2.0.5) called:  source (everything in ASM, this adds one more challenge to configure Golden Gate)
- on the same host we are going to create the target database, and setup the golden gate replication from a particular SCN

The steps for this tutorial:

1. Create you source database using dbca  (make sure you have ASM instance and listener on 1521 port ready).

:

:

4.  Configure the source database

5. Create a simple demo schema in the source database (the column “text” is clob just to try if replication of log columns is working as well)

6. Backup your source database

7. Configure source GG

8. Now let’s create the target database using RMAN

First backup the newly created archive logs of the source database, and create a pfile.

9. Configure GG for the target database

10. Now start the source extratct and the target replicat

I hope you succeeded as well  If not please leave a comment.