Introduction to Oracle Database Administration

By Ying Wang

This book is not Oracle theory or database management system theory book. It is not Oracle programming book either. It is an Oracle DBA (Database Administrator) practice process and scripts and documentations based on author’s working experiences. The readers can be people who are interested in learning knowledge on Oracle database administrations like developers working on Oracle database, Oracle DBA beginners who wants to know how to manage their Oracle database, IT managers who wants to have some concepts and knowledge on Oracle DBA jobs etc. In this book, the author provides process, scripts, tools and methods to do Oracle DBA jobs like backup/recover methods and scripts, database clone scripts, regular database maintenance like index defragmentation scripts etc in Oracle 11g and 12C and Windows Server environments.

• Language: English
• Publisher: AuthorHouse
• Release date: Jan 15, 2020
• ISBN: 9781728343570

Ying Wang

The author has bachelor degree in computer science and master degree in computer engineering. She has 18 years Oracle and Sql Server database administration working experiences in Canada. Familiar with Oracle DBMS architecture, regular DBA operations, Oracle database installation/upgrade, patch apply, backup/recover process and methods, trouble shooting, database refresh(database clone), performance tuning, database monitoring, Oracle DBMS 8i,9i,10g,11g,12C, PL/SQL, SQL, Quest TOAD, Oracle OEM, Solarwinds DPA etc. software and tools. She has working experiences on Oracle Forms/Reports, Oracle Application Apex, Oracle Fusion Middle Ware 11G administration.

Book preview

© 2020 Ying Wang. All rights reserved.

No part of this book may be reproduced, stored in a retrieval system, or transmitted by any means without the written permission of the author.

Published by AuthorHouse 01/15/2020

ISBN: 978-1-7283-4326-6 (sc)

ISBN: 978-1-7283-4357-0 (e)

Any people depicted in stock imagery provided by Getty Images are models, and such images are being used for illustrative purposes only.

Certain stock imagery © Getty Images.

Because of the dynamic nature of the Internet, any web addresses or links contained in this book may have changed since publication and may no longer be valid. The views expressed in this work are solely those of the author and do not necessarily reflect the views of the publisher, and the publisher hereby disclaims any responsibility for them.

ACKNOWLEDGEMENTS

I would like to thank my co-workers Masud Salahuddin, Shannon Tulk and Carrie Vifansi etc. who helped me and supported me in my works. Without them I cannot finish this book. I also want to thank my family to support my jobs.

CONTENTS

Chapter 1     Introduction to Database Management System

1.1   What Is Database Management System

1.2   Popular RDBMS in the World

1.3   Database and Application

Chapter 2     Oracle Database Management System

2.1   Oracle Database System Architecture

2.2   Database Administrators vs Database Developers

2.3   Oracle Database Server Structure

Chapter 3     Oracle Database Creation and Upgrade

3.1   Oracle Database Creation Method

3.2   Oracle Database Upgrade Method

Chapter 4     Oracle Database Design and Data Management

4.1   Table and Column and Table Relationship

4.2   Data and Data type

4.3   SQL language

4.4   PL/SQL language

4.5   Tablespace and Data Dictionary

4.6   Oracle Database Initialization Parameters

Chapter 5     Oracle Database Backup and Recover

5.1   What is Database Backup and Recover

5.2   Oracle Database Backup and Recover Methods

5.3   Physical Backup and Recover

5.4   User Management Backup and Recover

5.5   RMAN Backup and Recover

5.6   EXPDP/IMPDP Backup and Recover

Chapter 6     Oracle Database Refresh

6.1   What is Oracle Database Refresh

6.2   User Management Physical Backup and Refresh Method

6.3   RMAN Backup

Reviews for Introduction to Oracle Database Administration

[mulherin5mark · Rating: 5 out of 5 stars]

This is a good resource for DBAs that are new to Oracle admin. It gets straight to the basic facts needed when you start looking after Oracle databases. It is very well written and easy to read.