Oracle Database 11g - Underground Advice for Database Administrators

More Information
Learn
  • The mechanics and essentials of the database at the block level and tracking the System Change Number
  • Reducing or eliminating downtime for the primary database using DATA GUARD and FLASHBACK in tandem
  • Enterprise implementations of RMAN with DATA GUARD, Transportable Tablespaces, and the new Data Recovery Advisor
  • Using both GUI tools and command-line utilities
  • Migrating to the latest release of 11g using the Step-Ordered Approach
  • A solid foundation designed to reduce future maintenance
  • Implementing Maximum Availability Architecture with commodity hardware
  • Many of the common mistakes and failures of common implementations
  • Solving forecasting, performance, and tuning issues with the low cost tools available
About

Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively.

This survival guide offers previously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases.

The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and proactively prevent disasters by implementing distributed grid computing - scalable and robust - with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.

This book will also help you in situations where you need to install Oracle Database 11g or migrate to new hardware making it compliant with a Maximum Availability Architecture. By the end of this book you will have learned a lot and gained confidence in your abilities. You will be armed with knowledge as to which tools are best used to accomplish tasks while proactively moving towards an automated environment.

Features
  • A comprehensive handbook aimed at reducing the day-to-day struggle of Oracle 11g Database newcomers
  • Real-world reflections from an experienced DBA - what novice DBAs should really know
  • Implement Oracle's Maximum Availability Architecture with expert guidance
  • Extensive information on providing high availability for Grid Control
Page Count 348
Course Length 10 hours 26 minutes
ISBN 9781849680004
Date Of Publication 7 Apr 2010

Authors

April C. Sims

April Sims is currently the Database Administrator at Southern Utah University and an Oracle Certified Professional: 8i, 9i, and 10g with a master's degree in Business Administration from the University of Texas at Dallas. Involved as a volunteer with the Independent Oracle Users Group for over 7 years, April is currently a Contributing Editor for the IOUG "SELECT" Journal. April is an annual presenter at Oracle OpenWorld, IOUG COLLABORATE, and numerous regional Oracle-related conferences.