Martin Power
Paper Title and Abstract

Database block corruption - how to resolve this twice in a lifetime problem.

Stream: DBA

Oracle 12c Database redefines the landscape in terms of efficiency, manageability and performance, however data block corruption still occurs and when it does what are we faced with?

During this session we will consider the factors that lead to block level corruption, the recovery strategies if you have RMAN point in time recovery options open to you and what to do if you do not.  The session is based on an actual recovery scenario that was very close to home, the corruption of AUSOUG’s Beehive database.  With RMAN in place we took this opportunity to investigate the recovery of a system when corruption occurs and the triggers that led use to explore our options.  During the session we will intentionally corrupt a number of Oracle blocks, used to support sysaux materialised views.  We will work through the exercise of moving these object and reformatting the blocks so that they can be used. 

Questions will follow the exercise.  Comprehensive notes will be supplied and references to Oracle Support documents that provide additional information you should be aware of.

Speaker Details

This course will be delivered by Martin Power from Parish Crest, a member of the 12c Database Beta Test Team since its inception.   Martin is an Oracle ACE and President of AUSOUG.  He has worked with Oracle Database since 1982 (version 4.1.4) covering all releases across this period.

Martin has been recognised as a key service provider in the educational sector and an Australian leader in the early successful deployment of Oracle 10g and Rac. Oracle engaged Martin in 2005 and 2006 to speak on Oracle technology and implementation at international and national forums and conferences. Martin not only understands Oracle products, services and solutions (including eBusiness suite), but he is also technically very experienced in systems integration and the practical design and delivery of hardware and Oracle-based software system solutions.

Martin continues to serve as President of the Australian Oracle User Group (AUSOUG). He has represented this body in international and national events and in discussions with Oracle Corporation in the United States.