OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide
Author(s): Doug Stuns (Author), Biju Thomas (Author)
Publisher: SYBEX
Publication Date: 1 Jan. 2000
Language: English
Print length: 844 pages
ISBN-10: 0782126839
ISBN-13: 9780782126839
Book Description
OCP is Oracle′s certification program for database administrators, application developers, and financial consultants.
The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex′s OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up–to–date for Oracle8i and include all the new features of Sybex′s best–selling Study Guides. The companion CDs contain exclusive self–testing software.
The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle′s partners: Sun, Novell, Compaq, and HP. Sybex′s Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self–testing software. Author Lance Mortensen is the author of many best–selling MCSE Study Guides.
Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.
Editorial Reviews
Amazon Review
The sole aim of the OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide is to enable you to pass two of the Oracle Certified Professional (OCP) examinations that form part of the Oracle Database Administrator qualification. These are normally the last two exams you’d sit in the series of five (the first is covered by a companion publication, TOCP: Oracle8i DBA SQL and PL/SQL Study Guide).
The Architecture & Administration part starts with an introduction and then covers authentication, Oracle Enterprise Manager tools, creating a database, table spaces, storage structures and security. The slightly larger Backup & Recovery section delves the depths of all flavours of redo log files (online, offline, current online and non-current online), control files and data files. There are chapters on how to proceed without the aid of Oracle Recovery Manager (RMAN) and with it: go for “with” if you have to choose. Coverage is thorough and businesslike: after all, you aren’t here to enjoy yourself.
For checking your progress there’s a “test engine” on the CD-ROM that contains all the multiple choice questions that appear at the end of each chapter and practice exams. You can take chapter tests and practice exams or generate a new exam composed of a random sample of questions. There are also electronic flashcards of harder questions for downloading to a PC or a Palm for further revision. Pass marks are less onerous than those for other exams in the qualification: 58 per cent for Architecture & Administration and 57 per cent for Backup & Recovery, but hard work is still the order of the day. —Mark Whitehorn
From the Back Cover
Here′s the book you need to prepare for the Oracle8i Architecture & Administration and Backup & Recovery exams (1Z0–023 and 1Z0–025). Written by Oracle8i experts, this affordable and comprehensive Study Guide provides:
Full coverage of all exam objectives—all the information you need
Practical information on administration, backup, and recovery techniques in a real–world Oracle8i environment
Hundreds of challenging review questions, in the book and on the CD
Leading–edge exam preparation software, including a testing engine and electronic flashcards Authoritative coverage of all objectives for both exams, including:
Installing and managing Oracle Server
Using control files
Understanding logical and physical database structures
Understanding segments and storage structures
Managing tables, indexes, and constraints
Managing users and security
Using data utilities
Understanding recovery structures and processes
Using Recovery Manager for backups and recovery
Performing physical backups without Recovery Manager
Performing a complete recovery without Recovery Manager
Performing an incomplete recovery with archiving
Using export and import utilities
Using troubleshooting utilities
Creating and maintaining a recovery catalog
Setting up and using a standby database
About the Author
Doug Stuns , OCP, has been an Oracle DBA for more than a decade. He has worked for Oracle in consulting and education roles for five years and is the founder and owner of SCS, Inc., an Oracle–based consulting company.
Biju Thomas has more than six years of Oracle database management and application development experience. He has written articles for in both Oracle Magazine and Oracle Internals.
Wow! eBook
