---

IOUG Press

---

New Oracle database administrators can get off the ground running. This book helps you develop the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues. Along the way, you will see how to create your first database and implement best practices to ensure a well-running database system.
What makes Oracle DBA Mentor different is that it also teaches you how to obtain answers that are not found in this or other books. Focus is given to creating a test bed and running test cases to examine hypotheses and prove out solutions so you can be sure they work in production. Attention is given to navigating product documentation and networking in forums and social media to build your skills and a network to draw on when solving problems under pressure. There are chapters of step-by-step technical content as well as coverage of essential skills to succeed as a DBA no matter which database engine you administer.
By the time you are done reading this book, you will have confidence to face many of the situations thrown in your direction. You will know where to go for the answers you don´t yet know that you need. You´ll be able to work and troubleshoot under pressure. You´ll know how to create a database, institute backup and recovery procedures, secure the database and its valuable corporate data, and acquire more knowledge as needed so you can run a database to meet the needs of your organization.

What You´ll Learn

Install Oracle Database with best practices

Implement backup and recovery procedures

Understand the fundamentals of databases and data security

Find answers to technical problems using Oracle documentation, Oracle Support, and other resources

Patch and upgrade an Oracle database


Who This Book Is For
The novice database administrator who wants help getting off the ground with their DBA career, and in building the skills to let that career flourish in the long term. Mid-level DBAs will also find the book helpful as they try to grow their career to the next level. While the book is geared toward the Oracle platform, database administrators from other platforms can benefit from the soft skills covered in this book.

---

Part I: Initial Setup 1. Introduction 2. Working as a DBA 3. Creating Our Server 4. Disk Layouts 5. Installing Oracle 6. Creating Our Database
Part II: Using Oracle Database 7. Recovery and Backup 8. Security 9. Connecting to Oracle 10. Test Cases
Part III: Learning Oracle Database 11. Tools 12. Diagnostics 13. Oracle Documentation 14. Data Dictionary
Part IV: Maintaining the Database 15. My Oracle Support 16. Social Media 17. Patching 18. Upgrades 19. Capacity Planning
Part V: Appendixes 20. Appendix A: Oracle Architecture
21. Appendix B: Advanced Options

---