Contents
The Database Administrator
Oracle Internals
Oracle Installation
Database Definitions and Setup
DBA Tools
Database Backup, Restore, and Recovery
Database Maintenance
Performance and Tuning
PL/SQL
High-Availability Architecture
Database administrators (DBAs) have significant responsibilities .
They must not only provide reliable access to company data , but also protect that data, monitor the database environment , troubleshoot problems, and more. If the lives of DBAs were simple, what fun would that be? That is probably why I enjoy the job so much—because of the different opportunities and challenges that I get to face day to day . To provide a stable and highly available database environment, along with planning backups and performing recoveries and all the other maintenance tasks, DBAs are usually exploring how to use new features , and even learning multiple database platforms. Yes, I said it: as a DBA, you probably need to know more than one database platform. The days of being just an Oracle or SQL Server DBA are probably gone. Companies are adopting more than one database platform, and applications may import or export data from one database system to another. But why am I telling you this? You have already decided to add Oracle to your arsenal. The big question is, How hard will this be ?
If you are a SQL Server DBA, you don’t need to start back at square one to support Oracle databases. Certainly, there are differences between the platforms, but many of the DBA tasks are basically the same. You can apply the skills you already have to learning Oracle, using this book as your guide. This book will even translate terms from SQL Server to Oracle , because sometimes being able to speak the language is half of the battle