Oracle Database 12c backup and recovery survival guide : a comprehensive guide for every DBA to learn recovery and backup solutions /

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Alvarez, Francisco Munoz
Otros Autores: Sharma, Aman
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Pub., 2013.
Temas:
Oracle (Computer file)
Database management.
Data recovery (Computer science)
Information storage and retrieval systems.
Bases de données > Gestion.
Récupération des données (Informatique)
Systèmes d'information.
COMPUTERS > System Administration > Disaster & Recovery.
COMPUTERS > Databases > General.
COMPUTERS > System Administration > Storage & Retrieval.
Database management
Information storage and retrieval systems
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover; Copyright; Credits; About the Author; Acknowledgement; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Understanding the Basics of Backup and Recovery; Purpose of backup and recovery; Testing backups; Protecting data; Media failure; Hardware failure; Human error; Application error; Types of backup; A physical backup; A logical backup; Backup strategies; Restore versus recovery; What is redo?; Redo generation and recoverability; NOARCHIVELOG mode; ARCHIVELOG mode; Understanding the ARCHIVELOG mode
  • Preparing for the ARCHIVELOG modeChecking the status of the ARCHIVELOG mode; Specifying parameters; Viewing the status of archival destinations; Placing a database into the ARCHIVELOG mode; Differences between redo and undo; Excessive redo generation during an online backup?; Summary; Chapter 2: NOLOGGING Operations; LOGGING versus NOLOGGING; Disabling redo generation (NOLOGGING); NOLOGGING operations; Indexed organized tables
  • an exception; Reducing redo generation; Tips when LOGGING is in effect (not using NOLOGGING); Backups; Bulk inserts; Bulk deletes; Bulk updates; Partitioning
  • Tips for developersTips when NOLOGGING is in effect; Partitioning; Direct path inserts; Bulk inserts; Bulk deletes; Bulk updates; Backups and NOLOGGING; Redo-related wait events; The 'log file parallel write' event; The 'log file sync' event; The 'redo log space request' event; The 'log buffer space' event; Block corruption due to NOLOGGING; Repairing NOLOGGING changes on physical and logical standby databases; Finding sessions that generate lots of redo; Some other important facts; Redo and undo for DML; Redo and temporary tables; Redo generation and materialized views
  • Flashback and NOLOGGINGPerformance and recovery considerations; Direct path load using SQL*Loader; Some useful scripts; Redo generated since instance startup; Redo generated since session startup; Redo generated by current user sessions; Current status for redo logs; Redo log group and log switch information; NOLOGGING objects in the database; Summary; Chapter 3: What is New in 12c; Pluggable database; RMAN new features and enhancements; Container and pluggable database backup and restore; Enterprise Manager Database Express; Backup privileges; SQL and DESCRIBE
  • Multi-section backups for incremental backupsNetwork-based recovery; Active Duplicate; Support for the third-party snapshot; Cross-platform data transport; Table recovery; Data Pump's new features and enhancements; Disabling LOGGING on Data Pump Import; Full transportable Export/Import; Exporting views as tables; Extended character data types; Encryption password; Compressing tables on Import; Exporting data from the data vault; Creating SecureFile LOBs on Import; Auditing Data Pump commands; Summary; Chapter 4: User-managed Backup and Recovery; Cold backup; Offline backup; Hot backups

Ejemplares similares