Oracle Database 12c Backup and Recovery Survival Guide [electronic resource].

ISBN:

9781782171218

9781299925960

9781782171201

Title:

Oracle Database 12c Backup and Recovery Survival Guide [electronic resource].

Author:

Munoz Alvarez, Francisco.

Personal Author:

Munoz Alvarez, Francisco.

Publication Information:

Packt Publishing, 2013.

Physical Description:

1 online resource.

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.

Local Note:

eBooks on EBSCOhost

Title Subject:

Oracle (Computer file)

Oracle (Computer file) (OCoLC)fst01363816

Subject Term:

Database management.

Data recovery (Computer science)

Information storage and retrieval systems.

Format:

Electronic Resources

Electronic Access:

Click here to view

Publication Date:

2013

Publication Information:

Packt Publishing, 2013.

Available:*

Shelf Number	Material Type	Copy	Shelf Location	Status
005.75 23	1:E-BOOK	1	1:ONLINE	Searching... Unknown

Bound With These Titles

On Order

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.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the solution to some of the most well-known problems you could encounter as DBAs.