Starting Database Administration: Oracle DBA
3/5
()
About this ebook
This ebook contain articles on oracle database administration.RMAN, Backup & Recovery, Datapump and export/import, database auditing etc are important concepts in oracle database administration. All these are well explained in this eBook. Each topic is described with appropriate examples.
If you have a grip on the topics described in this eBook, your understanding on the concepts of oracle administration will become much simpler and easier.
This eBook can be referred by people who are preparing for interviews in oracle database administration.
The articles in this guide can also be referred by starter DBAs as well as experienced professionals.
Related to Starting Database Administration
Related ebooks
Oracle Database 12c Quickstart Rating: 5 out of 5 stars5/5Oracle Ultimate DBA Interview Questions Rating: 5 out of 5 stars5/5Introduction to Oracle Database Administration Rating: 5 out of 5 stars5/5Oracle SQL Developer Rating: 0 out of 5 stars0 ratingsBasic DBA Query v.1: Oracle Database Rating: 5 out of 5 stars5/5Concise Oracle Database For People Who Has No Time Rating: 0 out of 5 stars0 ratingsAdvanced Oracle PL/SQL Developer's Guide - Second Edition Rating: 4 out of 5 stars4/5Oracle Quick Guides: Part 3 - Coding in Oracle: SQL and PL/SQL Rating: 0 out of 5 stars0 ratingsOracle Database 12c Backup and Recovery Survival Guide Rating: 5 out of 5 stars5/5Oracle SQL In 10 Minutes Rating: 5 out of 5 stars5/5SQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5SQL Server: Tips and Tricks - 1 Rating: 5 out of 5 stars5/5Oracle Database Security Interview Questions, Answers, and Explanations: Oracle Database Security Certification Review Rating: 0 out of 5 stars0 ratingsOracle Data Guard 11gR2 Administration Beginner's Guide Rating: 0 out of 5 stars0 ratingsInstant Oracle GoldenGate Rating: 0 out of 5 stars0 ratingsOracle Quick Guides: Part 2 - Oracle Database Design Rating: 0 out of 5 stars0 ratingsORACLE PL/SQL Interview Questions You'll Most Likely Be Asked Rating: 5 out of 5 stars5/5SQL Server 2014 Development Essentials Rating: 5 out of 5 stars5/520 Windows Tools Every SysAdmin Should Know Rating: 5 out of 5 stars5/5Oracle Goldengate 11g Complete Cookbook Rating: 5 out of 5 stars5/5Oracle: Protect Your Data Rating: 0 out of 5 stars0 ratingsOracle Recovery Appliance Handbook: An Insider’S Insight Rating: 0 out of 5 stars0 ratingsOracle SOA Suite 12c Administrator's Guide Rating: 0 out of 5 stars0 ratingsOracle Exalytics Revealed: E-Book Rating: 0 out of 5 stars0 ratingsOracle Information Integration, Migration, and Consolidation Rating: 0 out of 5 stars0 ratingsMy Part-Time Study Notes on Mssql Server Rating: 0 out of 5 stars0 ratingsSQL Server 2016 Developer's Guide Rating: 0 out of 5 stars0 ratingsInstant PostgreSQL Backup and Restore How-to Rating: 0 out of 5 stars0 ratingsOracle 11g Streams Implementer's Guide Rating: 0 out of 5 stars0 ratings
Teaching Methods & Materials For You
Never Split the Difference: Negotiating As If Your Life Depended On It Rating: 4 out of 5 stars4/5Lies My Teacher Told Me: Everything Your American History Textbook Got Wrong Rating: 4 out of 5 stars4/5Dumbing Us Down - 25th Anniversary Edition: The Hidden Curriculum of Compulsory Schooling Rating: 4 out of 5 stars4/5On Writing Well, 30th Anniversary Edition: An Informal Guide to Writing Nonfiction Rating: 4 out of 5 stars4/5Grit: The Power of Passion and Perseverance Rating: 4 out of 5 stars4/5Speed Reading: Learn to Read a 200+ Page Book in 1 Hour: Mind Hack, #1 Rating: 5 out of 5 stars5/5Principles: Life and Work Rating: 4 out of 5 stars4/5Weapons of Mass Instruction: A Schoolteacher's Journey Through the Dark World of Compulsory Schooling Rating: 4 out of 5 stars4/5Fluent in 3 Months: How Anyone at Any Age Can Learn to Speak Any Language from Anywhere in the World Rating: 3 out of 5 stars3/5Verbal Judo, Second Edition: The Gentle Art of Persuasion Rating: 4 out of 5 stars4/5The 5 Love Languages of Children: The Secret to Loving Children Effectively Rating: 4 out of 5 stars4/5Financial Feminist: Overcome the Patriarchy's Bullsh*t to Master Your Money and Build a Life You Love Rating: 5 out of 5 stars5/5Writing to Learn: How to Write - and Think - Clearly About Any Subject at All Rating: 4 out of 5 stars4/5Jack Reacher Reading Order: The Complete Lee Child’s Reading List Of Jack Reacher Series Rating: 4 out of 5 stars4/5The Dance of Anger: A Woman's Guide to Changing the Patterns of Intimate Relationships Rating: 4 out of 5 stars4/5Becoming Cliterate: Why Orgasm Equality Matters--And How to Get It Rating: 4 out of 5 stars4/5Closing of the American Mind Rating: 4 out of 5 stars4/5Personal Finance for Beginners - A Simple Guide to Take Control of Your Financial Situation Rating: 5 out of 5 stars5/5How to Diagnose and Fix Everything Electronic, Second Edition Rating: 4 out of 5 stars4/5The Lost Tools of Learning Rating: 5 out of 5 stars5/5Good to Great: Why Some Companies Make the Leap...And Others Don't Rating: 4 out of 5 stars4/5Inside American Education Rating: 4 out of 5 stars4/5Who Gets In and Why: A Year Inside College Admissions Rating: 4 out of 5 stars4/5A Study Guide for Octavia Butler's "Parable of the Sower" Rating: 0 out of 5 stars0 ratingsHow to Take Smart Notes. One Simple Technique to Boost Writing, Learning and Thinking Rating: 4 out of 5 stars4/5How to Think Like a Lawyer--and Why: A Common-Sense Guide to Everyday Dilemmas Rating: 4 out of 5 stars4/5
Reviews for Starting Database Administration
2 ratings0 reviews
Book preview
Starting Database Administration - anuragbaruah84
Starting Database Administration: Oracle DBA
Published by oraclesql-plsql at Smashwords
Copyrights 2014 oraclesql-plsql
oraclesql-plsql is a website which contains articles on Database administration, SQLplus and PLSQL.
It is designed with the view of sharing knowledge and help people who want to learn Database administration, SQL queries/concepts & PLSQL programming.
This eBook is contains articles on oracle database administration.
RMAN, Backup & Recovery, Datapump and export/import, database auditing etc are important concepts in oracle database administration. All these are well explained in this eBook. Each topic is described with appropriate examples.
If you have a grip on the topics described in this eBook, your understanding on the concepts of oracle administration will become much simpler and easier.
This eBook can be referred by people who are preparing for interviews in oracle database administration.The articles in this guide can also be referred by starter DBAs as well as experienced professionals.
The examples described in this pocket guide have been tested in our test environment (Oracle 10G database) and sometimes differences in version, configuration settings etc may give dissimilar results. oraclesql-plsql will not take responsibility for any loss/damage that may result from the use of this eBook.
This eBook/all content in this eBook is a sole property of oraclesql-plsql and no other party except oraclesql-plsql or other authorized parties can sell this eBook or its contents. This eBook or E-Pocket guide can be/must be purchased only from oraclesql-plsql or authorized parties.
oraclesql-plsql is not affiliated to Oracle Corporation.
It is designed by professionals who have working experience on RDBMS.
Contents -
Introduction to Oracle database
Oracle Database component
Connecting to the Database instance
SYS and SYSTEM users
SYSDBA and SYSOPER privileges
Starting the database
Startup NOMOUNT
Startup MOUNT
Startup OPEN
Startup FORCE
Startup RESTRICT
Startup OPEN RECOVER
Example: Starting a oracle database instance
Database shutdown
SHUTDOWN NORMAL
SHUTDOWN IMMEDIATE
SHUTDOWN TRANSACTIONAL
SHUTDOWN ABORT
Quiescing the database
Suspending and Resuming database instance
Background processes
SGA (System Global Area)
What is a Controlfile
Controlfile backup methods
Controlfile recovery methods
Moving Controlfiles from one location to other
What is a Datafile?
Datafile backup
Datafile Recovery
Datafile Relocation: Moving datafiles from one location to another
What is a Tablespace?
Tablespace movement/relocation
System views containing tablespace information
Redo Logs
Archive logs
System views containing Archive log/Redo log information
To put the database in Archive log mode execute the following steps
To put the database in Noarchive log mode execute the following steps
Creating redo log files
Deleting redo log files
Clearing Archivelog/Redo logs
Redo logs movement/relocation
Profiles
Roles
Role: WITH ADMIN OPTION
Dropping a role
Role with password
Alter Role
Enabling and Disabling Roles
Views containing ROLE information
System and Object privileges
Oracle System Privileges
Oracle Object Privileges
View containing privileges information
Object partitioning
Partition key
Types of Partitioning – List/Range/Hash
Oracle External Tables
Creating External Tables
Creating external tables from existing database tables
Introduction to backup and recovery
Export and Import utility
Export Parameters
Import Parameters
Performing full database export/import
Performing export/import for specific user data
Importing data from one users schema to another
Performing export/import for specific tables
Exporting/Importing only Table structure not data
Performing export/import for specific records
Introducing Datapump
Difference between expdp/impdp and exp/imp
Data pump export (EXPDP) parameter
Data pump import (IMPDP) parameter
Datapump: Performing export/import using EXCLUDE
Datapump: Performing export/import using QUERY
Datapump: Importing to a new Schema
Datapump: Importing data into existing tables
Generating SQL for import jobs
RMAN – The Recovery Manager
RMAN repository
Creating Catalog and Registering target database
RMAN configuration parameters
RMAN commands
RMAN Backup types
Use RMAN to perform a full database backup
Using RMAN to perform database recovery
Using RMAN to recover controlfile
Using RMAN to recover datafile:
Using RMAN to perform Incomplete or Point in Time Recovery
Incremental Backups
Level 0 incremental backup
Level 1 incremental backup
Block Change Tracking
Validating Backup and Recovery operations
Database Auditing
Types of Auditing
Statement auditing
Privilege auditing
Schema Object auditing
Example Standard auditing
FGA
Example FGA
Introduction to Oracle Database
A database is a collection of data stored a database server which is easy to maintain and access
Data on a database is stored in form of blocks, extents and segments. Block is the smallest unit of storage. An Extent is the next level of storage and consists of one or more blocks. A Segment consists of more or more extents.
An oracle database environment consists of several files.
Every database will consist of atleast one Controlfile, Datafiles and Redologs. These 3 are the most important files of the DB. A Controlfile holds important information such as datafile location, backup and recovery information etc., Datafiles holds the actual data of the database and Redologs enables us to redo sql statements.
In addition to the above 3 files, there are some other files as well which support the database –
The Alert log is file that stores information about errors, alerts and other operations. It describes the errors and contains the location of a trace file, which contains details about the errors. If the alert log gets deleted by mistake, it gets recreated automatically.
A Password file stores passwords for certain privileged users. These are users who generally start or stop the database. When a user tries to connect to a running database, their verification is done by the DB itself. But when the DB is not running and a user tries to start the database, the verification is done by means of the password file. The password file allows us to store the passwords outside the DB i.e. in the OS.
A Parameter file contains configuration parameter settings which control the behavior of the database.
Oracle Database component –
Oracle database structure is made up of two main components –
Physical structure – Comprises of files that physically exist on the database. Controlfile, Datafiles and Redologs are the most important files of a database. In addition to these 3 important files, there are also other files which support the database – Archivelogs, Alert.log, Password files etc.
Logical structure – Comprises of the logical components of the database. By logical components we mean the SGA and background processes. SGA is the database memory and background processes are processes that run internally