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
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 1, 2012 12:04 AM by
Full database Replication
Jan 1, 2012 12:04 AM
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
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 0 replies