Oracle 11g For Dummies

Grow wise about Oracle and get going with the leading database software!
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? Either way, this book will guide you through the mysteries of Oracle and database administration. Here are the nuts and bolts of creating an Oracle database, implementing it, and keeping it running in tiptop form.
Build it — learn the building blocks behind the database engine and understand Oracle′s physical and logical structures
Prepare for takeoff — review the hardware, software, system, and storage requirements for implementation
Know your environment — recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
Defend it — assess potential threats to your database, configure Oracle Recovery Manager, and create backup and recovery procedures
Maintain it — know the daily and intermittent tasks necessary to keep your database running properly
Head off trouble — implement the system troubleshooting methodology, use Oracle database logs, and explore other diagnostic utilities
Manage it — monitor with Oracle Enterprise Manager
Open the book and find:
Two ways to manage your database
What tablespaces are and how to use them
How to automate jobs with the Oracle Scheduler
Ten common installation tips
How to use SQL in Oracle
When to use online, offline, control file, and archive log backups
Database encryption options
Advantages of the Flashback database

Spis treści:
Introduction.
Part I: You Don’t Have to Go to Delphi to Know Oracle.
Chapter 1: A Pragmatic Introduction to Oracle.
Chapter 2: Understanding Oracle Database Architecture.
Chapter 3: Preparing to Implement Oracle in the Real Wor ld.
Part II: Implementing Oracle on Your Own.
Chapter 4: Creating an Oracle Database.
Chapter 5: Connecting to and Using an Oracle Database.
Chapter 6: Speaking the SQL Language.
Chapter 7: Populating the Database.
Part III: Caring for an Oracle Database.
Chapter 8: Protecting Your Oracle Database.
Chapter 9: Protecting Your Oracle Data.
Chapter 10: Keeping the Database Running.
Chapter 11: Tuning an Oracle Database.
Chapter 12: Troubleshooting an Oracle Database.
Chapter 13: Monitoring and Managing with Enterprise Manager.
Part IV: Inspecting Advanced Oracle Technologies.
Chapter 14: Flashing Back and Replaying: Advanced Features.
Chapter 15: Using High–Availability Options.
Part V: The Part of Tens.
Chapter 16: Top Ten Oracle Installation Do’s.
Chapter 17: Top Ten Database Design Do’s.
Appendix A: Quick Start Install of Oracle 11g on Linux.
Index.

Nota biograficzna:
Chris Zeis is Chief Technology Officer and partner at Perpetual Technologies, Inc., an Oracle partner. Chris Ruel is an Oracle database administrator and consultant. Michael Wessler manages multiple Web applications for the Department of Defense and consults at various government and private agencies.

Okładka tylna:
Grow wise about Oracle and get going with the leading database software!
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? Either way, this book will guide you through the mysteries of Oracle and database administration. Here are the nuts and bolts of creating an Oracle database, implementing it, and keeping it running in tiptop form.
Build it — learn the building blocks behind the database engine and understand Oracle′s physical and logical structures
Prepare for takeoff — review the hardware, software, system, and storage requirements for implementation
Know your environment — recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
Defend it — assess potential threats to your database, configure Oracle Recovery Manager, and create backup and recovery procedures
Maintain it — know the daily and intermittent tasks necessary to keep your database running properly
Head off trouble — implement the system troubleshooting methodology, use Oracle database logs, and explore other diagnostic utilities
Manage it — monitor with Oracle Enterprise Manager
Open the book and find:
Two ways to manage your database
What tablespaces are and how to use them
How to automate jobs with the Oracle Scheduler
Ten common installation tips
How to use SQL in Oracle
When to use online, offline, control file, and archive log backups
Database encryption options
Advantages of the Flashback database