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

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

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 is this book for?

Oracle database administrators responsible for database backup and recovery operations.

Related Titles

Expert Oracle Database 10g Administration

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle)

Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle)

Oracle Database 11g: New Features for DBAs and Developers is a comprehensive, example–laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation’s flagship database product.

• Learn what’s new in Oracle that really counts.
• See actual examples and test run output.
• Make sound decisions on new feature adoption.

Sift the gold from the silt and discover which new features of the latest release of Oracle’s flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step–by–step testing and a heart–felt emphasis on what matters in the real–world to help you get the most out of Oracle Database 11g.

What you’ll learn

• Which new features really can make your day–to–day work easier
• How to automate more of your DBA work than ever before

Who is this book for?

Oracle Database 11g: New Features for DBAs and Developers is for developers, DBAs, project managers, consultants, and other technically minded users of the Oracle database. The book will be of use to any professional in the field who wants to quickly review the new features offered by the Oracle Database 11g release.

Related Titles

• Expert Oracle Database 10g Administration
• Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance
• Oracle Insights: Tales of the Oak Table
• Mastering Oracle SQL and SQL*Plus

Oracle Database 11g DBA Handbook (Osborne Oracle Press)

Oracle Database 11g DBA Handbook (Osborne Oracle Press)

The bestselling, comprehensive guide to Oracle database administration, fully revised for the new release

This essential resource for Oracle DBAs has been completely updated to cover the new features of Oracle Database 11g, the industry standard Web-enabled enterprise database system. Oracle Database 11g DBA Handbook details each topic with an emphasis on the big picture, enabling you to achieve effective and efficient database management.

You will learn to get up-and-running on Oracle Database 11g, develop and implement applications, manage storage space, and create reliable system backups. New and revised sections cover high availability, performance optimization, information management, and security procedures. Real-world examples and case studies illustrate each concept along the way.

Oracle Database 11g PL/SQL Programming (Oracle Press)

Oracle Database 11g PL/SQL Programming (Oracle Press)



Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C , and Java procedures, Web-enable your database, cut development time, and optimize performance.

• Create, debug, and manage Oracle-driven PL/SQL programs
• Use PL/SQL structures, delimiters, operators, variables, and statements
• Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
• Work with functions, procedures, packages, collections, and triggers
• Define and deploy varray, nested table, and associative array data types
• Handle external routines, object types, large objects, and secure files
• Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
• Call external procedures through Oracle Net Services and PL/SQL wrappers
• Integrate internal and server-side Java class libraries using Oracle JVM
• Develop robust Web applications using PL/SQL Gateway and Web Toolkit