RMAN Recipes for Oracle Database 11g and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Good See details
$31.04 & this item ships for FREE with Super Saver Shipping. Details

or
Sign in to turn on 1-Click ordering.
 
   
Sell Back Your Copy
For a $18.05 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle)
 
 
Start reading RMAN Recipes for Oracle Database 11g on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) [Paperback]

Sam R. Alapati (Author), Darl Kuhn (Author), Arup Nanda (Author)
4.6 out of 5 stars  See all reviews (20 customer reviews)

List Price: $59.99
Price: $36.52 & this item ships for FREE with Super Saver Shipping. Details
You Save: $23.47 (39%)
  Special Offers Available
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Tuesday, January 31? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $32.87  
Hardcover --  
Paperback $36.52  
Sell Back Your Copy for $18.05
Whether you buy it used on Amazon for $31.04 or somewhere else, you can sell it back through our Book Trade-In Program at the current price of $18.05.
Used Price$31.04
Trade-in Price$18.05
Price after
Trade-in
$12.99

Book Description

1590598512 978-1590598511 August 30, 2007 1

It’s sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.

There’s much wisdom in that statement. Of all the things you are responsible for as a 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.

 

Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide:

 

  • Demystifies the steps required to protect your business data
  • Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations
  • Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems
  • Respects your time by providing example-based solutions, not endless reading material

 

When the pressure’s on, you don't have time for long discussions of theory. This book 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.

What you’ll learn

Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to

 

  • Reliably back up and recover your database using Oracle's Recovery Manager
  • Utilize new Oracle Database 11g features such as the Data Recovery Advisor
  • Let Oracle Database manage your backup files via the Flash Recovery Area
  • Automate backup and recovery tasks by writing scripts
  • Troubleshoot RMAN problems and optimize RMAN performance
  • Interface with a Media Management Layer to manage your backup tape library
  • Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations

Who this book is for

Oracle database administrators responsible for database backup and recovery operations.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) + Oracle RMAN 11g Backup and Recovery (Oracle Press) + Oracle Data Guard 11g Handbook (Oracle Press)
Price For All Three: $107.07

Show availability and shipping details

Buy the selected items together
  • In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Oracle RMAN 11g Backup and Recovery (Oracle Press) $35.02

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Oracle Data Guard 11g Handbook (Oracle Press) $35.53

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details



Editorial Reviews

About the Author

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Darl Kuhn is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi, and daughters, Brandi and Lisa.

