Cargando…
OCP : Oracle database 12c administrator certified professional : study guide /
As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud. You'll sharpen your skills...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Indiana :
Sybex, a Wlley Brand,
[2014]
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Introduction; Chapter 1: Performing Oracle User-Managed Backups; Oracle Database Data Protection Options; What Kind of Failures Can Happen to a Database; Physical and Logical Backups; Tools for Backup and Recovery; Oracle MAA Recommendations; Understanding the Oracle Database as It Relates to Backup and Recovery; Oracle Processes Related to Backup and Recovery; Oracle Memory Structures Related to Backup and Recovery; The Oracle Data Dictionary; Oracle Data Files and Tablespaces; Redo Logs; Control File; Parameter Files; NOARCHIVELOG and ARCHIVELOG Modes.
- The Oracle Instance and the Oracle DatabaseConfiguring the Database for Backup and Recovery; Configuring for ARCHIVELOG Mode; Putting the Database in ARCHIVELOG Mode; Using ARCHIVELOG Mode Data Dictionary Views; Performing Oracle Offline Backups; Performing Oracle Online Backups; The Mechanics of Online Backups; Backing Up the Control File; Creating a Backup Control File; Creating a Trace File with the Create CONTROLFILE Command in It; Summary; Exam Essentials; Review Questions; Chapter 2: Performing Oracle User-Managed Database Recoveries; Performing a Recovery in NOARCHIVELOG Mode.
- Performing a Full Database Recovery in ARCHIVELOG ModePreparing for the Recovery; Recovering the Database; Performing User-Based Incomplete Recoveries; Requirements for and Mechanics of an Incomplete Recovery; Preparing for an Incomplete Recovery; Performing an Incomplete Recovery; Performing Other Types of Recoveries; Recovering from the Loss of a Tempfile; Recovering from the Loss of an Online Redo Log Group; Recovering from the Loss of a Control File; Recovering from the Loss of the Password File; Recovering from the Loss of Everything; Summary; Exam Essentials; Review Questions.
- Chapter 3: Configuring and Backing Up Oracle Databases Using RMANWhy Use RMAN?; Exploring the RMAN Architecture; Getting Started with RMAN; Starting the RMAN Interface; The SYSBACKUP Privilege; The RMAN Command Line; The RMAN Command Prompt; Calling SQL from the RMAN Command Prompt; Configuring RMAN; The Fast Recovery Area; RMAN Persistent Configuration Settings; Unique RMAN Configuration Settings; Preparing RMAN for Use; Backing Up Your Database with RMAN; Using the RMAN Command Line; Types of RMAN Backups; RMAN Offline Backups; RMAN Online Backups; RMAN Incremental Backups.
- RMAN Incrementally Updated BackupsRMAN Multisection Backups; RMAN Backup of Archived Redo Logs; RMAN Backup of the Spfile and Control Files; Backing Up RMAN Backup Sets; Backing Up the RMAN FRA; Creating Archival Backups; Summary; Exam Essentials; Review Questions; Chapter 4: Using the RMAN Recovery Catalog; Introducing the Recovery Catalog; Creating the Recovery Catalog User and Schema Objects; Using a Recovery Catalog; Connecting to the Recovery Catalog from RMAN; Registering the Target Database with the Recovery Catalog; Unregistering a Database; Using Scripts in the RMAN Recovery Catalog.