Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 17, 2012 8:31 AM by
Full Database Replication
Jan 4, 2012 11:23 PM
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.
This content has been marked as final.
Show 1 reply
Re: Full Database Replication
Apr 17, 2012 8:31 AM
in response to
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.