Oracle Flashback Vs IBM FlashCopy
Hi,
I am evaluating options to implement Oracle Flashback and/or IBM FlashCopy as a backup and recovery solution.
Does any one know of a good source for comparing and contrasting these two technologies.
What I am looking for, in particular, is how each compares against other (pros and cons) in terms of
1. Storage - I know flashback storage requirement based on the feature I would want to use could be more than that required for FlashCopy
2. Recovery time - My initial assessment is that recovery with Flashback is faster than that with FlashCopy
3. Backup - Both flashback and FlashCopy can be used to run backup against them (instead of primary DB site)
4. Site failure - From my reading, I take it that Flashback will not protect DB against site failure while FlashCopy would.
The features below, from my reading, are not available in FlashCopy but are integral part of 10gR2
5. Flashback Database
6. Flashback table
7. Flashback Query
8. Flashback Version Query
9. Flashback Transaction Query
10. Flashback Drop
My question(s): Are any of the features (5 - 10) available with IBM FlashCopy? If so how easy/difficult it would be to flash back tables/queries/transactions using FlashCopy.
For site failure, Oracle Data Guard (physical) standby DB is what I am planning to propose.
Any thoughts/ideas/opinions are highly appreciated.
Thanks in advance.