This content has been marked as final. Show 3 replies
The following benefits accrue from the standby redo log files:
During a failover, standby redo logs enable Data Guard to apply more redo data than what is available in the archived redo logs alone.
Standby redo logs are required to implement the maximum protection and maximum availability levels of data protection (no-data-loss) disaster recovery solutions.
Standby redo logs are required to implement real time apply.
Standby redo logs are required for cascaded redo log destinations.
Well creating the standby logfile is on you.But it is highly recommended to create it for the reason being standby redo log files, enable real-time apply, which allows Data Guard to recover redo data from the current standby redo log file as it is being filled up by the RFS process.So maximum data protection.
refer to [http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_apply.htm#i1022881]
DBA2008 wrote:at primary database it is optional ,but it would be good candidate for switchover activity , it makes ensure that if you make any planned maintenance activity at primary site and switchover within yours data guard environment from primary database to physcial standby database ,if you create standby redo log at primary database it is not in use right now but it will be used when yours primary database switch to standby database after switching to physical standby databsae as a primary database.
version 10 & 11g
creating standby logfile groups on primary db is optional or needed? what could be advantages of both?