| Description |
1 online resource |
|
data file rda |
| Summary |
The book follows a tutorial-based approach, covering all the best practices for backup and recovery. The book starts by introducing readers to the world of backup and recovery, then moves on to teach them the new features offered by Oracle 12c. The book is full of useful tips and best practices that are essential for any DBA to perform backup and recovery operations in an organization. This book is designed for Oracle DBAs and system administrators. The reader will have a basic working experience of administering Oracle databases. This book is designed for Oracle DBAs and system administrators. |
| Contents |
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. |
| Note |
Print version record. |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) (OCoLC)fst01363816
|
|
Database management.
|
|
Data recovery (Computer science)
|
|
Information storage and retrieval systems.
|
|
COMPUTERS -- Data Processing.
|
|
Data recovery (Computer science) (OCoLC)fst00887974
|
|
Database management. (OCoLC)fst00888037
|
|
Information storage and retrieval systems. (OCoLC)fst00972781
|
| Other Form: |
Print version: Alvarez, Francisco Munoz. Oracle database 12c backup and recovery survival guide : a comprehensive guide for every DBA to learn recovery and backup solutions. Birmingham, England : Packt Publishing, ©2013 414 pages 9781782171201 |
| ISBN |
9781782171218 (electronic bk.) |
|
1782171215 (electronic bk.) |
|
1299925960 (electronic bk.) |
|
9781299925960 (electronic bk.) |
|
