March 19 2014 6:00PM - 8:30PM
Location: 2nd floor, 20 Toronto Street, Toronto, ON
Spend an evening with us and network with fellow Oracle professionals in Greater Toronto Area. Snacks and refreshments provided. Join us!
*** Reserve your spot via TOUG Meetup Event page (Requires a free meetup.com account) ***
6:00PM - 6:30PM Networking
6:30PM - 7:30PM Extreme Availability using 12c Features: Your very last system shut down?
By Tim Quinlan, Database Architect, Scotiabank
There is increasing pressure to improve system availability to try to provide 5X9 service. Using Oracle 12c features, we can now keep the system available for end users through all planned and unplanned outages. We will see how to upgrade and patch the server hardware, operating system, database, middleware and application. Unplanned failures and planned maintenance can all be performed in a manner that has little to no impact on the end user. This fast paced presentation will show how we can use Oracle 12c features to keep your database and application available to users through all changes including the really hard part - application patches and upgrades!
You will see how to bring together high availability options such as RAC, GoldenGate and Active Data Guard, we will see how to switch workloads quickly using Global Data Services, Fast Application Notification, Transaction Guard and Application Continuity. Application and schema upgrades can be performed with the system up and running using edition-based redefinition and parallelized mass updates with the dbms_parallel_execute package. Explanations on when to use these, complete with examples will be shown.
Tim Quinlan is an Oracle certified Database Administrator with experience in Oracle 7 through the current release. He has worked with Databases since 1981, performing the roles of DBA, architect, designer and implementer of enterprise-wide Data Warehouse and transactional Databases. Tim has spoken at many conferences, taught database courses and written feature articles for leading database publications. His main (professional) interest is designing and implementing very large, high-performance, high-availability database systems. His current role is Database Architect at Scotiabank in Toronto, Canada .