Oracle databases contain critical business data that must be protected. This entry-level guide shows database administrators effective methods for protecting their data.
In this book, Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. Oracle RMAN Recipes helps you take advantage of all that RMAN has to offer. This handy guide demystifies the steps required to protect your business data. It provides ready-made and example-based solutions to common (and some not-so-common) backup and recovery operations.
RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 job responsibility: Be able to recover the database. Of all the things you are responsible for as database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: Lose that data and your company could fail. Lose that data and you could be out of a job. Oracle's flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c delivers. It’ll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It’ll be the book that lets you sleep at night knowing that no matter what transpires, that you've done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.
Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years, this book provides: Clear and concise information on advanced database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Configuring Recovery Manager Understanding the Flashback Database Recovering from User Errors Working with Globalization Support Using the Scheduler to Automate Tasks Monitoring and Managing Storage Securing the Oracle Listener Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.
The Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning. Set up, configure, and maintain Oracle Database 10g RMAN Use RMAN recovery catalogs, target database packages, and control files Centralize backup tape management using Oracle Secure Backup Perform online, offline, and incremental system backups Monitor and tune performance with Enterprise Manager Grid Control and Database Control Accomplish complete and partial RMAN database restores Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager Overcome human errors using Flashback Versions Query and Transaction Query Create clone and standby databases from tape and disc backups Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies
“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
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 RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator's #1 job responsibility is to be able to recover from data loss. If you're new to the Oracle platform, or you're new to database administration in general, you can hardly go wrong by making it your first priority to learn to backup and recover the database that has been entrusted into your hands. This book is short and sweet at just 200 pages. Focus lies on the mainstream use cases. Recovery Manager, or RMAN as it is called, is a powerful and complex tool that can be intimidating at first. Author Darl Kuhn understands the need to focus on the core use cases, building your confidence in the tool, and in your ability to recover from lost database files, and even to recover your entire database should that become necessary. Oracle RMAN for Absolute Beginners shows how to backup your database. That's the first job. You'll learn to backup the entire database, and to create incremental backups that in turn can speed restore and recovery operations. Then you'll learn to recover from lost data files, lost redo log files, lost control files, and even to restore the entire database from scratch. You'll even learn how to clone a database for development and test purposes by backing the database up on one system and restoring it onto another. Author Darl Kuhn has a decade and a half of experience in writing about, and teaching Oracle Database backup and recovery. If you are newly responsible for an Oracle Database, you can hardly do better than to pick up a copy of Oracle RMAN for Absolute Beginners.
Providing an overview of all facets of UNIX backup and recovery, this text offers practical solutions for environments of all sizes and budgets, explaining everything from freely-available backup systems to large-scale commercial utilities.