Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
E-book details
Log in, If you're interested in the contents of the item.
Oracle Database 11g - Underground Advice for Database Administrators. Beyond the basics
Ebook
Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively.This survival guide offers previously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases.The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and proactively prevent disasters by implementing distributed grid computing—scalable and robust—with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.This book will also help you in situations where you need to install Oracle Database 11g or migrate to new hardware making it compliant with a Maximum Availability Architecture. By the end of this book you will have learned a lot and gained confidence in your abilities. You will be armed with knowledge as to which tools are best used to accomplish tasks while proactively moving towards an automated environment.
- Oracle Database 11gUnderground Advice for Database Administrators
- Table of Contents
- Oracle Database 11gUnderground Advice for Database Administrators
- Credits
- About the author
- About the reviewers
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 1. When to Step Away from the Keyboard
- Protecting and defending
- Choosing your tools
- Graphic-based, command-line Oracle tools and usage
- Staying away from dinosaurs
- Insisting on help
- What does a DBA do all day?
- Prioritizing tasksdaily, weekly, monthly, quarterly, or yearly
- Daily
- Weekly
- Monthly
- Quarterly
- Yearly
- Prioritizing tasksdaily, weekly, monthly, quarterly, or yearly
- SLAs: Why isnt the database down anymore?
- Avoiding major blunders
- Summary
- 2. Maintaining Oracle Standards
- Adapting to constant change
- Database concepts
- Multiple ORACLE_HOME(s)
- Keeping the environment clean
- Oracle's Optimal Flexible Architecture (OFA)
- 11g differences in the OFA standard
- XWINDOWS and GUI displays
- Automating day-to-day tasks
- DBMS_SCHEDULER
- OS cron utility executing a scheduled task on a Unix server
- OEM Console plus the Intelligent Agent
- 11g Diagnosability Framework
- Advisors and checkers
- Missing temp file resolution
- Advisors and checkers
- Environmental variables and scripting
- Guidelines for scripting
- Separating the configuration file
- Host commands relative location
- Separating the variable part of the script into its own configuration file
- Don't hardcode values; reference a configuration file and password file at runtime
- Putting variables at the top of the script with curly braces
- Moving functions to a centralized file to be reused
- Validating the use of the script
- Using SQL to generate code
- Helpful Unix commands
- Separating the configuration file
- Guidelines for scripting
- Reducing operating system differences with common tools
- Configuration management, release management, and change control
- Configuration management
- Using OCM in disconnected mode with masking
- Mass deployment utility
- Release management
- DBA issues with patching
- Applying a patch without integrating MOS with OCM
- Using the new patch plan functionality with OCM installed and uploaded to MOS
- Change control
- Configuration management
- Where, when, and who to call for help
- My Oracle Support
- Documentation library
- Summary
- Adapting to constant change
- 3. Tracking the Bits and Bytes
- Dump block
- Demonstration of data travel path
- Location of trace files
- Running dump block SQL statements
- Identifying files and blocks
- Legend for Trace Files:
- Tracking the SCN through trace files
- Single Row Insert
- Commit of a single row insert
- Single row update and corresponding undo block
- Commit of a single row update
- Demonstration of data travel path
- Oracle's RDBMS Log Miner utility
- Turn on archivelog mode
- Add supplemental logging
- Identification key logging
- Table-level supplemental logging
- Flash(back) Recovery Area (FRA)
- Automatic Undo Management (AUM)
- Identifying data in undo segments by flashing back to timestamp
- When to use Log Miner
- Identifying the data needed to restore
- SCN, timestamp, or log sequence number
- Pseudo column ORA_ROWSCN
- Flashback Transaction Query and Backout
- Enabling flashback logs
- Flashback Table
- Flashback Transaction Query with pseudo columns
- Flashback Transaction Backout
- Using strings to remove binary components
- Identifying the data needed to restore
- Summary
- Dump block
- 4. Achieving Maximum Uptime
- Maximum Availability Architecture (MAA)
- Downtimeplanned or unplanned
- MAA with commodity hardware: Case study
- Downtimeplanned or unplanned
- Optimizing Oracle Database High Availability
- To archive or not to archive, you pick the mode
- Multiple archive destinations
- Moving the archive destination in an emergency
- Using a different disk device or disk mount
- Monitoring all hard drive space and Archivelog space
- Database compatibility parameter with spfile, pfile management
- Dealing with storageRAID, SAME, ASM, and OMF
- RAIDRedundant Arrays of Inexpensive Disks
- SAMEStripe and Mirror Everything
- ASMAutomatic Storage Management
- Recommendations for implementing ASM
- Mirrored filescontrol files and online redo logs
- Autoextending data files
- Auditing, log files, and max dump file size
- What is currently being audited?
- Auditing Session Activity
- Other logs to monitor
- Data dictionary healthcheck
- SQL*Net hardening, tuning, and troubleshooting
- Troubleshooting
- What can go wrong?
- To archive or not to archive, you pick the mode
- Grid Control High Availability and Disaster Recovery
- Recommended installation for GC 10.2.0.5+
- Why should I install a separate database?
- Cookbook for silent install and configuring later
- Migrating GC repositories
- Transportable tablespace migrations
- Keeping the repository highly available
- Repository backups, restores, or imports
- MAArepository on a physical standby database
- OMS and agents' high availability
- Cloning Management agents
- GC at a very large site
- Recommended installation for GC 10.2.0.5+
- Summary
- Maximum Availability Architecture (MAA)
- 5. Data Guard and Flashback
- Physical, snapshot, and logical standbys
- Physical standby database
- Snapshot standby database
- Logical standby database
- Commodity hardware and mixed environments
- What is Data Guard broker?
- What controls the Data Guard broker?
- Which tool is best?
- Start with the default configurationmaximum performance
- Utilizing multiple standby sites
- Protection modes and real-time apply
- Maximum performance (default)
- Maximum performance recommendations
- Maximum availability
- Maximum availability recommendations
- Maximum protection and recommendations
- Database states
- Manual failover with physical standby
- Manual failover with DGMGRL
- Flashback and guaranteed restore points
- Possible testing/recovery scenarios for Flashback and Data Guard
- Lost-write detection using a physical standby database
- Corruption, patch reversal, upgrades, or testing scenarios
- Reinstate failed primary scenario
- Troubleshooting the logical standby
- Options for resolving errors that stop the SQL Apply process
- How to skip a single transaction
- Active Data Guard and RMAN
- Other Data Guard notes and features
- Summary
- Physical, snapshot, and logical standbys
- 6. Extended RMAN
- Recovery goals determine backup configuration
- Backup types and the default configuration
- Backup incremental levels
- Full backup
- Logical backup
- Oracle's suggested backup: What is missing?
- Controlfilesan important part of backup and recovery
- How often should backups occur?
- Default configuration details
- Oracle's recommended backup strategy
- Issues with incremental merge backups
- Restore and recovery comparison
- Recommendations for Incremental Merge backup
- Calculating the FRA disk space needed
- Catalog versus controlfile RMAN recordkeeping and retention policies
- RMAN stored script and substitution variables
- Retention policies: Recovery window or redundancy?
- Not needed (OBSOLETE) versus not found (EXPIRED)
- What if I want to keep certain backups?
- Corruption detection
- Physical corruption
- Logical corruption
- Commands and utilities that detect corruption
- DBVERIFY
- RMAN VALIDATE or BACKUP VALIDATE command
- CTAS
- Export utility or Data Pump
- Which utility should be used?
- What should I do if corruption is detected?
- Commands and utilities that detect corruption
- Data Recovery Adviser
- What does RMAN backup, restore, and recover?
- Possible interruptions to the recovery process
- What doesn't RMAN backup, restore, and recover?
- Online redo: Key to consistency
- User-managed backups
- What do I do before starting a restore and recovery?
- Find the most recent controlfile backup
- Find the backup you want to restore
- Restoring the controlfile
- Restoring the database
- Full recovery
- Point-in-Time Recovery
- Verifying that the recovery is complete
- Simplified recovery through resetlogs
- Find the most recent controlfile backup
- RMAN cloning and standbysphysical, snapshot, or logical
- Clones, DBIDs, and incarnations
- Creating a cloned database
- Post-cloning tasks
- Creating a standby database
- Physical standby
- Scheduled maintenance/cataloging of archivelogs
- Rolling forward a standby using incremental
- Rolling incremental for monthly updates to data warehouses
- The DBMS_BACKUP_RESTORE package
- Summary
- 7. Migrating to 11g: A Step-Ordered Approach
- Oracle net services
- Client compatibility (SQL*Net, JDBC, ODBC)
- RMAN binary, virtual/catalog, and database
- Grid Controldatabase repository and agents
- ASM, CFS, and RDBMS within an Oracle Grid infrastructure
- Recommended order of migration
- Installation of major versions, maintenance releases, and patches
- Release installation
- PatchSet installationcloned ORACLE_HOME
- Database upgrade methods
- How long does the database upgrade take?
- Database Upgrade Assistant (DBUA)
- RMAN
- Using RMAN as part of a manual upgrade process
- Downgrading with RMAN
- Using RMAN as part of a manual upgrade process
- Transportable Tablespaces (TTS)
- Preparatory steps for TTS migrations
- Using TTS for upgrades
- TTS cookbook
- Recreating an unrecoverable database with TTS
- Using TTS to add skipped read-only tablespaces during duplication
- Using TTS to merge two ASM databases into one
- Sharing read-only tablespaces between different databases with TTS
- Cross-platform migrations with a transportable database
- Physical and/or snapshot standbys
- Failing back to original version
- Transient logical standby: Rolling upgrades with minimal downtime
- Export/import or data pump migration
- Character set selectionUTF8
- Post-11g upgrade tasks
- Summary
- 8. 11g Tuning Tools
- Hardware load testing and forecasting
- OrionOracle I/O numbers calibration tool
- Calibrate I/O
- jMeter
- Monitoring hidden or underlying problems
- Proactive monitoring
- Automatic Diagnostic Database Monitor (ADDM)
- Automatic Workload Repository
- Active Session History (ASH)
- SQL Advisors
- STATSPACK
- Reactive diagnostic and tracing tools
- Bind peeking and Adaptive Cursor Sharing
- Gathering statistics
- Comparing statistics
- Restoring statistics history
- Knowing what needs to be tuned
- Tuning a single query
- SQL Plan Management (SPM)
- SQL Management Base
- Tracing and diagnostic events
- What is an event ?
- When should I set an event?
- What are the different event levels?
- Specific Trace events for performance problems
- Interpreting the resulting Event Trace file
- Upgrading the Optimizer
- Capturing and backing up execution plans and statistics
- SQL Tuning Sets
- Stored Outlines
- Capturing and backing up Optimizer Statistics
- Upgrade the database to 11g
- Capturing new execution plans and new statistics
- Evolving or verifying new plans that execute better than the 10g versions
- Summary
- Hardware load testing and forecasting
- Index
- Title: Oracle Database 11g - Underground Advice for Database Administrators. Beyond the basics
- Author: April C. Sims, April Sims
- Original title: Oracle Database 11g - Underground Advice for Database Administrators. Beyond the basics
- ISBN: 9781849680011, 9781849680011
- Date of issue: 2010-04-08
- Format: Ebook
- Item ID: e_3arq
- Publisher: Packt Publishing