Offline Database Copy
I need to create a copy of a live database that is maintained with updates from the live database (albeit sometime behind time - even upto 24 hours).
What options are available to me to do this ?
I've looked at LogMiner a few years ago, and there were some issues with it relating to long columns and rolled back transactions.
Is LogMiner the best approach or is there a better method.
Naturally the solution has to have little or no performance impact on the live database
The database is 9i not 10g
Last edited by citldba; 09-19-2007 at 08:10 AM.
It all depends of the use of your secondary database.
Is it a Disaster Recovery resource?
What are you planning to do there?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width