Arup Nanda has been an Oracle Database administrator since 1993, which has exposed him to all facets of database administration, from modeling to disaster recovery. He currently leads the global DBA team at Starwood Hotels, the parent of chains such as Sheraton and Westin, in White Plains, New York. He serves as a contributing editor of SELECT Journal, the publication of Independent Oracle Users Group (IOUG); speaks at many Oracle Technology events such as Oracle World and local user groups such as New York Oracle User Group; and has written many articles for both print publications such as Oracle Magazine and online publications such as Oracle Technology Network. Arup has co-authored two books: Oracle Privacy Security Auditing (Rampant, 2003) and Oracle PL/SQL for DBAs (O'Reilly, 2005). Recognizing his professional accomplishments and contributions to user community, Oracle chose him as the DBA of the Year in 2003. Arup lives in Danbury, Connecticut, with his wife, Anindita, and son, Anish. He can be reached at arup@proligence.com.

Product Details

  • Paperback: 670 pages
  • Publisher: Apress; 1 edition (August 30, 2007)
  • Language: English
  • ISBN-10: 1590598512
  • ISBN-13: 978-1590598511
  • Product Dimensions: 9.5 x 8.1 x 1.5 inches
  • Shipping Weight: 2.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (20 customer reviews)
  • Amazon Best Sellers Rank: #167,361 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

20 Reviews
5 star:
 (15)
4 star:
 (4)
3 star:    (0)
2 star:    (0)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
4.6 out of 5 stars (20 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

20 of 21 people found the following review helpful:
5.0 out of 5 stars Useful for Oracle 10g and Above, with Carefully Constructed, Easily Followed Solutions, February 14, 2009
By 
Amazon Verified Purchase(What's this?)
This review is from: RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) (Paperback)
About six months ago I read the book "Oracle Database 10g RMAN Backup and Recovery". While I enjoyed reading that book, I found that the book was difficult to use when practicing various backup, recovery, and cloning procedures which were outlined in the book. The reward for flipping through what must have been 50 to 100 pages in order to find everything needed for a practice procedure seemed to be the appearance of unexplained ORA errors, but maybe it was just my inability to follow the directions. In a panic database down situation, should it occur, the "Oracle Database 10g RMAN Backup and Recovery" book will remain on the shelf. So, I started looking for a different resource.

I initially discounted the "RMAN Recipes for Oracle Database 11g" book as irrelevant primarily as I currently use Oracle 10g R2 in production, and did not wish to be confused by a book using 11g specific RMAN syntax without acknowledging that a slightly different syntax is required for Oracle 10g (or 9i, for that matter). In addition to output captures showing that Oracle 11.1.0.x (beta) had been used, other output indicated that Oracle 10.2.0.x was used to demonstrate various commands in the book. The authors made a significant effort to indicate which features are available, and when necessary the alternate syntax in 11g, 10g, and versions prior to 10g. Paraphrasing a couple sections of the book: "Prior to Oracle 10g, it was necessary to set ARCHIVE_LOG_START ([SIC] - LOG_ARCHIVE_START) to TRUE in order to enable automatic archiving of redo logs." "RMAN does not back up locally managed temporary tablespace tempfiles - starting with Oracle 10g Oracle will recreate the tempfiles when the database is opened." "Beginning with Oracle database 10g, it is possible to restore a backup from a previous incarnation and recover through a resetlogs command." "An archived redo log deletion policy is only available starting in Oracle 11g." "In 11g it is possible to use Active Database Duplication to duplicate a database without any prior backups of the source database." The extra effort to identify version specific features allows the book to be used successfully with Oracle 11g, 10g, and possibly 9i.

The title of this book is the second reason why I initially discounted the book as unusable. The title implied that the book's layout was one of "Perform steps X, Y, and Z in order, and don't bother wondering why it works - essentially, do as I say or your database will not rise when placed into the oven." That perception of the book's contents was far from reality. The basic book structure is: Chapter introduction, very brief problem description, well organized step by step problem solution (typically contained on a single page, with relevant related information needed by the solution within 5 pages of the solution), detailed description of how and why each step should be performed as well as side notes and cautionary advice, second very brief problem description, etc. The first half of the book describes how to backup the database, and the second half describes how to recover the database as well as how to set up for special configurations. Roughly 35 pages near the end of the book describe how to configure three different media management products. Most of the book focuses on the command line interface for RMAN, which in my opinion is the correct approach as extensive coverage of backups performed with the Enterprise Manager Database Control would have been a waste of book pages - the nagging question of what to do when the GUI breaks was avoided in this book. The "RMAN Recipes for Oracle Database 11g" book, while not perfect, is organized such that it is not necessary to dig through 50 to 100 pages in order to implement a solution listed in the table of contents, should the book be needed for future reference purposes.

As I did with the "Oracle Database 10g RMAN Backup and Recovery" book, I tested a couple of the backup, recovery, and cloning solutions outlined in this book using Oracle 10.2.0.4 Standard Edition on a Windows platform.
* Repeated backups with and without a recovery catalog, with and without backing up archived redo logs, with and without automatic control file and spfile auto backups, all with a flash recovery area were performed. All worked as described in the book without issue.
* Restore of the control file without a recovery catalog - worked as described in the book, the fact that ALTER DATABASE OPEN RESETLOGS; must be executed when a control file is restored from backup was repeatedly emphasized throughout the book.
* Restore and recovery of a deleted datafile - worked as described in the book.
* FLASHBACK DATABASE did not work as it is not supported on the Standard Edition of Oracle. Block level recovery also would have failed as it is not supported on Standard Edition. FLASHBACK TABLE TO BEFORE DROP did work without problem. See the Oracle documentation "Oracle Database Licensing Information - Oracle Database Editions" for the list of unsupported features.
* Recovering to a previous incarnation of the database did not work as expected (it is possible that I missed a step). When testing, be careful with issuing RESET DATABASE INCARNATION 1; as this could lead to complications when later testing other restore and recovery scenarios - dealing with "ORA-00600: internal error code, arguments: [kcvsor_current_inc_rdfail]" is not covered, and may be an indication that the database incarnation needs to be reset to a different value after recovering the control file, but before attempting to recover.
* Dropping a table and recovering to a past time using the UNTIL TIME syntax worked as described in the book.
* Cloning a database worked on the second try, after modifying the author's init.ora to include a line for SGA_TARGET, and there was no sense of frustration trying to locate all of the items to be set as was the case with the "Oracle Database 10g RMAN Backup and Recovery" book.
* Setting up the production database to permit scheduled cloning of the database worked without problem, although it might have been helpful to stress to the readers that the later addition of data files to the production database will likely require re-executing the RUN block with CONFIGURE AUXNAME so that auxnames are specified for the new datafiles.

General comments about the book, as it was read from cover to cover:
* The book's errata page on Apress' website identifies a number of typos in the book, which may or may not cause problems for people using the book in a high stress situation.
* The first couple chapters contain many paragraphs with odd sentence structure and strange synonyms, making it difficult in some cases to easily understand the authors' advice.
* Page 41 states "Remember to recycle the database after editing the [parameter] file for the changes to take effect." This is after page 29 states "Stopping and restarting your database in quick succession is known colloquially in the DBA world as bouncing your database." I have heard of bouncing the database, but I am guessing that recycling the database is what one would do after corrupting the spfile after editing it with a text editor, or what one might do when the database crashes and RMAN cannot recover the database.
* Page 55 advises against placing the archived redo logs in the flash recovery area, yet page 17, under the heading "Best Practices" states that Oracle recommends using the flash recovery area to store the entire set of backup and recovery related files. "Oracle recommends" is stated a few too many times in the first couple chapters.
* Paraphrasing: "A backup taken while the database is online or in the mount state (???) is considered to be an inconsistent backup. An inconsistent backup always needs recovery after a restore. A noarchive redo log mode database when backed up with RMAN must be mounted." This begs the question, how does one create a consistent backup of a database in noarchive redo log mode when the database must be mounted - I think that "mount" is a typo in the book.
* People reading the book cover to cover will find that the book frequently repeats information throughout the book, but that repetition proves to be quite valuable when using the book as a reference during a backup or recovery situation, as in most cases all need information will be within five pages, or a reference will be made to see Recipe x-y should problem z occur.
* 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). For example, in Recipe 7-10 Performing Incremental Backups, the authors fail to mention how incremental backups in the Standard Edition differs from incremental backups in the Enterprise Edition.
* The method of freeing space in the flash recovery area on page 96 appears to be a bit extreme (like launching a grenade at an ant hill), although better approaches are provided later. Page 246 seems to indicate that the method on page 96 might not be as extreme as it first appears.
* The book shows how to schedule a backup script using either Linux/Unix cron or the Windows task scheduler, with included scripts for both Unix and Windows.
* The recipe showing how to duplicate (clone) a production database on a single host is very well constructed, showing how to create the backup of the production database, what to enter in the listener.ora, the initialization parameters to specify in the clone database's init.ora file, starting the clone in NOMOUNT mode using SQL*Plus, and performing the duplication in RMAN. Unfortunately, the authors failed to specify a value for SGA_TARGET in the suggested... Read more ›
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


8 of 8 people found the following review helpful:
5.0 out of 5 stars Great Book - Like Recipe Format, February 22, 2009
This review is from: RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) (Paperback)
I had a choice between the Oracle Press book, "Oracle DB 10g Backup & Recovery" (called 'the other book') and this book. I sat down and scanned both books side by side. I chose this book even though it was 11g and I was using 10g. The book pretty clearly dilineates between 10 and 11 differences. It also shows both UNIX and Windows steps, which was nice since I was new to Oracle on Windows.

