Mon premier blog

Oracle Dataguard: Standby Database Failover Handbook Bipul Kumar
Publisher: Rampant Techpress

SQL> alter system set log_archive_dest_state_2 = 'DEFER'; System altered. Without them, the Broker cannot connect to the target database when it is down, as is the case in a switchover or failover or any other operation that requires a restart of a database. For information on performing sys Password: Connected. Feb 1, 2010 - Steps for dataguard failover test with database flashback. Defer the remote archival destination, since we are not going to use it. SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 9 12:14:10 2014. Jun 7, 2010 - If you would like to see the steps for switchover using a manual method see the post Data Guard Switchover to a Physical Standby. Jan 18, 2012 - Oracle 10g Dataguard Failover. Configure connect time failover (Data Guard). Jan 26, 2010 - and configure the listeners to include a service for the Data Guard Broker. 24, 2011 update: Clarified description of AutoConfig dependency when enabling EBS failover environments]. DGMGRL> Show the configuration DGMGRL> show configuration Configuration - proddb Protection Mode: MaxPerformance Databases: proddb - Primary database standby - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL>. Feb 9, 2014 - STANDBY create pfile with only one parameter db_name=STANDBY start standby database in nomount status : [oracle@STANDBY]$ sqlplus. SQL> Alter system set log_archive_dest_state_n=defer; Check last log sequence Select max(sequence#) from v$log_history. On Primary Defer the log shipping to standby. Oracle Data Guard allows you to create standby databases for disaster recovery.