mostraligabue
» » Oracle Database 10g RMAN Backup Recovery

ePub Oracle Database 10g RMAN Backup Recovery download

by Matthew Hart

ePub Oracle Database 10g RMAN Backup  Recovery download
Author:
Matthew Hart
ISBN13:
978-0072263176
ISBN:
0072263172
Language:
Publisher:
McGraw-Hill Education; 1 edition (December 5, 2006)
Category:
Subcategory:
Databases & Big Data
ePub file:
1946 kb
Fb2 file:
1300 kb
Other formats:
rtf txt lrf lit
Rating:
4.4
Votes:
624

Start by marking Oracle Database 10g RMAN Backup & Recovery as Want to Read . 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.

Start by marking Oracle Database 10g RMAN Backup & Recovery as Want to Read: Want to Read savin. ant to Read.

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.

RMAN is Oracle’s database backup and recovery utility that backs up all data with minimal impact on production databases and quickly recovers from the loss of individual files, or the entire database. In Oracle Database 10g, RMAN offers new features for the Data Guard configuration, including:, Flash Recovery Area, a single filesystem or ASM disk group to organize and manage database recovery related files such as backups and archived logs. Standby database server-specific persistent configurations, including channel, device, backup optimization, and control file autobackup settings.

Matthew Hart is the co-author of three books for Oracle Press, Oracle 9i for Windows 2000: Tips & Techniques, Oracle 9i RMAN Backup & Recovery, and most recently Oracle 10g High Availability with RAC, Flashback, and DataGuard. He has worked with high availability technologies in Oracle since version ., and has worked with RMAN since its inception. He has spent considerable time perfecting backup and recovery strategies for Oracle customers. Robert G. Freeman is an Oracle DBA.

Hart, Matthew; Freeman, Robert . 1965 . Get full coverage of every oracle recovery manager feature"-Cover. 1965-.

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.

In Oracle 10g the BACKUP command has been extended to allow it to initiate backups of image copies in addition to. .Improved RMAN Reporting Through V$ Views. Oracle 10g includes additional V$ views making the reporting of backup operations more transparent.

In Oracle 10g the BACKUP command has been extended to allow it to initiate backups of image copies in addition to backupsets. As a result the COPY command has been deprecated in favour of this new syntax Improved RMAN Reporting Through V$ Views. Since this information is not recorded in the controlfile it is lost on instance restart.

Электронная книга "Oracle Database 10g RMAN Backup & Recovery", Matthew Hart, Robert G. Freeman

Электронная книга "Oracle Database 10g RMAN Backup & Recovery", Matthew Hart, Robert G. Freeman. Эту книгу можно прочитать в Google Play Книгах на компьютере, а также на устройствах Android и iOS. Выделяйте текст, добавляйте закладки и делайте заметки, скачав книгу "Oracle Database 10g RMAN Backup & Recovery" для чтения в офлайн-режиме.