There is a very good Windows overview section.

The index is great. That is a pet peeve of mine. So many books don't even have entries in their index for some letters of the alphabet. This index is very complete.

The other book has a few problems in my opinion. (1) it wastes pages on the same rman syntax diagrams that the manuals have (which are not very easy to follow anyway); (2) it lists the RC tables (again - in the manual); (3) philosophically, I object to Oracle publishing and selling books that shouldn't be necessary if their manuals were easier to read (4) I haven't been that impressed with Oracle Press books in the past (5) not much of an improvement on the manuals compared to the recipe approach.

I agree with Hooper's review.

I disagree with the review by "Oracle DBA" (original user name) entitled "Yet another RMAN book!!". In Amazon, there are really only two books offered. I don't know how many books he's seen. Although I am comfortable reading the Oracle manuals, the four RMAN books take you around and around in circles. You have to read them very carefully to actually figure out what you can and can't do syntactically. The syntax diagrams that have you jumping all over the book are not very helpful. You almost have to be an attorney to decifer what the four books are saying. There is none of that in the 'recipe' book, thankfully.

The 'duplicate to another server' recipe seems to be missing some steps. Hooper alluded to that, too.

I notice that there isn't a recipe for a full disaster recovery. In other words, what if you have to rebuild your entire DB on another server. There should be an overall recipe. It would refer to several other recipes that are already in the book. I thought this was an amusing omission.

Finally, about the recipe format. I really like this. It is the way I format my own notes. In the heat of a battle, you don't want to read paragraphs. You want to get to the point. And it is pretty easy to find the right recipe.

The problem with recipes is that one can be tempted to stop thinking and just follow the steps. But in each recipe, it explains how and why it works. Very nice.

In general, very good book. Well worth the money.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


7 of 7 people found the following review helpful:
5.0 out of 5 stars Must have RMAN book!, October 19, 2007
This review is from: RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) (Paperback)
If you are an Oracle DBA, this book will give you examples and solutions to RMAN problems that you won't find anywhere else, including Oracle's documentation. RMAN recipes gives DBAs specific examples on how to solve problems and then goes into detail on how and why the database works like it does.


Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews











Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
data recovery advisor, database buffers, oracle home, reset time, datafile name, target database control file, base recovery catalog, flash recovery area, restoring the control file, redo log deletion policy, skipping datafile, control file autobackup, virtual private catalog, open resetlogs command, reset logs command, rman command file, report need backup command, flashback database feature, sbttest utility, backup database plus archivelog, alter database open read, drop catalog command, crosscheck command, database open resetlogs, list failure command
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Database, Enterprise Manager, Manual Local System, Oracle Support, Program Files, Oracle Secure Backup, Oracle Net, Memory Script, Key Type, Variable Size, Fixed Size, Redo Buffers, Total System Global Area, Flashing Back, Oracle Wallet, Piece Name, Copies Compressed Tag, Ckp Time Name, List of Datafiles, Above Normal, Type Ckp, Key Inc Key, List of Backup Sets, Grid Control, Mon Apr
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(8)
(3)
(3)
(2)

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...



Look for Similar Items by Category


Look for Similar Items by Subject