Why dont you implement Active Datagurad and open the standby database in READ ONLY WITH APPLY mode.
Well, licensing would be one reason: Active Dataguard works out to US$59k per CPU. Perhaps Aneel is working with SE1, which is one tenth the price.
However, the simplest way to achieve is probably to use a manual standby. Use scripts to copy over the archive logs as they are generated; open the destination database read only; on some schedule, shut it down, mount and apply the archive, open read only again.
Yes, this can be done. I have manual standby in my environment on Oracle version 8i.
Our strategy is as below.
Clone standby database from production using manual hot backup. -- One time process.
Use script to push archives generated on production to standby site -- Every 4 hrs. i.e 00, 04, 08, 12..
Use script on standby site to apply the received logs on standby database in mount stage. -- Every 4 hrs (2 hrs alternative with production script i.e. 02, 06, 10, 14...)
Don't open standby in read write mode but can be opened in read only mode.
Thanks a lot folks..
I just wanted to confirm if SCN based incremental level backups can be applied or not, thanks for your responses. If someone had done it before please do share the steps here too.
I've discussed the reasons for adopting this kind of strategy here: Re: Export Import alternate or improvement
@nagulan.selvakumar if possible please share with me your environment document (am I allowed to share my email here?)