Oracle 10g Database Administrator Ii Backup Recovery Network Admn With 2 Cds

Oracle 10g Database Administrator Ii Backup/recovery & Network Admn With 2 Cds

Oracle Backup and Recovery

“The developer who has failed in design can be forgiven, but the administrator who has failed in backup and recovery cannot be forgiven.” Just as the above indicates, backup and recovery requires a lot of experiences and knowledge along with discretion. However, it would be too risky to learn the backup and recovery by practicing it, because a simple failure in the backup and recovery will generate tremendous loss. That is why you have to study how to respond and keep a good book at hand so that you can get help from the book whenever you want. In this sense, I can guarantee that this book will serve as a strong anchor when you are in trouble. One of the characteristics of the book is that it presents various types of errors and failures you may encounter at the field. It analyzes error and failure causes from the different perspectives, and explains how to actually do the recovery, particularly focusing on the practical work. It also contains many case-by-case scenarios that are easy to find, so you can get the solutions you need without any difficulty. For example, when you start up the Oracle you may face “ORA-00205: error in identifying control file, check alert log for more info” message and see the Oracle server doesn’t start. In this case, you can refer to the case 1 in the chapter 5 to immediately know the solution. If you drop a table by mistake, you may refer to the chapter 9 in order to recover the table without stopping the server. If you want to respond to the errors and failures that happen in a RAC environment, you can go to the chapter 12 and refer to the cases of various error types. Simply speaking, this book classifies all the errors and failures based on their types, and explains their causes and the responses to them. Sometimes you may successfully do the recovery, not knowing how the recovery is done. This is because you simply memorize how to respond. If you understand the principles of the recovery, going beyond simple memorization, you can always respond to a more complex and difficult situation. Understanding the principles will help you put your knowledge to practical use. Various examples and easy explanations on the principles of the book will surely enhance your ability to apply your knowledge. Make sure you keep this book in order to become the professional engineer who never fails in backup and recovery! 1. Oracle Recovery Principles 2. No Archive Log Mode and Archive Log Mode 3. Oracle Backup 4. Parameter File Management and Recovery 5. Control File Recovery 6. Log Miner Use and Redo Log File Error 7. Data File Error and User Error Recovery 8. Data Migration 9. Emergency Recovery in DB Open 10. Flashback 11. Recovery Manager (RMAN) 12. RAC Backup and Recovery (Raw device) 13. Block Corruption Recovery

OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide

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.