Dedicated to my daughters.
They believe in me just like I believe in them.
Cloud, automation, artificial intelligence, and machine learning are all keywords for the direction of technology. The interesting thing about these areas is that data is still plays a very important role. Obviously, it is something good for the database administrator or the guardian of the data.
With these new environments and Oracle’s Autonomous Database in the cloud, the question is being asked if DBAs are needed. Self-driving, tuning, and provisioning of databases are the future of the environment. However, there are definitely different tasks that the DBAs are going to be performing along with being the people to go to for migrations to the cloud and automating processes.
So, why write a book about Oracle 18c database administration? This is an easy question to answer. Even though the tasks are changing, understanding the database is critical. Even with processes being automated, there are issues that might need troubleshooting and automations put into place. Applications need database objects designed, created and maintained, and tuned for performance. Is the job now just troubleshooting issues and automating the rest? No, there are design and strategy for data, application, and security. But this book is not just about the transitioning role of the DBA, but to provide administration skills that are still relevant in the database environment. It is also important to know that the internal understanding of the database helps with all of these areas including previous versions.
Data are being integrated, migrated, and maintained in several databases. The structures of these environments are what is needed and what it takes to create consistent, reliable, and always-accessible data. Administration is needed for these systems and support applications with database design and development.
This book provides details about the tasks that are needed to create Oracle 18c databases and provide administration for the environments because it is more than just building a database but managing it with the data and active applications. It provides an inside look of the Oracle database, hardware, storage, and servers that are required to run Oracle. Some of the tasks that are presented are now and should be done through automated processes but stated in ways to being able to work through issues and troubleshoot any problems.
There was careful consideration for including chapters and sections in this book to make sure it was providing the right topics to understand the database along with previous versions, support the design and performance tuning of database objects, and give DBAs the tools they need to be successful.
Backups and recovery are discussed heavily because scenarios of recovery are difficult to automate. There are consistent themes throughout the book to look to create repeatable tasks for automation, securing the environments, and utilizing the new features and tools that come with the new releases of the database. DBAs play an important role in creating backup and security strategies as there are several discussions that support this.
Many of these topics are the same if the database is on-premise or in the cloud. Understanding the difference and how the DBAs can support the migrations to the cloud are included in the notes and sections of the chapters. Databases in the cloud serve many purposes in the enterprise, and DBAs are the perfect resource to assist in migrations and make sure the data are secure and integrated from the cloud environment.
There are many examples, tips, and notes to provide any DBA with Oracle database the tools they need to design, implement, and administer Oracle 18c database environments.
Every time I sit down to write or prepare a presentation, I spend a few minutes reflecting on how I got to this place in my career. There are many people that I am thankful for: to have their influence, guidance, and encouragement in my life. A few of these people I might have told I was done writing books, four books ago. I enjoy seeing their smiles and getting teased when they hear that another one is done.
The friendships that I have made in the database community have encouraged me to learn more and share. I appreciate each of these fun database people who are passionate about what they do and enjoy bringing along others by teaching, mentoring, and supporting others. What an opportunity to be in this career and working with others passionate about databases and being the best guardians of the data! Thank you!
Table of Contents
About the Authors and About the Technical Reviewer
About the Authors
is a security architect for databases at Extreme-Scale Solutions. Her deep technical expertise from database to security, as well as her senior-level contributions as a speaker, author, Oracle ACE director, and customer advisory board participant have aided many corporations in the areas of architecture and risk assessment, purchasing and installation, and ongoing systems oversight. She is on the board of directors for FUEL, the Palo Alto Networks User community, as well as volunteering for the Independent Oracle User Group (IOUG). She has built out teams for database security and data services and enjoys sharing knowledge about data intelligence and providing secure and standardized database environments.
is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi; and daughters, Brandi and Lisa.
About the Technical Reviewer
has been working in database management for 25 years and counting. With 6 books, more than 700 published articles and 500 presentations in 22 countries, he is very well known in the database area in general and Oracle technologies in particular. Today he is the Chief Data Officer of Priceline.com in New York area. He blogs at arup.blogspot.com .