Oracle 8i Backup And Recovery

Includes information that every Oracle administrator and programmer must know to maximize uptime and recover data without compromising mission critical systems.

This guide supplies insights to developers on backup and recovery issues and methodologies, provides practice questions accompanied by fully explained answers, and serves as a troubleshooting guide. Readers get proven test-taking strategies, tips on handling trick questions, a "cram sheet" for last-minute review, and information on third-party resources.

“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

With the increasing volume of data to administer and the critical need to keep a database running 24x7 in todays demanding Internet business models, the DBAs task of maximising database uptime is more difficult than ever. Central to maintaining database uptime is an administrators ability to backup and recover data without compromising mission critical systems. This unique book focuses on practical information that will aid Oracle users in resolving problems at their site. It is a one-stop source for useful information spanning many Oracle manuals, technical bulletins and many years of experience.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle’s free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

Oracle databases contain critical business data that must be protected. This entry-level guide shows database administrators effective methods for protecting their data.