Many companies, large and small, use Oracle products. At the heart of this technology is an Oracle database. Businesses use the technology to store and manage mission critical data. This information is the basis for making smart business decisions. Companies that effectively transform data into business intelligence quickly gain a competitive edge in the marketplace. Oracle database administrators (DBAs) play a pivotal role in implementing and leveraging Oracle database technology. DBAs add value by ensuring that databases are created in an efficient manner and optimally maintained. DBAs are often queried for architectural advice on features, implementation, data migration, replication, SQL coding, tuning, and so on. DBAs fill the role of the go-to person for anything related to Oracle. The job of an Oracle DBA is frequently complex and challenging. This book focuses on practical examples and techniques for providing a smoothly operating database environment. The content is drawn from years of experience working with Oracle technology. The book shows you from the ground up how a senior DBA manages a multifaceted database environment. I try to focus on demonstrating how to correctly implement features, with scalability and maintainability in mind. I hope you find the material in this book useful. The goal is to elevate you to a professional level as a DBA. Being a DBA doesn’t have to be constantly painful. The key is to correctly implement the technology the first time, not paint yourself into a corner with a badly implemented feature, and proactively manage your surroundings. This book doesn’t show you the most complex and sophisticated techniques used in database administration. I try to keep my techniques as simple as possible, yet robust enough to manage any level of chaos and complexity. You should be able to take the concepts elucidated in this book and build on them to help you manage any type of database environment.

Oracle 19c Administraion

Oracle 12c Administration I

Part 1 concentrates on creating a working environment. This includes installing the Oracle software and creating databases.Part 2 deals with managing critical database files. Topics explored are tablespaces, data files, control files, and online redo log files.Part 3 discusses configuring users and database objects, such as tables, constraints, indexes, views, synonyms, sequences, and so on.

Part 4 details how to create and maintain large database objects and partitioned tables and indexes. 

Part 5 shows how DBAs use tools such as Data Pump, external tables, and materialized views to manage and distribute large amounts of data.

Part 6 takes a deep dive into backup-and-recovery (B&R) concepts. Both user-managed backups and Oracle Recovery Manager (RMAN) B&R are presented in detail. 

Part 7 focuses on techniques used to automate database jobs and how to troubleshoot typical problems that DBAs encounter.

Part 8 describes how to implement and manage container and pluggable databases

Oracle 12c Administration II

After completing this course, you should be able to: 

• Describe Oracle Database architecture

• Configure the database to support your applications 

• Manage database security and implement auditing Manage database security and implement auditing 

• Implement basic backup and recovery procedures

• Move data between databases and files 

• Employ basic monitoring procedures and manage performance 

• Manage resources and automate tasks

• Work with Oracle Support