RMAN recipes for Oracle Database 12c a problem-solution approach
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,...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, Calif.] :
Apress
c2013.
|
| Edición: | 2nd ed |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629402806719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""Foreword""; ""About the Authors""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Backup and Recovery 101""; ""Types of Database Failures""; ""Statement Failure""; ""User Process Failure""; ""Network Failure""; ""Instance Failure""; ""User Error""; ""Media Failure""; ""Oracle Backup and Recovery Concepts""; ""Backup and Recovery Instance Architecture""; ""The Checkpoint Process""; ""The Log Writer Process""; ""The Archiver Process""; ""Physical Database Structures Used in Recovering Data""
- ""Archivelog and Noarchivelog Mode of Operation""""Flashback Technology""; ""Backup Types""; ""Physical and Logical Backups""; ""Whole and Partial Backups""; ""Online and Offline Backups""; ""Full and Incremental Backups""; ""Consistent and Inconsistent Backups""; ""Recovery Types""; ""Database Recovery and Consistent vs. Inconsistent Backups""; ""Crash Recovery and Media Recovery""; ""Crash Recovery""; ""Media Recovery""; ""Complete and Point-in-Time Recovery""; ""Deciding on the Appropriate Recovery Technique""; ""RMAN Architecture""; ""Benefits of Using RMAN""
- ""Backup and Recovery Best Practices""""Configure a Fast Recovery Area""; ""Make and Protect a Database Redundancy Set""; ""Create Powerful Backup Strategies""; ""Schedule Regular Backups""; ""Create Regular Backups of the Control File""; ""Run the Database in Archivelog Mode""; ""Multiplex the Control File""; ""Multiplex the Redo Log Groups""; ""Adopt the Right Backup Storage Strategy""; ""Plan Your Backup-Retention Duration""; ""Plan Your Backup Schedules""; ""Validate Your Recovery Strategy""; ""Conduct Regular Trial Recoveries""; ""Record Accurate Software and Hardware Configuration""
- ""Chapter 2: Jump-Starting RMAN""""2-1. Connecting to Your Database""; ""Problem""; ""Solution""; ""Establishing OS Variables""; ""Using OS Authentication""; ""Using a Password File""; ""How It Works""; ""Explaining OS Authentication""; ""Explaining Password File Authentication""; ""2-2. Starting and Stopping Your Database""; ""Problem""; ""Solution""; ""How It Works""; ""2-3. Toggling Archivelog Mode""; ""Problem""; ""Solution""; ""Enabling Archivelog Mode""; ""Disabling Archivelog Mode""; ""How It Works""; ""2-4. Connecting to RMAN""; ""Problem""; ""Solution""; ""How It Works""
- ""2-5. Backing Up Your Database""""Problem""; ""Solution""; ""How It Works""; ""2-6. Simulating a Failure""; ""Problem""; ""Solution""; ""How It Works""; ""2-7. Restoring and Recovering Your Database""; ""Problem""; ""Solution""; ""How It Works""; ""Chapter 3: Using the Fast Recovery Area""; ""3-1. Creating the Fast Recovery Area""; ""Problem""; ""Solution""; ""How It Works""; ""3-2. Writing Regular RMAN Backups to the FRA""; ""Problem""; ""Solution""; ""How It Works""; ""3-3. Freeing FRA Space in an Emergency""; ""Problem""; ""Solution 1: Delete Unneeded Files""
- ""Solution 2: Increase Space""
