Paint: Decorating with Water-based Paints

Content: 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.