Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Using the SQL ACCESS Advisor PL/SQL interface

Using the SQL ACCESS Advisor PL/SQL interface

In the article you will have a look at an example of using the SQL Access Advisor PL/SQL interface to obtain the access path and object structures change recommendations.

Continue reading

March 2, 2016 Posted by | oracle | Leave a comment

Configuring Fast Start Failover

Configuring Fast Start Failover

In the article you will have a look at an example of configuring Fast Start Failover (FSFO). Oracle 11gR2 has been used. The configuration is based on server zeus running the PRA database and server Apollo running the STBY2 database. The STBY2 is the standby database.

Continue reading

March 2, 2016 Posted by | oracle | Leave a comment

Session failover using Data Guard 11gR2

Session failover using Data Guard 11gR2

In the article we will see the session failover using an Oracle 11gR2 Data Guard. The feature is available since Oracle 11gr2 when the services become a CRS resource. The software used is Oracle RDBMS 11gR2. There are two nodes zeus running the PRA primary database and a STBY1 standby database and apollo running the STBY” standby instance. We will demonstrate a connection failover of a connection to a service on the primary while transitioning the STBY2 standby database open as an ADG as a new primary.

Continue reading

March 2, 2016 Posted by | oracle | Leave a comment