tailieunhanh - Oracle Database Administration for Microsoft SQL Server DBAs part 3

Oracle Database Administration for Microsoft SQL Server DBAs part 3 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 2 Oracle Database Administration for Microsoft SQL Server DBAs atabase 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. Before we look into the specifics of Oracle in this chapter we will review the role of the DBA so you can see how to leverage the skills you already have as you learn the new database platform. We will also look briefly at the migration process. General DBA Skills The role of the DBA is more than just backing up the database and making sure the database is available. There are several hats that are worn by a DBA from tuning queries to