RMAN

Abstract: The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more Table of contents Part I: Database Architecture Chapter 1. Getting Started with the Oracle Architecture Chapter 2. Upgrading to Oracle Database 11g Chapter 3. Planning and Managing Tablespaces Chapter 4. Physical Database Layouts and Storage Management Part II: Database Management Chapter 5. Developing and Implementing Applications Chapter 6. Monitoring Space Usage Chapter 7. Managing Transactions with Undo Tablespaces Chapter 8. Database Tuning Chapter 9. Database Security and Auditing Part III: High Availability Chapter 10. Real Application Clusters Chapter 11. Backup and Recovery Options Chapter 12. Using Recovery Manager (RMAN) Chapter 13. Oracle Data Guard Chapter 14. Miscellaneous High Availability Features Part IV: Networked Oracle Chapter 15. Oracle Net Chapter 16. Managing Large Databases Chapter 17. Managing Distributed Databases Appendix: Installation and Configuration Index

Abstract: The invention relates to an Oracle table-level backup and recovering method for full-automatic continuously producing databases. The method comprises the following steps: 1) copying Oracle data to a remote backup server through a client in a RMAN sbt physical backup mode, and 2) recovering the data from the backup server by the client when the table-level recovering is required. Compared with the prior art, the Oracle table-level backup and recovering method for full-automatic continuously producing databases has the advantages that the manual operation for the Oracle database is not required, the maintenance difficulty of the user is greatly reduced, the production of the databases is not stopped so that the production service is not interrupted, and the data at any time in a backup period can be recovered so that the purpose of recovering the lost data as accurate as possible is achieved.

Abstract: FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11g Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components Improved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compression New Database Advisors for data recovery and repair, partitioning, and streams performance New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization Improved auditing and security capabilities Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements

Abstract: Pro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He wont leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isnt about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have buck stops here responsibility for an Oracle database, then Pro Oracle Database12c Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. Covers multi-tenant container and pluggable database implementation and management Condenses and organizes the core job of a database administrator into one volume. Takes a results-oriented approach to getting things done. Lays a foundation upon which to build a senior level of expertise What youll learn Create a stable environment consistent across all databases that you manage Manage pluggable and multi-tenant databases Take care of job #1: backing up, and then recovering when needed Manage users and objects, and the security between them Do battle with largelarge databases and large objects Move and distribute data using Data Pump, materialized views, external tables Automate critical jobs and tackle database troubleshooting problems Who this book is for Pro Oracle Database 12c Administration is aimed at new database administrators who aspire to senior positions in which employers and customers trust you to work independently, and with a buck stops here attitude. Table of Contents Installing the Oracle Binaries Implementing a Database Configuring an Efficient Environment Tablespaces and Datafiles Managing Control Files and Online Redo Logs Users and Basic Security Tables and Constraints Indexes Views, Synonyms, and Sequences Data Dictionary Fundamentals Large Objects Partitioning: Divide and Conquer Data Pump External Tables Materialized Views User-Managed Backup and Recovery Configuring RMAN RMAN Backups and Reporting RMAN Restore and Recovery Oracle Secure Backup Automating Jobs Database Troubleshooting Pluggable Databases