Oracle 10g Database Administrator II Backup/Recovery and Network Administration

ISBN-10: 1418836648
ISBN-13: 9781418836641
Edition: 2nd 2007 (Revised)
List price: $104.95
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
History of Western Art Online content $4.95 $1.99
Add to cart
Study Briefs
History of World Philosophies Online content $4.95 $1.99
Add to cart
Study Briefs
American History Volume 1 Online content $4.95 $1.99
Add to cart
Study Briefs
History of Western Music Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $104.95
Edition: 2nd
Copyright year: 2007
Publisher: Course Technology
Publication date: 5/11/2006
Binding: Paperback
Pages: 588
Size: 7.25" wide x 9.00" long x 1.50" tall
Weight: 2.442
Language: English

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

Preface
Recovery Manager
The Current Challenge at Keller Medical Center
Set Up Your Computer for the Chapter
Important Terms
Backup Methods
User-managed Backups
Backups Using Recovery Manager
Recovery Manager
RMAN Architecture
Connecting to RMAN
The RMAN Repository
Configuring Channel Allocation
Persistent Parameters of RMAN
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Backups Using RMAN
The Current Challenge at Keller Medical Center
Backing Up the Database Using RMAN
The Flash Recovery Area
Backup Using RMAN
Types of Backup
Parallelizing Backups
Performing Backups
The BACKUP Command
Backup Command Options
Examples of Backing Up the Database
The RUN Command
Creating a Script
Setting Duration and Throttling
Block Change Tracking
Backups Using Enterprise Manager
Monitoring RMAN Backups
RMAN Commands
The LIST command
The REPORT Command
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Recovery in Oracle 10g
The Current Challenge at Keller Medical Center
Setup for this Chapter
Recovery Options
Recovering the database in Noarchivelog Mode
Recovering the database in Archivelog Mode
Recovery in the Database
Performing Complete Recovery Manually
RMAN Commands for Complete Recovery
Incomplete Recovery
Guidelines When Performing Incomplete Recovery
Basic Steps for Performing an Incomplete Recovery
Incomplete Recovery Methods
Recovery of Non-critical Files
Re-creating the password file
Recovery of the temporary tablespace
Recreating a redo log file
Recovering an index tablespace
Recovering a read-only tablespace
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Flashback Database
The Current Challenge at Keller Medical Center
Overview of Flashback Database
Components for Flashback Database
Guidelines of Flashback Database
Restrictions of Flashback Database
Configuring Flashback Database
Performing the Flashback Database
The FLASHBACK DATABASE Command in SQL
The FLASHBACK DATABASE Command in RMAN
Failures that May Occur During a Flashback Operation
Options Available After a Flashback Database
Excluding a Tablespace from Flashback
Managing Flashback Database
Monitoring Flashback Logs
Flashback and Datafile Operations
Disabling Flashback Database
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Recovering from User Errors
The Current Challenge at Keller Medical Center
Setup for the Chapter
Flashback Drop
The RECYCLE BIN
Performing a Flashback Drop
Purging a Table
The Flashback Query Feature
Understanding Undo Retention
Performing a Flashback Query
Flashback Versions Query feature
Performing the Flashback Versions Query
Flashback Transaction Query Feature
Performing the Flashback Transaction Query
Flashback Table
Performing the Flashback Table
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Handling Block Corruption
The Current Challenge at Keller Medical Center
Setup for the Chapter
Blocks and Block Corruption
Identifying Block Corruption
Error Messages
The Alert Log File and Trace Files
The ANALYZE command
The DBVERIFY utility
The DB_BLOCK_CHECKSUM and DB_BLOCK_CHECKING Initialization Parameters
The V$ Views
Recovering from Block Corruption
Restoring and Recovering Corrupt Blocks Using a Backup
The DBMS_REPAIR Package
RMAN and Block Corruption
Dropping and Re-creating the Object
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Automatic Database Management
The Current Challenge at Keller Medical Center
Setup for the Chapter
An Overview of Performance Tuning
Common Manageability Infrastructure
Automatic Workload Repository (AWR)
The Advisory Framework
Automatic Undo Retention Tuning
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Database Resource Manager
The Current Challenge at Keller Medical Center
Setup for the Chapter
Terminology
Overview of Database Resource Manager
Configuring DRM
Consumer Groups
Resource Plans
Resource Plan Directives
Putting the Pieces Together
Automatic Mapping of Sessions to Consumer Groups
Relevant Data Dictionary Views
DRM using Enterprise Manager
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
The Scheduler
The Current Challenge at Keller Medical Center
Setup for the Chapter
The Oracle Scheduler
The Scheduler Architecture
Working with the Scheduler
Other important procedures
Advanced Scheduler Components
Statistics Gathering in the Oracle Database
Object Statistics
Viewing Information from Enterprise Manager
Relevant Data Dictionary Views
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Space Management
The Current Challenge at Keller Medical Center
Setup for the Chapter
Tablespaces and Proactive Monitoring
Server-Generated Alerts
Server-Generated Alerts and Tablespace Usage
Segments in the Oracle Database
Indexed Organized Tables (IOTs)
Clusters
Segment Shrink Functionality
The Segment Advisor
Other Space Management Tools
The Undo Advisor
Redo Log File Size Advisor
Managing Resumable Space Allocation
The DBMS_RESUMABLE Package
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Automatic Memory Management
The Current Challenge at Keller Medical Center
Memory Structures of the Database
The SYSTEM GLOBAL AREA (SGA)
Automatic Shared Memory Management (ASMM)
The Program Global Area (PGA)
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Automatic Storage Management
The Current Challenge at Keller Medical Center
Setup for the Chapter
An Overview of ASM
ASM Architecture
Basic Terminology
ASM Components
Administering ASM
Starting and Shutting Down the ASM Instance
ASM Filenames
Managing ASM Diskgroups
Creating a Diskgroup
Dropping a Diskgroup
Adding Disks to a Diskgroup
Dropping Disks from a Diskgroup
Undropping Disks from a Diskgroup
Manually Rebalancing a Diskgroup
Mounting Diskgroups
Dismounting a Diskgroup
Obtaining Data Dictionary Information
Migrating a Database to ASM Using RMAN
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Globalization Support
The Current Challenge at Keller Medical Center
Setup for the Chapter
Why Globalization?
Character Encoding and Character Sets
Character Sets
Length Semantics
The Unicode Character Set
Character Sets and the Oracle Database
National Language Support
The NLS_LANG Parameter
The NLS_LANGUAGE Parameter
The NLS_TERRITORY Parameter
Other Initialization parameters
NLS Views
Date-time Datatypes
The Date Datatype
The Timestamp Datatype
Timestamp with Time Zone Datatype
Timestamp with Local Time Zone Datatype
Sorting Capabilities and Linguistic Sorting
Binary Sort
Linguistic Sorting
The Oracle Locale Builder
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Diagnostic Tools and the Oracle Listener
Setup for the Chapter
The Current Challenge at Keller Medical Center
Diagnostic Tools
The Alert Log File
Trace Files
User Trace Files
The Listener Process
The Listener Control Utility (LSNRCTL.EXE)
Managing the Listener using Enterprise Manager
Vulnerabilities of the Listener
Securing the Listener
Chapter Summary
Syntax Guide
Review Questions
Hands-On Assignments
Case Study
Oracle Architecture
Oracle Instance
Oracle Database
The Physical Structure of the Database
The Logical Structure of the Database
Archiving in the Oracle Database
Automatic Undo Management
The Oracle Data Dictionary
Accessing the Database
Enterprise Manager
Overview of Enterprise Manager
Launching Enterprise Manager
The Database Control Home Page
Glossary
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×