Oracle DBA Mentor

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.

  Also teaches how to find answers using community, social media, and tech support resources Focuses on the operational aspects of database administration that transcend individual software releases Imparts a sense of confidence that readers can set up an Oracle database that will meet their needs

  Autorentext
  Brian Peasland is a seasoned Oracle database administrator with well over 20 years working with all Oracle database versions since Oracle 7.1 was released. He is a constant contributor to the My Oracle Support and Oracle Developer communities as well as other forums. Brian has been writing for SearchOracle.com since 2001. He has BS and MS degrees in computer science. Brian is the author of Oracle RAC Performance Tuning.

  Inhalt
  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.