Oracle's RMAN utility works pretty well right out of the box, but you may find that it requires a little performance tuning. This chapter excerpt from "Oracle Database 10g RMAN Backup & Recovery" looks at what you need to tune before you begin to tune RMAN itself and provides some performance tuning options for RMAN.

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.

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
  • I finished reading this book about six months ago and delayed writing a review of the book until I had a chance to contrast the contents of the book with the Oracle 10g R2 RMAN documentation and other books on the same subject. I bought the book after reading recommendations by several individuals, and thought that this book was the perfect opportunity to refresh by memory of the Oracle 8i documentation of RMAN and bring me up to speed with the command line interface of RMAN in Oracle 10g R2. The Enterprise Manager Database Control in Oracle 10g R2 almost over simplifies the process of setting up backups, but there is always that nagging question... what if the GUI interface is down, underscoring why it is important to be familiar and comfortable with the command line interface when restore and recovery are needed. I was also preparing to give a presentation related to Oracle administration and performance tuning. This book did not meet the criteria for inclusion in the recommended resources for the presentation, and for that matter neither did any other RMAN book, with the possible exception of the Oracle documentation.

    While the book excels at explaining what makes RMAN tick, I personally found that the book is actually a bit difficult to use when trying to implement a change to the Oracle configuration. The section on database cloning, for instance, is more difficult to follow than Oracle's own "Backup and Recovery Advanced User's Guide" documentation on the same topic. Maybe it is just me (and one or two other people). Flipping between several pages (seemed like a hundred or more) is not confidence inspiring had this been a real emergency.

    I then decided to try a couple recovery scenarios. I set up an Oracle 10.2.0.4 database instance on a new box, used impdp to load a copy of the data from a production database, enabled archived redo log mode, and then scheduled a backup using the Enterprise Manager Database Control. The first test involved shutting down the Oracle instance, and renaming both copies of the control files. The first attempt in following the "Oracle Database 10g RMAN Backup & Recovery" book to recover from this problem resulted in "ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7c910CB0] [ADDR:0x4] [UNABLE_TO_READ] []". The book did not cover how to recover from the ORA-07445, which essentially means that Oracle Metalink support must be contacted - the database is down. Not too reassuring. The second attempt (after recreating the instance and database) of following the book to perform this procedure, after realizing that I should have specified RESETLOGS (if I recall correctly, it seems that information was located somewhere else in the book) resulted in "ORA-19698: ...redo01.log is from different datadase: id=0, db_name=" following the execution of ALTER DATABASE OPEN RESETLOGS. Once again, scanning through this book I did not find the solution to this particular problem. Had this been a real emergency, this book would not have been the only object to hit the recycle bin.

    Other miscellaneous notes about the book, in no particular order:
    * 100+ pages of the book are devoted to setting up RMAN to work with various storage/media managers.
    * RMAN workshops list steps to accomplish various tasks, often spread over 5+ pages in the book. Not all required information is located in close proximity to the RMAN workshops.
    * Covers command line and Enterprise Manager GUI commands for RMAN.
    * Demonstrates flashback versions queries, flashback table, flashback drop, flashback database
    * Many screen shots, diagrams, RMAN Workshop break outs, large font - space filling section headings, seemingly wide margins.
    * Some steps which should be straight forward, such as duplicating a database using RMAN, appear to be very simple when reading the book, yet when attempting to put those simple procedures into practice using the book as a guide, are in fact quite difficult due to all of the alternate syntax which is introduced to cover many different set ups. It might be necessary to flip between 50 different pages to successfully duplicate a database on the same server using this book as a guide.
    * The book does not indicate what features described in the book require an Enterprise Edition license, nor what features require additional licenses beyond an Enterprise Edition license (this seems to happen in several books by different authors).
    * In a crisis, the Recovery Case Studies in chapter 21, which could prove to be the most helpful section of the book, but that section only covers 13 scenarios, all with generally a long description to describe the recovery case study problem.

    This book is spared a three star recommendation only by the fact that I enjoyed reading the book cover to cover.

    Recently, I have been reading "RMAN Recipes for Oracle Database 11g: A Problem-
    Solution Approach" and have found that the book is better organized, locating the necessary information in the right places for accomplishing a task, although there is a bit of over repeating in the book (the same sentence appears in two adjacent paragraphs, for example). While the RMAN Recipes book states that it is designed for Oracle 11g, there are output captures which show that some of the sections of the book were written using Oracle 10.2.0.x. If you are considering the purchase of "Oracle Database 10g RMAN Backup & Recovery", you might first want to examine "RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach" through the Google books search to determine if it is a better fit for your anticipated backup and recovery scenarios.

  • Great book for the price. One of the better Oracle books available on using RMAN as your backup solution.. If you are still on 10g and are using RMAN this is the book to purchase. I am going to purchase the newer 11g version and hope it is as good as this 10g book.

  • This book does a pretty good job of explaining RMAN features and offers some good ideas on how to make RMAN part of your day to day Oracle tool set. Some( all?) of the examples use 10gR2 syntax which will not work with 10gR1, so pay attention! Oracle is trying very hard to make RMAN be everything experienced and novice DBAs need from a comprehensive backup/recovery tool, as a result a book such as this that can simplify and clarify is money well spent.

  • I recommend this book to any DBA.

    Gives you a very good idea of how RMAN works and how backups are performed.

  • This purchase has become a great companion in my work place. The buying experience was great. Amazon is truly reliable.

  • I had bought his book on Oracle 9i RMAN Backup and Recovery...

    And very much impressed with the technical details and examples given in the book... Same way, the book on 10g also excels in technical depth and details...

  • Backup and Recovery is one of the most critical tasks that a DBA has to perform. Sadly, it is also one of the most misunderstood. RMAN should be the tool of choice for backup and recovery for Oracle databases. There is so much that can be done with RMAN.

    What Robert and Matthew do is break it down piece by piece. There is a great intro and they build on that in subsequent chapters. If you want to link RMAN directly with your backup software (i.e. Veritas, EMC, Legato, etc..) then the authors show you how. I used the Veritas piece to link RMAN in and it worked flawlessly. They go over the latest features including block changing files (for faster incremental backups), merging level 1 and level 0 backups (for faster recoveries without the overhead of backing up the whole database), and even cover what the flash recovery area is and how to use it. There is so much great material packed in this book. Yeah, you can try and read Oracle's docs, but rather than just show you how to do it, the authors also teach you why to do it.

    You can read this book chronologically or use it as a reference. The authors writing style make this book a great joy to read. They also include a lot of great examples in case you like to learn by seeing.

    I would highly recommend this book if you are an Oracle DBA, whether you use RMAN or not. Afterall, RMAN is what you should be using :).

  • We had to install and configure Oracle10g 4 node RAC with ASM+FLASHBACK and implement backup/recovery procedures using RMAN and Veritas Netbackup. This book covers everything I need to know in depth.