What this book covers
Chapter 1, Understanding the Basics of Backup and Recovery, covers topics such as understanding the need for creating backups, getting familiar with the different backup types, an overview of backup strategy, understanding what is redo and how it affects your database recoverability, and understanding database operational modes and redo generation.
Chapter 2, NOLOGGING Operations, covers topics such as LOGGING versus NOLOGGING, disabling redo generation, NOLOGGING operations, how to reduce redo generation, redo log wait events, practice with some interesting scripts, and much more interesting topics.
Chapter 3, What is New in 12c, covers topics such as pluggable database, RMAN's new features and enhancements, and Data Pump's new features and enhancements.
Chapter 4, User-managed Backup and Recovery, covers backup and recovery using user-managed methods. Understanding the basics involving a manual backup and recovery will help you to easily understand what is going on in the background of your database when using RMAN and it will also help you to compare and easily understand all benefits of using RMAN against any other backup method when working with Oracle.
Chapter 5, Understanding RMAN and Simple Backups, describes that being the custodians of databases, DBA's should always try to minimize the loss of data. This can be accomplished through an effective strategy that enables us to secure a backup of these databases that can be accessed in case of systemic failures. However, it is rightly said that any strategy is as good as the tool that implements it. In this chapter, we shall introduce you to a tool that's just like one of those super heroes that can fix almost any issue. So in the list of such amazing heroes such as Superman and Batman, please welcome RMAN, the Recovery Manager—Oracle's one stop solution for both backups and recoveries.
Chapter 6, Configuring and Recovering with RMAN, looks into the two abilities of RMAN, that is, how to configure it and how to use it for doing database recoveries.
Chapter 7, RMAN Reporting and Catalog Management, discusses about the topics such as benefits of recovery catalog, creation and use of recovery catalog, using the CATALOG command, and RMAN reporting using the LIST and REPORT commands.
Chapter 8, RMAN Troubleshooting and Tuning, looks at various ways to get the best performance from RMAN and also techniques to troubleshoot it when it won't behave itself.
Chapter 9, Understanding Data Pump, describes about Data Pump and its architecture, new concepts with Data Pump, methods to move data, and play with many Data Pump scenarios.
Chapter 10, Advanced Data Pump, covers topics such as data masking, build a metadata repository, create a version control, clone users (create a new user using an existent user as a template), create smaller copies of production, create your database in a different file structure, move all objects from one tablespace to another, move a object to a different schema (a simple example, change a table owner), migrate data for a database upgrade, downgrade an Oracle database, transport a tablespace, and use Data Pump with flashback.
Chapter 11, OEM12c and SQL Developer, discusses topics such as configuring our backup and recovery settings (including catalog settings) in OEM12c, scheduling backups in OEM12c, creating restore points in OEM12c, understanding database export/import operations in OEM12c, and getting familiar with the SQL developer.
Appendix: Scenarios and Examples – A Hands-on Lab, allows you to practice some of the scenarios you saw in this book (step-by-step) and learn by practice. If you have any doubt about a command of what it will be doing, please refer to the corresponding chapter in this book for more information.