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
It all depends of the use of your secondary database.
Is it a Disaster Recovery resource?
What are you planning to do there?