How frequently can I redo apply without an Active Data Guard license?
stuartuMar 22 2011 — edited Mar 23 2011We are not licensed to use Active Data Guard (db's are running RHEL5 / 11.2.0.2 EE), and I want to use my physical standby for reporting purposes.
I haven't been able to find what is an unacceptable (license) solution with regards to applying redo, and was hoping if someone could advise on this.
For example, I have just created a physical standby database and issue the following commands...
1. sqlplus / as sysdba
2. alter database recover managed standby database cancel;
3. alter database open;
The primary standby is open but not applying redo.
If I create a shell script to apply the redo and deactivate it immediately afterwards, is their a minimum timeframe I could schedule this in my cron? 1 day,... 1 hour,... ????
1. sqlplus / as sysdba
2. alter database recover managed standby database using current logfile disconnect;
3. alter database recover managed standby database cancel;
Where does the line blur between Active DG ad non-Active DG?