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
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.
For this much big size of database you should think different option for database synchronization
e.g. Data Guards or Active Data Guards for full database sync.
(Logical standby or Physical Standby)
Oracle Streaming for table data sync instead of full database sync.