Book description
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.
- 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
Table of contents
- Cover
- Front Matter
- 1. Installing the Oracle Binaries
- 2. Creating a Database
- 3. Configuring an Efficient Environment
- 4. Tablespaces and Data Files
- 5. Managing Control Files, Online Redo Logs, and Archivelogs
- 6. Users and Basic Security
- 7. Tables and Constraints
- 8. Indexes
- 9. Views, Synonyms, and Sequences
- 10. Data Dictionary Fundamentals
- 11. Large Objects
- 12. Partitioning: Divide and Conquer
- 13. Data Pump
- 14. External Tables
- 15. Materialized Views
- 16. User-Managed Backup and Recovery
- 17. Configuring RMAN
- 18. RMAN Backups and Reporting
- 19. RMAN Restore and Recovery
- 20. Automating Jobs
- 21. Database Troubleshooting
- 22. Pluggable Databases
- Back Matter
Product information
- Title: Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data
- Author(s):
- Release date: March 2019
- Publisher(s): Apress
- ISBN: 9781484244241
You might also like
book
Pro Oracle Database 12c Administration, Second Edition
Pro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from …
book
Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control
This practical Oracle Press guide teaches cutting-edge techniques for building, configuring, and managing a secure private …
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Oracle RMAN 11g Backup and Recovery
Master Oracle Recovery Master Protect your databases from hardware, software, and operator failures using the detailed …