0 Replies Latest reply: Jan 1, 2012 12:04 AM by cmadiam82 RSS

    Full database Replication

      Hi All,

      I'm having a hard time configuring streams replication. Capture is working on the source database but the problem is on my destination database. Apply is not working.

      We have a production database which is currently holding more than 600GB of data.

      Now, i tried to clone it using RMAN and I was successful on that but it takes time for the cloning to finish. More than a day.

      So the question is, how can I make the destination database as fresh as the prod?

      I tried to get the SCN of the production using this
      until_scn NUMBER;
      DBMS_OUTPUT.PUT_LINE('Until SCN: ' || until_scn);

      then use the SCN for UNTIL SCN clause for RMAN DUPLICATE. After that, I tried to use the SCN -1 for DBMS_APPLY_ADM.SET_GLOBAL_INSTANTIATION_SCN on the target database.

      Is this the right path?

      I want to replicate the whole database of prod to destination thats why im using the GLOBAL.