Skip to main content
  • Book
  • © 2019

Pro Oracle Database 18c Administration

Manage and Safeguard Your Organization’s Data

Apress
  • Helps elevate your skills to compete at the professional level
  • Takes a modern approach that includes container-based deployments and automation
  • Full of practical examples while not getting bogged down in theory

Buy it now

Buying options

eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (22 chapters)

  1. Front Matter

    Pages i-xxxvi
  2. Installing the Oracle Binaries

    • Michelle Malcher, Darl Kuhn
    Pages 1-37
  3. Creating a Database

    • Michelle Malcher, Darl Kuhn
    Pages 39-81
  4. Configuring an Efficient Environment

    • Michelle Malcher, Darl Kuhn
    Pages 83-115
  5. Tablespaces and Data Files

    • Michelle Malcher, Darl Kuhn
    Pages 117-150
  6. Managing Control Files, Online Redo Logs, and Archivelogs

    • Michelle Malcher, Darl Kuhn
    Pages 151-191
  7. Users and Basic Security

    • Michelle Malcher, Darl Kuhn
    Pages 193-229
  8. Tables and Constraints

    • Michelle Malcher, Darl Kuhn
    Pages 231-302
  9. Indexes

    • Michelle Malcher, Darl Kuhn
    Pages 303-350
  10. Views, Synonyms, and Sequences

    • Michelle Malcher, Darl Kuhn
    Pages 351-382
  11. Data Dictionary Fundamentals

    • Michelle Malcher, Darl Kuhn
    Pages 383-406
  12. Large Objects

    • Michelle Malcher, Darl Kuhn
    Pages 407-440
  13. Partitioning: Divide and Conquer

    • Michelle Malcher, Darl Kuhn
    Pages 441-497
  14. Data Pump

    • Michelle Malcher, Darl Kuhn
    Pages 499-555
  15. External Tables

    • Michelle Malcher, Darl Kuhn
    Pages 557-580
  16. Materialized Views

    • Michelle Malcher, Darl Kuhn
    Pages 581-646
  17. User-Managed Backup and Recovery

    • Michelle Malcher, Darl Kuhn
    Pages 647-691
  18. Configuring RMAN

    • Michelle Malcher, Darl Kuhn
    Pages 693-732
  19. RMAN Backups and Reporting

    • Michelle Malcher, Darl Kuhn
    Pages 733-772
  20. RMAN Restore and Recovery

    • Michelle Malcher, Darl Kuhn
    Pages 773-835

About this book

Database administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family. This book will help elevate you to the level of Professional Oracle Database Administrator.

This book provides information and techniques for keeping an Oracle database stable and running on-premise, and is fully updated to cover Oracle Database 18c. New in this edition is coverage of cloud administration in the Oracle Public Cloud, automation of tasks using the autonomous database features, and data movement with multi-tenant databases. The book covers everything from architecture of the database engine, securing objects and users, strategies for performing maintenance tasks and resolving performance problems, through to backup and recovery. 

Pro Oracle Database 18c Administration takes a modern approach to database administration. Emphasis is given to automation, which is of growing importance as more databases are being moved into various cloud solutions and database administrators are being required to manage more instances than ever. Focus is given to multi-tenant container architecture and pluggable databases, and the book takes a refreshing, results-oriented approach that helps you get the job done. 


What You'll Learn
  • Understand the differences between managing on-premise and cloud deployments
  • Take advantage of new features in 18c while also managing older releases
  • Manage more databases than ever by automating your environment
  • Apply the latest techniques around pluggable databases and containerization
  • Safeguard your data through good security and backup/recovery practices
  • Troubleshoot common problems




Who This Book Is For


Database architects and administrators who want to level-up to the latest techniques around containerization, automation, and cloud deployment. The book also is appropriate for Oracle professionals desiring to present themselves as being competitive and up-to-date with the latest in the field.

Authors and Affiliations

  • Huntley, USA

    Michelle Malcher

  • Morrison, USA

    Darl Kuhn

About the authors

Michelle Malcher 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). Michelle has built out teams for database security and data services, and enjoys sharing knowledge about data intelligence and providing secure and standardized database environments.


Darl Kuhn 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.

Bibliographic Information

  • Book Title: Pro Oracle Database 18c Administration

  • Book Subtitle: Manage and Safeguard Your Organization’s Data

  • Authors: Michelle Malcher, Darl Kuhn

  • DOI: https://doi.org/10.1007/978-1-4842-4424-1

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)

  • Copyright Information: Michelle Malcher and Darl Kuhn 2019

  • Softcover ISBN: 978-1-4842-4423-4Published: 29 March 2019

  • eBook ISBN: 978-1-4842-4424-1Published: 29 March 2019

  • Edition Number: 3

  • Number of Pages: XXXVI, 986

  • Number of Illustrations: 46 b/w illustrations

  • Topics: Database Management

Buy it now

Buying options

eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access