Switchover to physical standby database in oracle 11g once the standby database is configured and works fine then we can switchover to standby database for testing purpose to reduce the primary database downtime. This document will guide you through configuring oracle data guard faststart failover fsfo using a physical standby database. As per the oracle data guard broker manuals since oracle database 10g release 2, see the oracle data guard broker 11g release 2 11. The database should be mounted as the standby database. Switchover to a physical standby database on the standby database, after the primary database is switched over, the switchover status of to primary indicates that the oracle. Refresh and switchover to the physical standby oracle database steps to refresh a physical standby database with changes made to the primary database use the recover standby database command with the from service clause to refresh a physical standby database with changes that were made to the primary database. Steps to refresh a physical standby database with changes. Verify that the oracle instance is in archivelog mode. Faststart failover is used within a data guard configuration under the control of the data guard broker.
Oracle data guard broker and static service registration. Oraclebase data guard physical standby setup using the data guard broker in oracle database 19c articles oracle 8i oracle 9i oracle 10g oracle 11g oracle 12c oracle c oracle 18c oracle 19c miscellaneous plsql sql oracle rac oracle apps weblogic linux mysql. If flashback was enabled on your old primary database, then you can reinstate it to behave as standby database. If this is an oracle rac physical standby database, the broker directs crs to restart the instances that were shut down prior to the switchover. The oracle instance can be in managed recovery mode or open for read only. Fsfo can provide substantial gains in high availability and disaster recovery preparedness for all environments, from inexpensive cloudbased systems to global distributed data centers. Oracle data guard 10g release 2 switchover and failover best practices page 11. Sql alter database commit to switchover to physical standby with session shutdown. Switchover to physical standby database in oracle 11g. Now, you are having only 1 database which is behaving as primary database and you do not have the standby database. If you were trying to test the role transitions, then you could have gone with switchover which is a 2 way process. Primary database may need downtime for many reasons like os upgradation, hardwares upgradation and for many other issues.
313 917 659 724 382 1067 147 1535 457 1123 1206 321 1509 1581 199 1488 693 1605 496 1093 688 1389 277 658 898 799 1019 376 643 1236 415 565 563 961 1001